application type xlsx

The correct MIME type for doc xlsx, pptx, etc

MIME is the abbreviation of Multipurpose Internet Mail Extension, allowing files to be sent over the internet. This format allows users to send and receive spreadsheets and other documents via internet mail. This article shall discuss various correct MIME types of various extensions.

MIME types for Excel documents

Excel documents can be viewed via the internet by converting the data to MIME format. In Excel, there are various extensions, and these extensions have various MIME types. The mime type format is usually divided into two sections using the slash (/) operator.

Some of the MIME types used in excel are shown below, along with their extensions

.xls .xls is an extension found in Microsoft Excel spreadsheet 2003. The MIME type supported by these extensions is application/vnd.ms-excel.

Note: Excel 2007 supports this extension .xls.

. xlsx This is the latest extension in Excel. It is found in excel 2007 and other latest versions of excel. If you create a document in Excel 2007, it is saved with an extension of .xlsx .

.xltx This is an extension used with Microsoft excel templates. The MIME format that supports this extension is the application/vnd.openxmlformats-office document. spreadsheet my.template.

. xlsm This is an excel document that has macro-enabled. The last "m" shows that the file contains macros.

. xlam, this extension indicates the file has an Excel macro-Enabled Add-in data.

. xlsb this is an extension for the Excel Binary Workbook file.

MIME-type for Word Document

Some of the MIME formats used with word document extensions are:

. doc – This extension is used for saving Microsoft word files.

.docx- It is an extension that uses Microsoft documents with OpenXml.

.eot- It is an extension used in Microsoft Embedded Open Type fonts.

MIME-type for PowerPoint

There are two main extensions in PowerPoint; each of these extensions has its MIME type.

. pptx – application/vnd.openxmlformats-officedocument.presentationml.pr

. ppt – application/vnd.ms-powerpoint

Other MIME types are:

How-To Geek

What is an xlsx file (and how do i open one).

It wasn't named with pronounceability in mind.

Quick Links

What is an xlsx file, how do i open an xlsx file, key takeaways.

An XLSX file is a Microsoft Excel spreadsheet. The XLSX file format is supported by most spreadsheet applications, including Excel, Apple Numbers, OpenOffice, LibreOffice Calc, and more.

A file with the .xlsx  file extension is a Microsoft Excel Open XML Spreadsheet (XLSX) file created by Microsoft Excel. You can also open this format in other spreadsheet apps, such as Apple Numbers, Google Docs, and OpenOffice. They are stored as a compressed Zip file, which contains a bunch of other files used to open the document.

Related: What Is A File Extension?

XLSX files are files used in Microsoft Excel, a spreadsheet application that uses tables to organize, analyze, and store data. Each cell can contain text or numerical data, including incorporating mathematical formulas.

First introduced with Microsoft Office 2007 in the Office Open XML standard, XLSX is the default format when creating a spreadsheet using modern versions of Excel. Microsoft introduced this open format largely due to increased competition from Open Office and its Open Document Format (ODF). The XLXS format replaced the proprietary XLS format that Excel used previously.

Related: What Is a .DOCX File, and How Is It Different from a .DOC File in Microsoft Word?

Because XLSX files have become standardized, you can open them in many applications on different platforms. Although Windows doesn't natively open them unless you have a copy of Microsoft Office 2007 or later, you can download a third-party open-source application like Apache OpenOffice or LibreOffice to open your files.

Mac users just need to double-click on the file and it will open in the Apple Numbers application.

If you'd rather store, open, and edit all your Office Open XML files in the cloud, you can do so by uploading your document via  Excel Online or  Google Sheets.

Alternatively, if you're a Chrome user, you can download the extension  Office Editing for Docs, Sheets & Slides  (an official Google extension) for your browser. It lets you upload any XLSX file directly from your local hard drive to your Google Drive by dragging and dropping it into any Chrome tab.

Related: How to Work with Microsoft Office Files in Google Drive

MIME Types of Microsoft Office File Formats

Info by Axuter | Last update on 2023-01-29 | Created on 2015-01-06

This is a list of the MIME Types of all well known and lesser known file formats and kinds of documents from the Microsoft Office family.

You can find the MIME Types in the table ordered by the corresponding application Microsoft Word, Excel, Power Point and Access as well as the extension of the file.

Microsoft Word

Microsoft excel, microsoft powerpoint, microsoft access.

I hope, I could help you with this list. If I should have forgotten something, just write a comment.

About the Author

Related Topics

Fonts for windows, linux and mac on the web.

Article | 0 Comments

