本文详细列举了Microsoft Excel中可用的各种文件格式，包括从早期版本到最新版本的格式，如CSV、XLS、XLSX等，以及它们的扩展名和用途，为用户提供了全面的Excel文件格式指南。
From : https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat
xlFileFormat enumeration (Excel)
Specifies the file format when saving the worksheet.
| Name | Value | Description | Extension |
|---|---|---|---|
| xlAddIn | 18 | Microsoft Excel 97-2003 Add-In | *.xla |
| xlAddIn8 | 18 | Microsoft Excel 97-2003 Add-In | *.xla |
| xlCSV | 6 | CSV | *.csv |
| xlCSVMac | 22 | Macintosh CSV | *.csv |
| xlCSVMSDOS | 24 | MSDOS CSV | *.csv |
| xlCSVWindows | 23 | Windows CSV | *.csv |
| xlCurrentPlatformText | -4158 | Current Platform Text | *.txt |
| xlDBF2 | 7 | Dbase 2 format | *.dbf |
| xlDBF3 | 8 | Dbase 3 format | *.dbf |
| xlDBF4 | 11 | Dbase 4 format | *.dbf |
| xlDIF | 9 | Data Interchange format | *.dif |
| xlExcel12 | 50 | Excel Binary Workbook | *.xlsb |
| xlExcel2 | 16 | Excel version 2.0 (1987) | *.xls |
| xlExcel2FarEast | 27 | Excel version 2.0 far east (1987) | *.xls |
| xlExcel3 | 29 | Excel version 3.0 (1990) | *.xls |
| xlExcel4 | 33 | Excel version 4.0 (1992) | *.xls |
| xlExcel4Workbook | 35 | Excel version 4.0. Workbook format (1992) | *.xlw |
| xlExcel5 | 39 | Excel version 5.0 (1994) | *.xls |
| xlExcel7 | 39 | Excel 95 (version 7.0) | *.xls |
| xlExcel8 | 56 | Excel 97-2003 Workbook | *.xls |
| xlExcel9795 | 43 | Excel version 95 and 97 | *.xls |
| xlHtml | 44 | HTML format | *.htm; *.html |
| xlIntlAddIn | 26 | International Add-In | No file extension |
| xlIntlMacro | 25 | International Macro | No file extension |
| xlOpenDocumentSpreadsheet | 60 | OpenDocument Spreadsheet | *.ods |
| xlOpenXMLAddIn | 55 | Open XML Add-In | *.xlam |
| xlOpenXMLStrictWorkbook | 61 (&H3D) | Strict Open XML file | *.xlsx |
| xlOpenXMLTemplate | 54 | Open XML Template | *.xltx |
| xlOpenXMLTemplateMacroEnabled | 53 | Open XML Template Macro Enabled | *.xltm |
| xlOpenXMLWorkbook | 51 | Open XML Workbook | *.xlsx |
| xlOpenXMLWorkbookMacroEnabled | 52 | Open XML Workbook Macro Enabled | *.xlsm |
| xlSYLK | 2 | Symbolic Link format | *.slk |
| xlTemplate | 17 | Excel Template format | *.xlt |
| xlTemplate8 | 17 | Template 8 | *.xlt |
| xlTextMac | 19 | Macintosh Text | *.txt |
| xlTextMSDOS | 21 | MSDOS Text | *.txt |
| xlTextPrinter | 36 | Printer Text | *.prn |
| xlTextWindows | 20 | Windows Text | *.txt |
| xlUnicodeText | 42 | Unicode Text | No file extension; *.txt |
| xlWebArchive | 45 | Web Archive | *.mht; *.mhtml |
| xlWJ2WD1 | 14 | Japanese 1-2-3 | *.wj2 |
| xlWJ3 | 40 | Japanese 1-2-3 | *.wj3 |
| xlWJ3FJ3 | 41 | Japanese 1-2-3 format | *.wj3 |
| xlWK1 | 5 | Lotus 1-2-3 format | *.wk1 |
| xlWK1ALL | 31 | Lotus 1-2-3 format | *.wk1 |
| xlWK1FMT | 30 | Lotus 1-2-3 format | *.wk1 |
| xlWK3 | 15 | Lotus 1-2-3 format | *.wk3 |
| xlWK3FM3 | 32 | Lotus 1-2-3 format | *.wk3 |
| xlWK4 | 38 | Lotus 1-2-3 format | *.wk4 |
| xlWKS | 4 | Lotus 1-2-3 format | *.wks |
| xlWorkbookDefault | 51 | Workbook default | *.xlsx |
| xlWorkbookNormal | -4143 | Workbook normal | *.xls |
| xlWorks2FarEast | 28 | Microsoft Works 2.0 far east format | *.wks |
| xlWQ1 | 34 | Quattro Pro format | *.wq1 |
| xlXMLSpreadsheet | 46 | XML Spreadsheet | *.xml |
扫一扫
1051
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
