|
|
|
method SaveToExcel(Filename: String, [WithHeaders: Boolean, Sheet: Variant, StartFromCol: String, StartFromRow: Number, EndColumn: String, EndRow: Number])
SaveToExcel method saves a Memory Table to an Excel file.
SaveToExcel method syntax has these named arguments:
Parameter |
Description |
|---|---|
File Name |
Required. Name of the Excel file to save to. |
With Headers |
Optional. When True, a header line will be included. Defaults to False. |
Sheet |
Optional. The Excel worksheet name or number to save to. Note: Do not use apostrophes (') in worksheet names, as this can cause problems. |
Start From Col |
Optional. The column to start save to. Defaults to column "A". |
Start From Row |
Optional. The row to start save to. Defaults to Row 1. |
End Column |
Optional. The column to end save to. |
End Row |
Optional. The row to end save to. |
Note: You can use the End Column and End Row parameters to overwrite existing data in a worksheet. Data in the sheet will be cleared up to the End Column and End Row.
For example:
MemTable.SaveToExcel(FileName: String[, WithHeaders: Boolean, Sheet: Variant, StartFromCol: String, StartFromRow: Number, EndColumn: String, EndRow: Number])
|
|
|