MySQL: Delete Data from Table - Difference between TRUNCATE, DELETE and DROP

Tutorial | 0 Comments

SQLite: Check whether Table exists

Info | 0 Comments

Convert many CSV Files to XLSX or ODS Spreadsheets

Is there a default mime type.

Question | 1 Answer

MySQL: 3 Ways of showing Table Definition and Structure

How to resize image before upload in browser.

Tutorial | 13 Comments

Important Note

Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more .

Participate

Ask your own question or write your own article on askingbox.com. That’s how it’s done .

• Ask Question
• Advanced Search
• User Top 100
• Advertise here

Deutsch | English | Español | Français

Legal Notice | Terms of Use | Privacy | Imprint

© Stefan Trost Media 2011-2024 | Webdesign by STT Media

Professor Excel

Let's excel in Excel

XLSX, XLSM or XLSB: Which File Type Is the Best for You?

Probably 99% of all Excel workbooks are saved in the XLSX file type these days. But there are various other file extensions available: For example XLSM, XLSB or “older” Excel users might still remember the XLS file type. What are the differences of these file types? And even more important: Which one should you use?

When you save an Excel workbook for the first time or use the “Save As” function, you are asked for a folder, file name as well as the file type. By default, Excel suggests the XLSX file type (unless your file has VBA macros). The window looks similar to the screenshot on the right side.

So which file type are you going to use? The answer – like so often: It depends. Before we conclude in a decision tree, we we take a look at the most important file extensions in Excel with their advantages and disadvantages first.

The “default” file extension is XLSX. The large majority of Excel workbooks uses this format these days. Microsoft says in the Excel help text about the XLSX file format:

The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code […].

Most of the time you use the XLSX format: It’s save (can’t store malicious code), has the maximum number of rows and columns and is best known. XLSX is available since Excel 2007 and replaces the old XLS file type. It uses the open XML standard so which is documented well.

Knowing these quick facts, there are the following advantages and disadvantages for the XLSX file format:

The XLS file type has been the default Excel file extension and format before Excel 2007. In Excel 2007, XLSX replaced the XLS format. Therefore, XLS is kind of outdated right now. In the daily life you won’t find it often any more. But some data base tools still export data as XLS files.

The XLS file type has some disadvantages towards the newer file types XLSX or XLSM: It’s rather unsafe as it can contain VBA macros with malicious code. Also, it needs more disk space than the other file types and at the same time has less rows and columns.

On the other side the only advantage: You can easily open XLS files with older versions of Excel.

If you include VBA macros in your XLSX file, you will be asked to change the file extension to XLSM. Only that way you can save your macro within the Excel file (there are other file types possible, e.g. XLSB – but you can’t use XLSX for VBA macros). Therefore, it has most of the advantages and disadvantages of the XLSX file type. Positive: You can immediately identify Excel files with VBA macros.

Many people don’t know that there is an actual alternative to the XLSX and XLSM file type: The XLSB file extension. XLSB files store the data a little bit different than the XLSX or XLSM file types: They don’t use the XLM file structure. Instead, XLSB files try to save disk space because the data is stored in the binary structure. The main difference: Binary files are computer- but not human-readable. For more information on binary files in general, please refer to this Wikipedia entry .

The main disadvantage: Binary Excel files can contain VBA macros. So unless you don’t know the origin of a file, please consider well before opening them. Besides that: All the other disadvantages seem minor.

Do you want to boost your productivity in Excel ?

Get the Professor Excel ribbon!

Add more than 120 great features to Excel!

CSV stands for comma separated values. These files are basically plain text – so there are no formulas or formatting. CSV is often used for data exchange. Excel provides the functionality to import or even directly open CSV files.

The basic application for CSV files: Import or export data. Data base programs often export data as CSV files. Also if you want to transport Excel data into a database program, often the CSV file type works.

ODS stands for Open Document Spreadsheet. The file type is designed to work on both Excel and other applications, e.g. LibreOffice. From the Excel point of view, ODS doesn’t support all the features. Text and data is usually saved well though. But formatting and many other features (for example charts, tables, conditional formatting) might run into problems.

XLSX (Strict)

Besides the regular XLSX format, Excel offers to save your Excel workbook as “Strict Open XML Spreadsheet”. So what is the difference between those two? Basically, the two file types use the same structure. But :

The Strict variant has less support for backwards compatibility when converting documents from older formats.

Furthermore :

The Strict variant of XLSX disallows a variety of elements and attributes that are permitted in the more common Transitional variant […]

