Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel File Version Identification
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01176025
Message ID:
01176028
Views:
16
? oExcel.ActiveWorkbook.FileFormat

Constant Value 
xlAddIn  18 
xlCSV  6 
xlCSVMac  22 
xlCSVMSDOS  24 
xlCSVWindows  23 
xlCurrentPlatformText  -4158 
xlDBF2  7 
xlDBF3  8 
xlDBF4  11 
xlDIF  9 
xlExcel2  16 
xlExcel2FarEast  27 
xlExcel3  29 
xlExcel4  33 
xlExcel4Workbook  35 
xlExcel5  39 
xlExcel7  39 
xlExcel9795  43 
xlHtml  44 
xlIntlAddIn  26 
xlIntlMacro  25 
xlSYLK  2 
xlTemplate  17 
xlTextMac  19 
xlTextMSDOS  21 
xlTextPrinter  36 
xlTextWindows  20 
xlUnicodeText  42 
xlWebArchive  45 
xlWJ2WD1  14 
xlWJ3  40 
xlWJ3FJ3  41 
xlWK1  5 
xlWK1ALL  31 
xlWK1FMT  30 
xlWK3  15 
xlWK3FM3  32 
xlWK4  38 
xlWKS  4 
xlWorkbookNormal  -4143 
xlWorks2FarEast  28 
xlWQ1  34 
xlXMLData  47 
xlXMLSpreadsheet  46 
>
>
>With the above mentioned code i am making necessary processing on the excel file. The Excel version i am using is Excel 2003 and i can open unprocessed and processed files in that excel version.
>
>When these processed files reached to the client he states that they are not Excel 2003 files but Excel 2000 or Excel 97 files. Any suggestions or method to know which Excel version a .xls file belong.
>
<snip>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform