What is the file format of xlsx?

xlsx is the format of table files in Microsoft "Office Excel"; the xlsx format is essentially a zip file, and the main content saved is in XML format, but the file is not saved directly on the disk, but in A zip file, and then take the extension ". content.

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

What is the format of xlsx file?

xlsx is the format of table file in Microsoft “Office Excel”

Basic information

When users of officeOffice 2000, XP, and 2003 try to open files in the ".xlsx" or ".docx" format, they often fail. This is the reason for the incompatibility of using a lower version. The above users can open this type of file on the system where the file was generated (office 2007) 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 2022 can open files in the ".xlsx" format.

Expand knowledge

".xls" is the format of the Microsoft Office Excel worksheet in version 03 of Office. When using version 03 of Office, the default for new Excel is The suffix of the saved Excel file format is “. 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 file format of xlsx?. For more information, please follow other related articles on the PHP Chinese website!