As you’ve probably heard of PDF files, we won’t go much into detail here. PDF stands for portable document format and has the reputation of not easily being manipulated. Also, it’s quite save to say that how a PDF file looks on your computer, it will most probably look like this on most other computers.

And that’s it for the advantages. I recommend using it when you present your final results in the following cases:

• The recipient of your file should not edit it any more.
• Formatting should be exactly preserved.
• There is no database included, just the summarized results.

That could be the case if somebody wants to check your results on an iPad or a similar device. But: In many cases it would be professional (and nice) to also send at least parts of your Excel file. That way, your recipient could at least take a look at the calculation process.

XLAM is the file extension for Excel add-ins. Also our add-ins (for example the popular “ Professor Excel Tools “) are XLAM files. They can contain VBA macros, worksheets as well as forms, images and individual ribbons. If you double click on such file, it will open in Excel and you can use the funcationality of the add-in. But next time you open Excel again, it won’t be available any longer. You rather have to enable the add-in within the options (File –> Options –> Add-Ins).

As the XLAM file type is not really an alternative for all the other file extensions above, we skip the advantages and disadvantages.

Comparison of file types

So if we put all the advantages, disadvantages and facts from above together, we come to the following comparison:

Which file type should you use?

Decision tree.

In order to define the best file type for your Excel workbook, please follow the decision tree.

• The first question: Do you just want to display your results only? Then you could also consider the PDF format. But if the recipient of your work wants to edit or follow up your calculations, you shouldn’t use PDF.
• If yes, choose XLSB if you have a large file. Choose XLSM for a file size smaller than app. 10 MB.
• If no and you got a large file (larger than app. 10 MB), also choose XLSB.
• If no (you don’t have macros) and your file small, follow the tree on the right hand side.
• The lower two levels of the decision tree are just about compatibility: If you want to open and edit your workbook with another software, choose the strict XLSX or ODF format.
• If you want to make sure that you can open it with versions of Excel 2003 or earlier, go for XLS.

In conclusion, you can distill a quite short table (if you don’t need to consider old file types and other applications as LibreOffice). You just have to answer two questions: Do you need VBA macros and do you work with a large amount of data?

Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

10 comments

Wonderful information on Excel. It answered many questions I have had for a long time and didn’t know where to find the answers. You pulled a lot on information together in a succinct presentation. Thanks Much!!!

Hi Foster, Thanks for the reply. I’m glad it has helped you! Best regards, Henrik

I am surprised that your pros/cons don’t list any performance issues with binary files. I can’t have any large pivot tables in a binary file or it freezes up.

Thanks for the feedback, Mark. Does this always happen to you working in the xlsb file format? I haven’t noticed any issues – at least not more than in the xlsx or other file formats.

You need to check what you are telling people

“Excel suggests the XLSX file type (unless your file doesn’t have VBA macros)” is misleading.

“Can only use up to 65,536 (2^16) rows and 256 (2^8) rows.” is just wrong.

Hi Bloodknot,

Thanks for the feedback. Please provide any proof for your accusations. What do you mean with misleading? I suppose you refer to the sentence “By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros).” That’s exactly what happens when you save a new Excel file. And concerning the second part: What is wrong about it? It refers to the “XLS” file format. Please try it yourself: Save an Excel file as .xls, close Excel, open the file again and scroll to the right bottom corner. What is the maximum row number there? What is the maximum column?

I’m always happy about feedback and would gladly correct inaccurate information. So please provide any kind of evidence or proof supporting your comments.

Thanks and best regards, Henrik

“By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros).”

Shouldn’t this be unless your file HAS VBA macros? in which case it will suggest xlsm?

Thanks, Mark, I have corrected it accordingly.

It appears that worksheets cannot be saved in a .xlam file. Is that correct?

I have sevral functions that do lookups on multple arrays of data. I added the array into Named Ranges on a worksheet, thing this would make it easy to update the arrays when needed. Once I got everything working, I saved as .xlam and nothing works. When I open the .xlam, the workbook is gone.

What is the best file type for this? Or should I just put my lookup data into static arrays in the code?

Hi, I’m wanting to send a price list to customers with excel and have the formulas available to calculate the number of items as well as the total prices. My question is can an excel file be saved in a particular format so as the information stays as it is and only the inputted information (how many of…) is changeable, and it stills calculates the totals?

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

Privacy Overview

• Skip to main content
• Skip to search
• Skip to select language
• Sign up for free

此页面由社区从英文翻译而来。了解更多并加入 MDN Web Docs 社区。

常见 MIME 类型列表

这是一份 MIME 类型列表，以及各个类型的文档类别，按照它们的常见扩展名排序。

