Python Excel Conversion Examples

from ironxl import * # Import any XLSX, XLS, XLSM, XLTX, CSV, and TSV workbook = WorkBook.Load("sample.xlsx") # Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML workbook.SaveAs("sample.xls") workbook.SaveAs("sample.xlsx") workbook.SaveAs("sample.tsv") workbook.SaveAsCsv("sample.csv") workbook.SaveAsJson("sample.json") workbook.SaveAsXml("sample.xml") # Export the excel file as HTML, HTML string workbook.ExportToHtml("sample.html") html_string = workbook.ExportToHtmlString() # Export the excel file as Binary, Byte array, Data set, Stream binary_data = workbook.ToBinary() byte_array_data = workbook.ToByteArray()

Convert Spreadsheet File Types

IronXL for Python offers a simple and flexible way to import and export Excel data across a wide range of formats. It supports XLS, XLSX, CSV, JSON, XML, and HTML, making it suitable for diverse application requirements. With just a few lines of Python, developers can convert Excel data into formats ready for web integration, APIs, or further data processing.

Exporting Excel files as HTML or JSON makes it easy to embed data into web applications, while converting to binary, byte arrays, or streams enables integration with databases or other systems. Converting Excel content to a DataSet simplifies populating SQL databases or data grids. This reduces manual coding, enhances productivity, and makes IronXL a valuable tool for modern data-driven Python applications.

5 Steps to Export Excel Files in Multiple Formats

This example begins by loading an existing Excel file, Sample.xlsx, into a WorkBook object. This object serves as the central hub for manipulating and exporting data. Using the SaveAs method, the workbook is saved as an .xlsx file, ensuring compatibility with modern Excel applications.

Next, the SaveAsJson method converts the workbook into JSON format, making it suitable for API responses or lightweight data exchange. The ToDataSet method enables seamless database or UI component integration by converting the workbook into a tabular data structure.

Finally, the ExportToHtml method generates an HTML file that renders the Excel data directly in a web browser. These capabilities streamline data processing tasks and make IronXL an exceptional tool for Python developers working with Excel files.

Learn to Convert Excel File Types Effortlessly with Python