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.