两种主要的 MIME 类型在默认类型中扮演了重要的角色：

• text/plain 表示文本文件的默认值。一个文本文件应当是人类可读的，并且不包含二进制数据。
• application/octet-stream 表示所有其他情况的默认值。一种未知的文件类型应当使用此类型。浏览器在处理这些文件时会特别小心，试图防止、避免用户的危险行为。

IANA 是 MIME 媒体类型的官方注册机构，并维护了 官方所有 MIME 类型的列表 。下面的表格列出了 Web 上的一些重要 MIME 类型：

• Get Great Eclipse Photos with Your Phone
• The Best Noise-Canceling Headphones to Buy

What Is an XLSX File?

How to open, edit, and convert XLSX files

• Emporia State University

• Western Governors University

In This Article

Jump to a Section

How to Open an XLSX File

How to convert an xlsx file.

• If You Can't Open the File
• Frequently Asked Questions

What to Know

• An XLSX file is a Microsoft Excel Open XML Format Spreadsheet file.
• Open one with Excel, Excel Viewer , Google Sheets , or another spreadsheet program .
• Convert one to CSV, XLS, ODS, etc., with some of those programs or a converter like ConvertFiles.com .

This article explains what XLSX files are, how to open them, and which programs are able to convert them to other spreadsheet formats like CSV or ODS.

A file with the XLSX file extension is a Microsoft Excel Open XML Format Spreadsheet file. It's a ZIP-compressed, XML-based spreadsheet file created by Microsoft Excel version 2007 and later.

XLSX files organize data in cells that are stored in worksheets, which are in turn stored in workbooks (files that contain multiple worksheets). The cells of a spreadsheet are positioned by rows and columns and can contain styles, formatting, math functions, and more.

Spreadsheet files made in earlier versions of Excel are saved in the XLS format. Excel files that support macros are XLSM files.

Lifewire / Chloe Giroux

Unless you've purposely installed a program to your computer that can open XLSX files, then double-clicking on one won't do anything useful. Instead, you need to have a specific program on your computer that can recognize the XLSX file.

Although Microsoft Excel (version 2007 and newer) is the primary software program used to both open XLSX files and edit XLSX files, you can install the Microsoft Office Compatibility Pack to open, edit, and save XLSX files using an older version of Excel.

If you have no intention to edit the XLSX file, and you just want to view it, you can install the free Microsoft Excel Viewer . It supports printing and copying data out of the XLSX file, too, which might be all you need to do.

You can also open and edit XLSX files without Excel, completely free, using WPS Office Spreadsheets , OpenOffice Calc , or LibreOffice Calc . If you're on a Mac, Apple Numbers supports XLSX files, too (but not all features will work).

Google Sheets , Microsoft Excel Online , and Zoho Docs are a few other ways you can open and edit XLSX files for free. Going this route requires you to upload the XLSX file to the website before you can make any changes.

If you use the Chrome web browser, you can install Office Editing for Docs, Sheets & Slides  as an extension, which lets you open and edit XLSX files directly in the browser, either by dragging a local XLSX file into Chrome or opening one from the internet without having to download it first.

Installing Chrome extensions is pretty straightforward, but if you need some step-by-step help, we have a guide on how to add extensions to Chrome .

If you have one of the applications we've already mentioned installed on your computer, it's recommended to use that same program to save whatever XLSX you're working with to the specific format you're interested in. This is normally done through the File > Save as menu option.

For example, if you're using Excel, go through its FILE > Save As > Browse menu and choose CSV, XLS, TXT, XML, etc. The F12 key should also work to get to the Save As window.

Sometimes the quickest solution to convert an XLSX file isn't with a tool you have installed, but instead via a free file conversion software program or online service like Zamzar .

Just looking at the capabilities of those two services, you can convert whatever Excel file you have to many different file types, like XLSX to CSV, XML, DOC, PDF, ODS, RTF, XLS, MDB, and even image and web file formats like JPG, PNG, and HTML.

TinyWow can split an Excel file if you want the XLSX file to end up as multiple files. That same site has an Excel to XML converter , and others that can save the file to PDF or CSV.

Still Can't Open the File?

The most likely reason for why the file won't open at this point, if you've tried all the suggestions above, is that you're not really dealing with an XLSX file. This might happen if you've only briefly looked at the file extension and are confusing it for an Excel file.

For example, maybe your file really ends in .LSX, in which case it's a Streaming Media Shortcut file and has nothing to do with Excel. Windows Media Player opens LSX files.

