1

What's the correct way to export an HTML table as an Excel file so that the user can click a button and download the Excel file (ideally using Angular and without using server)?

I've seen many answers like this: Export to xls using angularjs but doing this gives an error similar to the following:

"The file format and extension dont match... The file could be corrupted..."

and I believe the file is actually in HTML or XML format, not actual Excel.

The warning does not present a good image to the user.

What's the right way to actually export a file as Excel without using the server?

Or is the server required to create the file?

Improve this question

1 Answer 1

Reset to default
2

If you are just using tabular data, then I would argue that the best solution would be building a CSV file. This could be natively opened by excel and converted into an XLS file if necessary. You can do so by arranging your data with a data URI. The octet-stream will force a file download rather than opening in browser. Here is an example:

<a href="data:application/octet-stream,field1%2Cfield2%0Afoo%2Cbar%0Agoo%2Cgai%0A">CSV</a>
Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Thanks! To avoid any confusion for the user (dealing with a csv file), do you know if there's an easy way to convert a csv file into an xls file in the client?
This would require a separate step of uploading the csv and using a library to convert it to an xls, then re-downloading it. A good library with an example can be found here: github.com/faisalman/simple-excel-js.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.