EasyXLS™ library allows you to convert an Excel file to XML Spreadsheet file format. The Excel file can be in XLSX, XLSM, XLSB or XLS file format.
EasyXLS can be successfully used inclusively to convert large Excel files to XML Spreadsheet, Excel files with big volume of data with fast converting time.
EasyXLS permits you to convert Excel to XML Spreadsheet file without Excel installed, without Interop or any other additional software installed.
The conversion is made in two steps. First, the Excel file is imported and after that, the data is exported to XML Spreadsheet file. Once the Excel file was loaded in memory, optionally, the user can update data and save the file back in XML Spreadsheet format.
// Create an instance of the class used to import/export Excel files
ExcelDocument workbook = new ExcelDocument();
// Import Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\file.xlsx");
// Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\\Samples\\Excel to XML Spreadsheet.xml");
' Create an instance of the class used to import/export Excel filesDim workbook As New ExcelDocument
' Import Excel file
workbook.easy_LoadXLSXFile("C:\Samples\file.xlsx")
' Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml")
C++// Create an instance of the class used to import/export Excel files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
NULL,
CLSCTX_ALL,
__uuidof(EasyXLS::IExcelDocument),
(void**) &workbook) ;
// Import Excel file
workbook->easy_LoadXLSXFile("C:\\Samples\\file.xlsx");
// Export XML Spreadsheet file
workbook->easy_WriteXMLFile("C:\\Samples\\Excel to XML Spreadsheet.xml");
C++.NET// Create an instance of the class used to import/export Excel files
ExcelDocument ^workbook = gcnew ExcelDocument();
// Import Excel file
workbook->easy_LoadXLSXFile("C:\\Samples\\file.xlsx");
// Export XML Spreadsheet file
workbook->easy_WriteXMLFile("C:\\Samples\\Excel to XML Spreadsheet.xml");
// Create an instance of the class used to import/export Excel files
ExcelDocument workbook = new ExcelDocument();
// Import Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\file.xlsx");
// Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\\Samples\\Excel to XML Spreadsheet.xml");
.NET:// Create an instance of the class used to import/export Excel files
$workbook = new COM("EasyXLS.ExcelDocument");
// Import Excel file
$workbook->easy_LoadXLSXFile("C:\Samples\file.xlsx");
// Export XML Spreadsheet file
$workbook->easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml");
Java:// Create an instance of the class used to import/export Excel files
$workbook = new java("EasyXLS.ExcelDocument");
// Import Excel file
$workbook->easy_LoadXLSXFile("C:\Samples\file.xlsx");
// Export XML Spreadsheet file
$workbook->easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml");
' Create an instance of the class used to import/export Excel filesset workbook = Server.CreateObject("EasyXLS.ExcelDocument")
' Import Excel file
workbook.easy_LoadXLSXFile("C:\Samples\file.xlsx")
' Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml")
' Create an instance of the class used to import/export Excel filesSet workbook = CreateObject("EasyXLS.ExcelDocument")
' Import Excel file
workbook.easy_LoadXLSXFile("C:\Samples\file.xlsx")
' Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml")
' Create an instance of the class used to import/export Excel filesset workbook = CreateObject("EasyXLS.ExcelDocument")
' Import Excel file
workbook.easy_LoadXLSXFile("C:\Samples\file.xlsx")
' Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml")
<!-- Create an instance of the class used to import/export Excel files --><cfobject type="java"class="EasyXLS.ExcelDocument"name="workbook"action="CREATE"><!-- Import Excel file --><cfset ret = workbook.easy_LoadXLSXFile("C:\Samples\file.xlsx")><!-- Export XML Spreadsheet file --><cfset ret = workbook.easy_WriteXMLFile("C:\Samples\Excel to XML Spreadsheet.xml")>
.NET:# Create an instance of the class used to import/export Excel files
workbook = ExcelDocument()
# Import Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\file.xlsx")
# Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\\Samples\\Excel to XML Spreadsheet.xml")
Java:# Create an instance of the class used to import/export Excel files
workbook = gateway.jvm.ExcelDocument()
# Import Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\file.xlsx")
# Export XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\\Samples\\Excel to XML Spreadsheet.xml")
Convert XLSX to XML Spreadsheet
EasyXLS allows you to convert Excel XLSX file to XML Spreadsheet. The above code sample shows how to achieve this goal, by using ExcelDocument.easy_LoadXLSXFile method.
EasyXLS allows you to convert Excel XLSM file to XML Spreadsheet. Similarly, as shown in the above code sample, using ExcelDocument.easy_LoadXLSXFile method, the XLSM file can be converted to XML Spreadsheet file.
EasyXLS allows you to convert Excel XLSB file to XML Spreadsheet. Similarly, as shown in the above code sample, using ExcelDocument.easy_LoadXLSBFile method, the XLSB file can be converted to XML Spreadsheet file.
EasyXLS allows you to convert Excel XLS file to XML Spreadsheet. Similarly, as shown in the above code sample, using ExcelDocument.easy_LoadXLSFile method, the XLS file can be converted to XML Spreadsheet file.