Similarly, it'd be easy to confuse an SLX file for one that has the Excel XLSX suffix, but SLX files are also unrelated to Excel and are instead used by programs like Simulink and SpectraLayers.

XLR is another one that's easy to mix up for an Excel file.

If you can't open the file, re-read the extension and research it online. It should be fairly easy to find more information about the format and learn which programs are able to open and convert it. We may even have a description of it here on Lifewire—use the search box at the top of this page to check.

To read an XLSX file in R, first copy the data from Excel, then import data from the clipboard into R.

You can read the file with the Python module named openpyxl. Download the openpyxl module , then use the Python import command to read the data from the XLSX file.

Get the Latest Tech News Delivered Every Day

• What Is an XLSM File?
• What Is an XLTX File?
• 6 Best Free Spreadsheet Programs
• What Is an XLSB File?
• What Is an XLTM File and How Do You Open One?
• What Is a CSV File?
• What Is an XLS File?
• What Is a DAT File?
• What Is an ODS File?
• What Is an ET File?
• How to Convert Excel Documents to the PDF Format
• What Is an XLK File?
• What Is a DOCX File?
• What Is an XLX File?
• What Is an MDB File?
• How to Create, Edit, and View Microsoft Excel Documents for Free

Learn about file formats

A file format specifies how data is stored for a particular application. For example, a .docx file is an Open XML formatted Microsoft Word document. Not all applications can read all file format; and in some cases an application may only be able to read parts of the file. For example, a application may be able to read the text, but not the formatting, of a file that uses a format other than its own.

OpenDocument Format (ODF) was originally developed to support the features and behavior of OpenOffice-based productivity suites and Open XML was originally developed to support the features and behavior of Microsoft Office.

Microsoft Office now provides support for ODF and gives people using Microsoft Office the chance to save their Office files in ODF. However, because Microsoft Office and OpenOffice features aren’t exactly the same or aren’t implemented the same way, people who use unsupported features and save Office files in ODF might experience changes in how they can work with the file and sometimes see a loss of content.

The Open XML format (.docx/.xlsx/.pptx) is the default format in all supported versions of Microsoft Office and, unless you have a specific reason to use a different format, it's the format we recommend using for your Office files.

To learn more about the Open Document Format (ODF) generally see  OASIS Open Document Format for Office Applications .

Learn more about the differences in file formats

Differences between the OpenDocument Spreadsheet (.ods) format and the Excel (.xlsx) format

Differences between the OpenDocument Presentation (.odp) format and the PowerPoint (.pptx) format

Differences between the OpenDocument Text (.odt) format and the Word (.docx) format

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Find solutions to common problems or get help from a support agent.

Online support

Was this information helpful?

Thank you for your feedback.

• Search the community and support articles
• Search Community member

Ask a new question

Default App for .xlsx files

I own and have installed Office 2010.  Somehow, I seem to have a license for Office 365, but have not "activatged" it.  My system recently changed the default app for .xlsx files to trying to install and use the Excel 2016 version instead of the 2010 version, if I select an .xlsx file from windows explorer.  Since this is my preferred method to open files, it has become aggravating.  How to I revert to 2010 as the default version of Excel?  Thanks.

Moved from: Windows / Windows 10 / Ease of access

Report abuse

Replies (11) .

* Please try a lower page number.

* Please enter only numbers.

• Microsoft Agent |

Hi BobLipop ,

You can try to changing the Choose default app by file type from Excel 2016 to Excel 2010 in Settings > Apps > Default apps > Choose default apps via file type . Then look for . xlsx on the list and change the app that is assigned to open that particular file type.

Let us know if this answers your question.

3 people found this reply helpful

Was this reply helpful? Yes No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Thanks for your feedback.

Had tried that but the only option there relates to Excel 2016, Nothing offers an option of Excel 2010. 

Thanks for the update. I would like to confirm on what version of Excel do you currently have on your computer. You can check it via Settings > Apps > Apps & features . Then look for Excel 2010 on the list under Apps & features.

I'll be waiting for your response.

I did not find Excel in the apps and features section.

The following is from the Help Option within Excel 2010.  (I don't know why it shows twice )

Thanks for your attention.

Has been a while.  I still have the problem.  Did my last comments include the screen shots?  Looking from my end, it seems that they did not. 

I appreciate your involvement.

Aplogies for the delay in response. If Excel 2010 is missing in your Apps & Features list, it is possible that your Excel 2010 has been upgraded to Office 365/2016. Please reinstall Office 2010 form this link  on where to Download Earlier Versions of Office . Afterwards you can change the Excel 2016 to Excel 2010 in the  Choose default app by file type option in Settings .

Let us know how it goes.

Thanks for the continued interest and the reply.

Reinstalled Office 2010 per your suggestion with the following results:

1)a) Selecting a .xlsx file from Windows Explorer now starts Excel 2010, but the selected file does not open.  The file will open if use File>Open inside Excel.

