wksFileFormat Values
Option |
Value |
Description |
wksFileFormatDat |
1 |
Golden Software Data .DAT |
wksFileFormatSlk |
2 |
Microsoft SYLK .SLK |
wksFileFormatCsv |
3 |
Comma Separated Variables .CSV |
wksFileFormatText |
4 |
ASCII Data .TXT |
wksFileFormatExcel |
5 |
Microsoft Excel Spreadsheet .XLS |
wksFileFormatBna |
12 |
Atlas Boundary .BNA |
wksFileFormatBln |
14 |
Golden Software Blanking .BLN |
wksFileFormatXlsx |
16 |
Microsoft Excel Spreadsheet 2007-2010 .XLSX |
wksFileFormatUnknown |
-3 |
When used with Merge the file format is inferred based on the file name extension, if this is used with SaveAs the file format is: 1. inferred from the file name extension, or 2. if the extension is not recognized then the saved format is the same format as the file the worksheet was loaded from, or 3. if the worksheet data were created from scratch, the file is saved in the XLS format. |