Export to XLSX file in .NET, Java and other programming languages

EasyXLS™ library allows you to export data to XLSX file format. The data in cells can be formatted using predefined formats or user-defined formats.

EasyXLS can be successfully used inclusively to export large XLSX files having big volume of data with fast exporting time.

EasyXLS permits you to export Excel files without Excel installed, without Interop or any other additional software installed.

Source code sample

The below example is a common code about how to export to XLSX file. After that, more code samples about exporting data from various standard data structures like DataTable, GridView, DataSet and ResultSet are shown.


// Create an instance of the class that exports XLSX file, having multiple sheets
ExcelDocument workbook = new ExcelDocument(2);

// Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab");
workbook.easy_getSheetAt(1).setSheetName("Second tab");

// Get the table of the first worksheet that will keep the data
ExcelTable xlsFirstTable = 
        ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable();

// Add data to header
for (int column=0; column<5; column++)
{
    xlsFirstTable.easy_getCell(0,column).setValue("Column " + (column + 1)); 
    xlsFirstTable.easy_getCell(0,column).setDataType(DataType.STRING);
}

// Add data to cells
for (int row=0; row<100; row++)
{
    for (int column=0; column<5; column++)
    {
        xlsFirstTable.easy_getCell(row+1,column).setValue(
                "Data " + (row + 1) + ", " + (column + 1)); 
        xlsFirstTable.easy_getCell(row+1,column).setDataType(DataType.STRING);
    }
}

// Export XLSX file
workbook.easy_WriteXLSXFile("C:\\Samples\\Export to Excel.xlsx");

// Confirm generation
String sError = workbook.easy_getError();
if (sError.Equals(""))
    Console.Write("\nFile successfully created. Press Enter to Exit...");
else
    Console.Write("\nError encountered: " + sError + "\nPress Enter to Exit...");

Click here to see Continuous Code Listing

The screen shot below represents the exported data to XLSX file generated by the code sample above. The file has two worksheets (First Tab and Second Tab). The values and the data type of the cells from the first worksheet are set.

Formatting cells

EasyXLS™ enables you to format cells, rows and columns in order to set the fonts and colors.

Export DataTable to XLSX in C# and VB.NET

EasyXLS allows exporting DataTable to XLSX file with formatting.

Export GridView to XLSX in C# and VB.NET from ASP.NET

EasyXLS allows exporting GridView to XLSX with formatting.

Export DataGridView to XLSX in C# and VB.NET

EasyXLS allows exporting DataGridView to XLSX with formatting.

Export DataSet to XLSX in C# and VB.NET

EasyXLS allows exporting DataSet to XLSX with formatting.

Export ResultSet to XLSX in Java

EasyXLS allows exporting ResultSet to XLSX with formatting.

Export list to Excel

EasyXLS allows exporting a list of data to Excel with formatting.

Export DataGrid to XLSX in C# and VB.NET

EasyXLS allows exporting DataGrid to XLSX with formatting.

Export password protected XLSX file

EasyXLS allows exporting encrypted Excel file. The Excel file can be password protected.

Getting started with EasyXLS Excel library

To download the trial version of EasyXLS Excel Library, press the below button:

For example, I have this sample code on how to get data from w3school on how to select data from database. Here is my sample code:

WordPress

For example, I have this sample code on how to get data from w3school on how to select data from database. Here is my sample code:

a

Wednesday 31 August 2022