What is the xlsx format file?

xlsx is a table file of Microsoft "Office Excel"; xlsx is a compressed file based on the "Office Open XML" standard that replaces the previous proprietary default file format, adding an "x" after the traditional file extension. , and any word processing software that can open an ".xlsx" file can convert the document to an ".xls" file.

The operating environment of this tutorial: Windows 10 system, Dell G3 computer.

What file is xlsx

xlsx is the table extension of Microsoft Office Excel 2007, 2010, 2013, 2016, and 2019 versions.

lsx is the extension of Microsoft Office EXCEL 2007/2010/2013/2016/2019 documents. Its compressed file format based on the Office Open XML standard replaces its previous proprietary default file format, adding the letter "x" to the traditional file name extension (i.e. ".docx" replaces ".doc", ".xlsx" ” instead of “.xls”, “.pptx” instead of “.ppt”). Any word processing software that can open ".xlsx" files can convert the document to ".xls" files, which take up less space than ".xls" files.

Extended knowledge:

When users of officeOffice 2000, XP, and 2003 try to open files in the ".xlsx" or ".docx" format, they often will fail. This is because the version used is incompatible with a lower version. The above users can open this type of file on the system where the file was generated (office2007) before receiving or copying this type of file. File>Save As>2000~ 2003 format document.

In addition, Microsoft has launched an Office compatibility patch. By applying this compatibility patch, users of Office 2000, XP, and 2003 can open, edit, and save the new formats used in Word, Excel, and PowerPoint 2007. documentation. This compatibility patch can also be used with Office Word Viewer 2003, Excel Viewer 2003 and PowerPoint Viewer 2003 to view files saved in the new format.

The ".xlsx" format file is essentially a ZIP file. After changing the suffix of a ".xlsx" file to ZIP, you can use a decompression tool to open or decompress it. In fact, the basic file of Word2007 is in ZIP format, which can be regarded as a container of ".xlsx" files.

The main content of the ".xlsx" format file is saved in XML format, but the file is not saved directly on the disk. It is saved in a ZIP file and then takes the extension ".xlsx". Change the suffix of the file in the ". The document.xml file contains the main text content of the document.

The latest version of WPS 2007 can open files in ".xlsx" format.

Summary of differences:

".xls" is the format of the Microsoft Office Excel worksheet in the 03 version of Office. When using the 03 version of Office, the Excel file format is saved by default when creating a new Excel. The suffix is ​​".xls";

".xlsx" is the format of Microsoft Office Excel worksheet in version 07 of Office. When using version 07 of Office, the default Excel file format suffix saved in new Excel is ".xlsx" .

07 version of Office Excel can open and edit Excel files of version 07 (suffix ".xlsx"), and can also open and edit Excel files of version 03 (suffix ".xls") without garbled characters. Or stuck. However, Office Excel version 03 can only open and edit Excel files of version 03 (suffix ".xls"); if you open and edit Excel files of version 07 (suffix ".xlsx"), garbled characters may appear or the operation may not begin. It got stuck in the end.

".xls" is a unique binary format, and its core structure is a compound document type structure, while the core structure of ".xlsx" is an XML type structure, using XML-based compression. Make it take up less space. That's what the last "x" in ".xlsx" means.

For more related knowledge, please visit the FAQ column!

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