b) If I select a second file within Explorer, a second copy of Excel opens, but the selected file still does not open.

2) Settings>Apps and Features>Default Apps>Choose by File Type>.xlsx still shows the icon for excel 2016 as the sole entry.

I can certainly live with #2.  Am disappointed with 1)a) and feel that 1)b) would not be an advisable way to work.

Would appreciate your thoughts.

Hi BobLipop , You can try to changing the Choose default app by file type from Excel 2016 to Excel 2010 in Settings > Apps > Default apps > Choose default apps via file type . Then look for . xlsx on the list and change the app that is assigned to open that particular file type. Let us know if this answers your question.

Excel 2010 does not appear in the list.

Thanks for the continued interest and the reply. Reinstalled Office 2010 per your suggestion with the following results: 1)a) Selecting a .xlsx file from Windows Explorer now starts Excel 2010, but the selected file does not open.  The file will open if use File>Open inside Excel. b) If I select a second file within Explorer, a second copy of Excel opens, but the selected file still does not open. 2) Settings>Apps and Features>Default Apps>Choose by File Type>.xlsx still shows the icon for excel 2016 as the sole entry. I can certainly live with #2.  Am disappointed with 1)a) and feel that 1)b) would not be an advisable way to work. Would appreciate your thoughts.

I have read elsewhere that Excel 2010 does not appear in the list of default Apps as it is not an App. In the case of Word files, I can open these with the default option of "Office 2010 Component" but somehow, Excel 2010 does not seem to be a part of the "Office 2010 Component" option.

Question Info

• Norsk Bokmål
• Ελληνικά
• Русский
• עברית
• العربية
• ไทย
• 한국어
• 中文(简体)
• 中文(繁體)
• 日本語

• Latest Articles
• Top Articles
• Posting/Update Guidelines
• Article Help Forum

• View Unanswered Questions
• View All Questions
• View C# questions
• View C++ questions
• View Javascript questions
• View Visual Basic questions
• View Python questions
• CodeProject.AI Server
• All Message Boards...
• Running a Business
• Sales / Marketing
• Collaboration / Beta Testing
• Work Issues
• Design and Architecture
• Artificial Intelligence
• Internet of Things
• ATL / WTL / STL
• Managed C++/CLI
• Objective-C and Swift
• System Admin
• Hosting and Servers
• Linux Programming
• .NET (Core and Framework)
• Visual Basic
• Web Development
• Site Bugs / Suggestions
• Spam and Abuse Watch
• Competitions
• The Insider Newsletter
• The Daily Build Newsletter
• Newsletter archive
• CodeProject Stuff
• Most Valuable Professionals
• The Lounge  
• The CodeProject Blog
• Where I Am: Member Photos
• The Insider News
• The Weird & The Wonderful
• What is 'CodeProject'?
• General FAQ
• Ask a Question
• Bugs and Suggestions

content type for xlsx file

2 solutions

• Most Recent

Add your solution here

• Read the question carefully.
• Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
• If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Search code, repositories, users, issues, pull requests...

Provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mime-type always coming as application/zip #1402

siddarajusrikantaiah commented Jan 12, 2019

SheetJSDev commented Jan 23, 2019

Sorry, something went wrong.

LrVch commented Aug 19, 2020 • edited

No branches or pull requests

Gartner names MuleSoft a Leader

Unleash the power of Salesforce Customer 360 through integration

Anypoint Platform Fundamentals

MuleSoft at World Tour

© Copyright 2024 Salesforce, Inc. All rights reserved .

• DataWeave (2.6)
• Language Guide
• Supported Data Formats

Excel Format (XLSX)

Excel Format

MIME type: application/xlsx

An Excel workbook is a sequence of sheets. In DataWeave, this is mapped to an object where each sheet is a key. Only one table is allowed per Excel sheet. A table is expressed as an array of rows. A row is an object where its keys are the columns and the values the cell content.

The DataWeave reader for Excel input supports the following parsing strategies:

To understand the parsing strategies that DataWeave readers and writers can apply to this format, see DataWeave Parsing Strategies .

Excel Type Mapping

The following table shows how Excel types map to DataWeave types.

The following examples show uses of the Excel format.

Example: Represent Excel in the DataWeave (dw) Format

