What is the difference between xlsx and xls?

Difference: 1. xls is the default format used by excel versions before 2007; xlsx is the default format used by excel versions after 2007, including the 2007 version. 2. The XLSX format takes up less space than XLS.

"xlsx and xls are both excel file name extensions. xls was used by early excel, and xlsx was only used in subsequent excel versions. So xlsx and xls What are the differences? The following article will introduce it to you.

The difference between excel xlsx and xls

1. xls is used by versions before excel 2007 Default format. xlsx is the default format used by excel 2007 and later, including the 2007 version.

2. The XLSX format takes up less space than XLS. xlsx is replaced by a new XML-based compressed file format The default file format of xls has been changed.

3. Versions before excel 2007 cannot directly open the xlsx format, and lower versions are incompatible. However, it can be opened and edited by installing the office compatibility patch package bai.

4. Versions after excel 2007 can directly open XLS and xlsx. The software is backward compatible. If you want to enable lower versions to be opened, you can select the excel 97-2003.xls format when saving.

5. A file in xlsx format is essentially a ZIP file. Change the extension of the XLSX (or

##xlsxlsx2007 and later versionsCan directly open xls, xlsx formatCan have 1048576 rows and 16384 columns takes up a small space and the calculation speed will be faster

	##97-2003 version
	Can only open xls format, cannot directly open xlsx format
	Only 65536 rows, 256 columns
	takes up a lot of space

The above is the detailed content of What is the difference between xlsx and xls?. For more information, please follow other related articles on the PHP Chinese website!