XLS(Microsoft Excel 二进制电子表格)
XLS 是 Excel 97-2003 使用的旧版二进制电子表格格式。它以专有的复合二进制结构存储工作表、公式和图表。虽然已被 XLSX 取代,但许多遗留系统仍然生成和需要 .xls 文件。
MIME 类型
application/vnd.ms-excel
类型
二进制
压缩
无损
优点
- + Broad compatibility with older Excel versions and legacy enterprise tools
- + Well-documented binary format with mature parsing libraries
- + Supports VBA macros and embedded objects
缺点
- − Row limit of 65,536 and column limit of 256 per worksheet
- − Larger file sizes than compressed XLSX
- − Proprietary binary format is harder to work with programmatically
何时使用 .XLS
仅在需要与无法读取 XLSX 的遗留系统交互时使用 XLS;其他情况请选择 XLSX 或 CSV。
技术细节
XLS 使用 OLE2 复合文档中的 BIFF8 记录格式。每种记录类型在顺序二进制流中编码单元格值、公式、格式和工作表元数据。
历史
二进制 .xls 格式在 1990 年代末和 2000 年代是主导的电子表格格式。Microsoft BIFF8(二进制交换文件格式)是向 Open XML 过渡前的最后一个主要二进制版本。
从 .XLS 转换
转换为 .XLS
相关格式
Learn More
File Format Conversion: A Complete Guide
Converting files between formats is a daily task for professionals across every industry. This comprehensive guide covers document, image, audio, …
CSV vs JSON vs XML: Data Exchange Formats Compared
Data exchange formats serve different needs. CSV excels at tabular data, JSON dominates web APIs, and XML powers enterprise integrations. …
How to Convert Documents Between Office Formats
Converting between Word, Google Docs, LibreOffice, and PDF formats is common in collaborative workflows. This guide covers conversion paths that …
Understanding MIME Types and File Extensions
MIME types tell browsers and servers what kind of data a file contains, while file extensions help humans and operating …
Troubleshooting File Conversion Errors
File conversions fail for many reasons: corrupted sources, unsupported features, encoding mismatches, and memory limitations. This guide helps you diagnose …
Archive Formats Compared: ZIP, 7z, TAR, and RAR
Archive formats bundle and compress multiple files into a single package. ZIP is universal, 7z offers the best compression, TAR …