wksFileFormat Values

 

Value

Description

wksFileFormatDat

Golden Software Data [.DAT]

wksFileFormatSlk

Microsoft SYLK [.SLK]

wksFileFormatCsv

Comma Separated Variables [.CSV]

wksFileFormatText

ASCII Data [.TXT]

wksFileFormatExcel

Microsoft Excel Spreadsheet [.XLS]

wksFileFormatBna

Atlas Boundary [.BNA]

wksFileFormatBln

Golden Software Blanking [.BLN]

wksFileFormatWk1

Lotus 123 (WK1) [.WK1]

wksFileFormatWk3

Lotus 123 (WK3) [.WK3]

wksFileFormatWk4

Lotus 123 (WK4) [.WK4]

wksFileFormatWks

Lotus 123 (WKS) [.WKS]

wksFileFormatWrk

Lotus Symphony (WRK) [.WRK]

wksFileFormatWr1

Lotus Symphony (WR1) [.WR1]

wksFileFormatUnknown

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.