No doubt, Excel is the most popular tool for data processing starting from simple Excel tables with prices and products to complex financial data. With the rapidly developing world wide web, the need to display data from Excel files on websites and web apps arouse. How to efficiently convert Excel into web-based formats?
DHTMLX development team created three open source tools, which convert Excel data into the JSON format (and vice versa) and generate HTML tables from Excel files.
All three libraries were developed using the WebAssembly standard and Rust programming language. These technologies contribute to highly reliable code and fast performance. There are no vulnerabilities in the process of conversion, and you don’t have to worry about the safety of your data while it’s being processed. The small size of code allows you to perform the operations extremely quickly. Thus, you can use our open-source tools in your projects to maintain high-speed and secure websites and web apps.
The first two open-source libraries enable you to transform the data kept in your Excel files into the JSON format and back from JSON to Excel. You can find a detailed description and instructions on GitHub:
The third open-source tool Excel2Table was built on the basis of the Excel2Json library, which parses Excel files. The data is rendered as an HTML table preserving all the styles from Excel sheets.
Using the Excel2Table is very straightforward and simple:
1) The first step is to run the following command line to install the library:
npm i excel2table
2) Then import the library into your project:
3) And all that is left is to call the render function:
excel2table.render(html_container, data, config);
You can find all the parameters of this function and other technical details described in our GitHub repository.
As a result, you’ll have a precise HTML version of your Excel sheet:
All three libraries are distributed under the MIT license, which allows for using them both in non-commercial and commercial projects.
Originally published at https://dhtmlx.com/blog/convert-excel-file-html-json-dhtmlx-open-source-tools/