HotXLS 文档

SaveAs 方法

Saves the Worksheet in a file or stream. Returns 1 if it succeeds

语法

function SaveAs(FileName: WideString; FileFormat: TXLSFileFormat): Integer;
function SaveAs(Stream: TStream; FileFormat: TXLSFileFormat): Integer;
FileName WideString。指示要保存文件名的字符串。可以包含完整路径;若不包含,组件会把文件保存到当前文件夹
FileFormat TXLSFileFormat. A value that indicates format of the file to be saved
Stream TStream. Saves to a stream specified in the Stream parameter

说明

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)

示例

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);