Documentazione HotXLS

SaveAs metodo

Saves the Worksheet in a file o stream. Restituisce 1 if it succeeds

Sintassi

funzione SaveAs(FileName: WideString; FileFormat: TXLSFileFormat): Integer;
funzione SaveAs(Stream: TStream; FileFormat: TXLSFileFormat): Integer;
FileName WideString. Una stringa che indica il nome del file da salvare. È possibile includere un percorso completo; in caso contrario, il componente salva il file nella cartella corrente
FileFormat TXLSFileFormat. A value that indicates format of the file to be saved
Stream TStream. Saves to a stream specified in the Stream parameter

Descrizione

FileFormat can be one of these TXLSFileFormat constants
xlRTF RTF file format
xlHTML HTML file format
xlCSV Comma separated values file format (CSV)
xlText Tab separated values file format (TSV)
xlUnicodeCSV Comma separated unicode values file format (CSV)
xlUnicodeText Tab separated unicode values file format (TSV)

Esempio

This example saves the Worksheet one as CSV file

Workbook.Sheets[1].SaveAs('sheet.csv', xlCSV);
This example saves the Worksheet one as RTF file

Workbook.Sheets[1].SaveAs('sheet.rtf', xlRTF);
This example saves the Worksheet one as HTML file

Workbook.Sheets[1].SaveAs('sheet.html', xlHTML);
This example saves the Worksheet one as TSV file

Workbook.Sheets[1].SaveAs('sheet.tsv', xlText);
This example saves the Worksheet one as unicode TSV file

Workbook.Sheets[1].SaveAs('sheet.tsv', xlUnicodeText);
This example saves the Worksheet one as unicode CSV file

Workbook.Sheets[1].SaveAs('sheet.csv', xlUnicodeCSV);