Example: output an excel table, example: stream excel input.

This example shows how DataWeave represents an Excel workbook.

The Excel workbook ( Sheet1 ) serves as an input payload for the DataWeave source.

The DataWeave script transforms the Excel input payload to the DataWeave (dw) format and MIME type.

The DataWeave output looks like this. You can select values the same way you select values in other objects.

The following DataWeave script outputs an Excel table with the header and fields.

The body of this DataWeave script is a DataWeave object that defines the content of the Excel sheet. The name of the sheet, Sheet1 , is the key of this object. The value is an array of objects. Each object in the array contains a collection of key-value pairs. The keys in each pair are treated as header values for the spreadsheet. The values in each pair are treated as data values for a row in the sheet.

The output directive indicates that the output is the Excel format and MIME type. The header=true setting indicates that the output includes the header values.

For another example, see Look Up Data in an Excel (XLSX) File .

By default, the Excel reader stores input data from an entire file in-memory if the file is 1.5MB or less. If the file is larger than 1.5 MB, the process writes the data to disk. For very large files, you can improve the performance of the reader by setting a streaming property to true .

The following Configuration XML for a Mule application streams an Excel file and transforms it to JSON.

The example:

Configures the HTTP listener to stream the XLSX input by setting outputMimeType="application/xlsx; streaming=true" . In the Studio UI, you can use the MIME Type on the listener to application/xlsx and the Parameters for the MIME Type to Key streaming and Value true .

Uses a DataWeave script in the Transform Message component to iterate over each row in the XLSX payload (an XLSX sheet called "Sheet Name" ) and select the values of each cell in the row (using row.a , row.b ). It assumes columns named a and b and maps the values from each row in those columns into foo and bar , respectively.

The following image shows the Excel table output.

Limitations

Macros are currently not supported.

Charts are ignored.

Pivot tables are not supported.

Formatting is currently not supported.

Configuration Properties

DataWeave supports the following configuration properties for this format.

Reader Properties

This format accepts properties that provide instructions for reading input data.

Writer Properties

This format accepts properties that provide instructions for writing output data.

Supported MIME Types

This format supports the following MIME types.

6 Ways to Open XLS and XLSX Files for Free

Having trouble opening XLS and XLSX files? Check out these free ways to easily access and view your Excel documents.

Perhaps somebody has sent you an XLS or XLSX file, and you don’t have the means to open it, or maybe you’ve moved away from the Microsoft Office suite but still have some files left over that you need to access.

Regardless of why, there are a bunch of different ways that you can open up Excel files entirely for free. Here are some of the very best ways to do just that.

1. Office Editing for Docs, Sheets & Slides

The first way to open XLS and XLSX files for free is to use the Chrome extension Office Editing for Docs, Sheets, & Slides. This extension comes automatically installed on many installations of Chrome, so for many users, you won’t even have to install anything extra in order to get it working.

If you don’t know how to find, install, and manage extensions in your browser , however, don’t fret. The process is really very easy to figure out.

Using the Office Editing extension itself couldn’t be easier. All you have to do is take an XLS or XLSX file and drag it into your browser. The extension will kick in automatically and open the file up as if you had Microsoft Excel installed, but in your browser.

The functionality here is obviously limited in comparison to the full product available from Microsoft, but it will let you quickly and easily view an XLS or XLSX file. There is even an option to create a new Excel file from scratch, or save the file into a Google Sheet.

2. Google Sheets

Speaking of, Google Sheets is the next solution on this list. Google Sheets is Google’s answer to Microsoft Excel, and is an entirely cloud-based service that allows you to make, edit, and input data into spreadsheets from within your browser.

It’s also capable of opening up XLS and XLSX files. All you have to do is navigate to the File heading menu, and then select either the Open or Import options. This will open a new window with several more headers, with the last one reading Upload . Drag your file here or select it from your file browser.

The best part here is once you’ve learned how to master the basic of Google Sheets , you’ll have full access to the entirety of Google Sheets tools and functionality for all your Excel files. Moreover, you can access it entirely from your browser, so you don’t have to worry about downloading anything that you may only use once, and you can access it anywhere you go without hassle.

3. LibreOffice Calc

LibreOffice is a suite of free alternatives to Microsoft Office consisting of seven different programs. The project is entirely free and open source, so you know that it’s reliable, especially since it’s been around since 2010.

The relevant part of the LibreOffice suite here is LibreOffice Calc, a direct alternative to Microsoft Excel. The program functions almost exactly as Excel does, which is largely LibreOffice’s intention.

