wksFileFormat Values

Enumeration

Value

Description

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.

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]

wksFileFormatDbf

15

ASCII Database [.DBF]

wksFileFormatXlsx

16

Microsoft Excel 2007 Spreadsheet [.XLSX]

wksFileFormatMdb

17

Microsoft Access Database [.MDB]

wksFileFormatMid

28

MapInfo Data [.MID]