The UI may feel a little less clean than Excel, but overall the program can do just about anything that Excel can. For just viewing XLS and XLSX files, LibreOffice Calc is more than a good enough program for the job.

For editing and adjusting particularly involved spreadsheets and formulas, it’s possible that you could begin to run into some sorts of issues, but for most use cases, LibreOffice Calc performs admirably.

4. Apache OpenOffice

Another free alternative to the Microsoft Office suite is Apache OpenOffice. Much like LibreOffice, Apache OpenOffice is an entirely free and open-source suite of programs that have been around since 2012.

OpenOffice Calc is the Excel alternative for this suite of programs, and works as closely as an analog to Excel as it can. This means, naturally, that it can open XLS and XLSX files without any problems.

The UI here can seem a little cluttered and confusing at times, and feels like an older version of Excel, but when it comes to functionality, it runs into no problems for your basic applications of opening and reading Excel files.

5. Aspose Excel Viewer

Next up, we have some online solutions. The Aspose Excel Viewer is an online service that allows you to open up a huge variety of different Excel files, including XLS and XLSX files, from within your browser.

All you have to do is drag and drop your files onto the webpage, and the Aspose Excel Viewer will open them automatically. You can also find your files through folder navigation, URL, or by connecting a Google Drive or Dropbox account.

The viewing options are pretty meager, and there is no real editing functionality to speak of when it comes to the Aspose Excel Viewer. With that being said, if you’re just looking for a quick way to open up a single Excel file without having to worry about anything else, this is probably the best way to do it.

6. Zoho Sheet

Alternatively, you could use a more comprehensive online solution such as Zoho Sheet. Zoho Sheet not only allows you to upload and view spreadsheets from a variety of formats, but it also lets you edit them extensively entirely from within your browser.

The downside here is that Zoho Sheet requires you to sign up in order to be able to use its service, which can be annoying if you’re only trying to quickly look at one file somebody has sent you. As a more robust solution that allows you to adjust data and more, Zoho Sheet might just be what you’re looking for, however.

You Don’t Need to Buy Excel to Open Excel Files

As you can see, there are a plethora of different ways that you can open XLS and XLSX files without having to purchase Microsoft Excel.

No matter if you’re in a hurry to open up just a single file, or are looking for a comprehensive alternative to Excel, there’s an option available for you. There are tons of great alternatives available out there. Once you know where to look, you’ll have no problem finding them.

169796/setting-mime-type-for-excel-document

Setting mime type for excel document

MS Excel has the following observed MIME types:

• application/vnd.ms-excel (official)
• application/msexcel
• application/x-msexcel
• application/x-ms-excel
• application/x-excel
• application/x-dos_ms_excel
• application/xls
• application/x-xls
• application/vnd.openxmlformats-officedocument.spreadsheetml.sheet (xlsx)

Is there any one type that would work for all versions? If not, do we need to set response.setContentType() with each one of these mime types individually?

Also, we use file streaming in our application to display document (not just excel - any type of document). In doing so, how can we retain the filename if the user opts to save the file - currently, the name of the servlet that renders the file appears as the default name.

• excelcontent-typemime

Your comment on this question:

1 answer to this question., your answer.

I assume application/vnd.ms-excel is the standard MIME type for Excel files.

You should provide the following header in the response when it comes to the document's name:

• ask related question

Your comment on this answer:

Related questions in database, how to use xlrd for writing an excel file.

In Python, you can read and write ... READ MORE

• pythonexcelpython-3
• xmodulexlrd

I have a Run Time Error 91 for an Excel Add In

"Runtime Error 91: Object variable or with ... READ MORE

• runtime-error

How to translate a BDS excel-formula to XBBG API for Python

The parameters are improperly specified by you. ... READ MORE

• pythonexcelapibloomberg

Excel problem for beginners: #REF! Error When referenced Row is deleted or Added

You'll run into this problem if you ... READ MORE

• excelexcel-formulaoffice365ref

Excel formula for greater than but less than with several tiers

Use this: =MATCH(A1,{0,35,60,85,110}) READ MORE

• excelif-statementexcel-form

#NAME? error in Excel for VBA Function

Because you have a module with the ... READ MORE

Excel vba for loop

You must understand how to use loops ... READ MORE

When there was no unhidden workbook open ... READ MORE

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ... READ MORE

Excel VBA - exit for loop

When we need to depart the For ... READ MORE

• excelvbafor-loop
• All categories

Join the world's most active Tech Community!

Welcome back to the world's most active tech community.

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Subscribe to our Newsletter, and get personalized recommendations.

Already have an account? Sign in .