Import XLSX file in .NET, Java and other programming languages

// Create an instance of the class that imports XLSX files
ExcelDocument workbook = new ExcelDocument(); 

// Import XLSX file
workbook.easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx");

// Get the table of the second worksheet
ExcelTable xlsSecondTable = 
        ((ExcelWorksheet)workbook.easy_getSheet("Second tab")).easy_getExcelTable();

// Add more data to the second sheet
xlsSecondTable.easy_getCell("A1").setValue("Data added by Tutorial37");
for (int column=0; column<5; column++)
{
    xlsSecondTable.easy_getCell(1, column).setValue("Data " + (column + 1)); 
}

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

' Create an instance of the class that imports XLSX files
Dim workbook As New ExcelDocument

' Import XLSX file
workbook.easy_LoadXLSXFile("C:\Samples\Excel to import.xlsx")

' Get the table of the second worksheet
Dim xlsSecondTab As ExcelWorksheet = workbook.easy_getSheet("Second tab")
Dim xlsSecondTable = xlsSecondTab.easy_getExcelTable

' Add more data to the second sheet
xlsSecondTable.easy_getCell("A1").setValue("Data added by Tutorial37")
For column As Integer = 0 To 4
    xlsSecondTable.easy_getCell(1, column).setValue("Data " & (column + 1))
Next

' Generate the XLSX file
workbook.easy_WriteXLSXFile("C:\Samples\Excel.xlsx")

C++

// Create an instance of the class that imports XLSX files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                      NULL,
                      CLSCTX_ALL,
                      __uuidof(EasyXLS::IExcelDocument),
                      (void**) &workbook) ;
		
// Import XLSX file
workbook->easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx");

// Get the table of the second worksheet
EasyXLS::IExcelWorksheetPtr xlsSecondTab = 
        (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheetAt(1);
EasyXLS::IExcelTablePtr xlsTable = xlsSecondTab->easy_getExcelTable();

// Add more data to the second sheet
xlsTable->easy_getCell_2("A1")->setValue("Data added by Tutorial37");
char* cellValue = (char*)malloc(11*sizeof(char));
char*  columnNumber = (char*)malloc(sizeof(char));
for (int column=0; column<5; column++)
{
    strcpy(cellValue, "Data ");
    _itoa(column+ 1, columnNumber , 10);
    xlsTable->easy_getCell(1, column)->setValue(strcat(cellValue, columnNumber));
}

// Generate the XLSX file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel.xlsx");


Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that imports XLSX files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Import XLSX file
workbook->easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx");

// Get the table of the second worksheet
ExcelWorksheet ^xlsSecondTab = 
       safe_cast<ExcelWorksheet^>(workbook->easy_getSheet("Second tab"));
ExcelTable ^xlsSecondTable = xlsSecondTab->easy_getExcelTable();

// Write some data to the second sheet
xlsSecondTable->easy_getCell("A1")->setValue("Data added by Tutorial37");
for (int column=0; column<5; column++)
{
    xlsSecondTable->easy_getCell(1, column)->setValue(
            String::Concat("Data ", (column + 1).ToString()));
}

// Generate the XLSX file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel.xlsx");

Click here to see Continuous Code Listing

// Create an instance of the class that imports XLSX files
ExcelDocument workbook = new ExcelDocument();

// Import XLSX file
FileInputStream file = new FileInputStream("C:\\Samples\\Excel to import.xlsx");
workbook.easy_LoadXLSXFile(file);

// Get the table of the second worksheet
ExcelTable xlsSecondTable = 
        ((ExcelWorksheet)workbook.easy_getSheetAt(1)).easy_getExcelTable();

// Add more data to the second sheet
xlsSecondTable.easy_getCell("A1").setValue("Data added by Tutorial37");
for (int column=0; column<5; column++)
{
    xlsSecondTable.easy_getCell(1, column).setValue("Data " + (column + 1));
}

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

.NET:

// Create an instance of the class that imports XLSX files
$workbook = new COM("EasyXLS.ExcelDocument");

// Import XLSX file
$workbook->easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx");

// Get the table of the second worksheet
$xlsSecondTable = $workbook->easy_getSheet("Second tab")->easy_getExcelTable();

// Add more data to the second sheet
$xlsSecondTable->easy_getCell_2("A1")->setValue("Data added by Tutorial36");
for ($column=0; $column<5; $column++)
{
    $xlsSecondTable->easy_getCell(1, $column)->setValue("Data " . ($column + 1));
}

// Generate the XLSX file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel.xlsx");

Click here to see Continuous Code Listing


Java:

// Create an instance of the class that imports XLSX files
$workbook = new java("EasyXLS.ExcelDocument");

// Import XLSX file
$workbook->easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx");

// Get the table of the second worksheet
$xlsSecondTable = $workbook->easy_getSheet("Second tab")->easy_getExcelTable();

// Add more data to the second sheet
$xlsSecondTable->easy_getCell("A1")->setValue("Data added by Tutorial36");
for ($column=0; $column<5; $column++)
{
	$xlsSecondTable->easy_getCell(1, $column)->setValue("Data " . ($column + 1));
}
		
// Generate the XLSX file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel.xlsx");

Click here to see Continuous Code Listing

' Create an instance of the class that imports XLSX files
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Import XLSX file
workbook.easy_LoadXLSXFile("C:\Samples\Excel to import.xlsx")

' Get the table of the second worksheet
set xlsSecondTable = workbook.easy_getSheet("Second tab").easy_getExcelTable()

' Add more data to the second sheet
xlsSecondTable.easy_getCell_2("A1").setValue("Data added by Tutorial37")
for column=0 to 4
    xlsSecondTable.easy_getCell(1, column).setValue("Data " & (column + 1))
next

' Generate the XLSX file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel.xlsx")

' Create an instance of the class that imports XLSX files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import XLSX file
workbook.easy_LoadXLSXFile("C:\Samples\Excel to import.xlsx")

' Get the table of the second worksheet
Set xlsSecondTable = easy_getSheetAt(1).easy_getExcelTable()

' Add more data to the second sheet
xlsSecondTable.easy_getCell_2("A1").setValue ("Data added by Tutorial37")
For Column = 0 To 4
    xlsSecondTable.easy_getCell(1, Column).setValue ("Data " & (Column + 1))
Next

' Generate the XLSX file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel.xlsx")

' Create an instance of the class that imports XLSX files
set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import XLSX file
workbook.easy_LoadXLSXFile("C:\Samples\Excel to import.xlsx")
    
' Get the table of the second worksheet
Set xlsSecondTable = workbook.easy_getSheet("Second tab").easy_getExcelTable()

' Add more data to the second sheet
xlsSecondTable.easy_getCell_2("A1").setValue("Data added by Tutorial37")
for column=0 to 4
    xlsSecondTable.easy_getCell(1, column).setValue("Data " & (column + 1))
next

' Generate the XLSX file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel.xlsx")

<!-- Create an instance of the class that imports XLSX files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Import XLSX file -->
<cfset success = workbook.easy_LoadXLSXFile("C:\Samples\Excel to import.xlsx")>

<!-- Get the table of the second worksheet -->
<cfset xlsTable = workbook.easy_getSheetAt(1).easy_getExcelTable()>

<!-- Add more data to the second sheet -->
<cfset xlsTable.easy_getCell("A1").setValue("Data added by Tutorial37")>
<cfloop from="0" to="4" index="column">
    <cfset xlsTable.easy_getCell(1,evaluate(column)).setValue(
            "Data " & evaluate(column + 1))>
</cfloop>

<!-- Generate the XLSX file -->
<cfset ret = workbook.easy_WriteXLSXFile("C:\Samples\Excel.xlsx")>

.NET:

# Create an instance of the class that reads Excel files
workbook = ExcelDocument()

# Read XLSX file
if workbook.easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx"):
    # Get the table of data for the second worksheet
    xlsSecondTable = workbook.easy_getSheet("Second tab").easy_getExcelTable()

    # Write some data to the second sheet
    xlsSecondTable.easy_getCell("A1").setValue("Data added by Tutorial36")
			
    for column in range(5):
        xlsSecondTable.easy_getCell(1, column).setValue("Data " + str(column + 1))

    # Export the new XLSX file
    workbook.easy_WriteXLSXFile("C:\\Samples\\Excel.xlsx")

Click here to see Continuous Code Listing


Java:

# Create an instance of the class that reads Excel files
workbook = gateway.jvm.ExcelDocument()

# Read XLSX file
if workbook.easy_LoadXLSXFile("C:\\Samples\\Excel to import.xlsx"):
    # Get the table of data for the second worksheet
        xlsSecondTable = workbook.easy_getSheet("Second tab").easy_getExcelTable()

    # Write some data to the second sheet
        xlsSecondTable.easy_getCell("A1").setValue("Data added by Tutorial36")
			
        for column in range(5):
            xlsSecondTable.easy_getCell(1, column).setValue("Data " + str(column + 1))

    # Export the new XLSX file
        workbook.easy_WriteXLSXFile("C:\\Samples\\Excel.xlsx")

Click here to see Continuous Code Listing

// Create an instance of the class that imports XLSX files
ExcelDocument workbook = new ExcelDocument();

// Import XLSX file
DataSet ds = workbook.easy_ReadXLSXActiveSheet_AsDataSet(
                      "C:\\Samples\\Excel file.xlsx");

' Create an instance of the class that imports XLSX files
Dim workbook As New ExcelDocument

' Import XLSX file
Dim ds As DataSet = workbook.easy_ReadXLSXActiveSheet_AsDataSet(
                             "C:\Samples\Excel file.xlsx")

C++

// Create an instance of the class that imports XLSX files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                      NULL,
                      CLSCTX_ALL,
                      __uuidof(EasyXLS::IExcelDocument),
                      (void**) &workbook);

// Import XLSX file
EasyXLS::IListPtr rows =
workbook->easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx");

C++.NET


// Create an instance of the class that imports XLSX files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Import XLSX file
DataSet ^ds = workbook->easy_ReadXLSXActiveSheet_AsDataSet(
                        "C:\\Samples\\Excel file.xlsx");

// Create an instance of the class that imports XLSX files
ExcelDocument workbook = new ExcelDocument();

// Import XLSX file
ResultSet rs = workbook.easy_ReadXLSXActiveSheet_AsResultSet(
                        "C:\\Samples\\Excel file.xlsx");

.NET:

// Create an instance of the class that imports XLSX files
$workbook = new COM("EasyXLS.ExcelDocument");

// Import XLSX file
$rows = $workbook->easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx");


Java:

// Create an instance of the class that imports XLSX files
$workbook = new java("EasyXLS.ExcelDocument");

// Import XLSX file
$rows = $workbook->easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx");

' Create an instance of the class that imports XLSX files
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Import XLSX file
Set rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx")

' Create an instance of the class that imports XLSX files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import XLSX file
Set rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx")

' Create an instance of the class that imports XLSX files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import XLSX file
Set rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx")

<!-- Create an instance of the class that imports XLSX files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Import XLSX file-->
<cfset rs = workbook.easy_ReadXLSXActiveSheet_AsResultSet(
                     "C:\\Samples\\Excel file.xlsx")>

.NET:

# Create an instance of the class that imports XLSX files
workbook = ExcelDocument()

# Import XLSX file
ds = workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\\Samples\\Excel file.xlsx")

Java:

# Create an instance of the class that imports XLSX files
workbook = gateway.jvm.ExcelDocument()

# Import XLSX file
rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Excel file.xlsx")

// Create an instance of the class that imports XLSX files
ExcelDocument workbook = new ExcelDocument();

// Import cell range data from XLSX file
DataSet ds = workbook.easy_ReadXLSXSheet_AsDataSet(
                     "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");

' Create an instance of the class that imports XLSX files
Dim workbook As New ExcelDocument

' Import cell range data from XLSX file
Dim ds = workbook.easy_ReadXLSXSheet_AsDataSet(
                 "C:\Samples\Excel file.xlsx", "Sheet1", "A1:B10")

C++

// Create an instance of the class that imports XLSX files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                      NULL,
                      CLSCTX_ALL,
                      __uuidof(EasyXLS::IExcelDocument),
                      (void**) &workbook);

// Import cell range data from XLSX file
EasyXLS::IListPtr rows =
workbook->easy_ReadXLSXSheet_AsList_5(
"C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");

C++.NET

// Create an instance of the class that imports XLSX files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Import cell range data from XLSX file
DataSet ^ds = workbook->easy_ReadXLSXSheet_AsDataSet(
"C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");

// Create an instance of the class that imports XLSX files
ExcelDocument workbook = new ExcelDocument();

// Import cell range data from XLSX file
DataSet ds = workbook.easy_ReadXLSXSheet_AsResultSet(
                     "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");

.NET:

// Create an instance of the class that imports XLSX files
$workbook = new COM("EasyXLS.ExcelDocument");

// Import cell range data from XLSX file
$rows = $workbook->easy_ReadXLSXSheet_AsList_5(
        "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");


Java:

// Create an instance of the class that imports XLSX files
$workbook = new java("EasyXLS.ExcelDocument");

// Import cell range data from XLSX file
$rows = $workbook->easy_ReadXLSXSheet_AsList(
        "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");

' Create an instance of the class that imports XLSX files
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Import cell range data from XLSX file
set rows = workbook.easy_ReadXLSXSheet_AsList_5(_
           "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10")

// Create an instance of the class that imports XLSX files
EasyXLS::IExcelDocumentPtr workbook;
		hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		NULL,
		CLSCTX_ALL,
		__uuidof(EasyXLS::IExcelDocument),
		(void**) &workbook);

// Import cell range data from XLSX file
EasyXLS::IListPtr rows = 
        workbook->easy_ReadXLSXSheet_AsList_5(
        "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10");

' Create an instance of the class that imports XLSX files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import cell range data from XLSX file
Set rows = workbook.easy_ReadXLSXSheet_AsList_5( _
           "C:\Samples\Excel file.xlsx", "Sheet1", "A1:B10")

' Create an instance of the class that imports XLSX files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import cell range data from XLSX file
Set rows = workbook.easy_ReadXLSXSheet_AsList_5( _
           "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10")

<!-- Create an instance of the class that imports XLSX files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Import cell range data from XLSX file-->
<cfset rows = workbook.easy_ReadXLSXSheet_AsResultSet(
              "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10")>

.NET:
# Create an instance of the class that imports XLSX files
workbook = ExcelDocument()

# Import cell range data from XLSX file
rows = workbook.easy_ReadXLSXSheet_AsList(
       "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10")

Java:

# Create an instance of the class that imports XLSX files
workbook = gateway.jvm.ExcelDocument()

# Import cell range data from XLSX file
rows = workbook.easy_ReadXLSXSheet_AsList(
       "C:\\Samples\\Excel file.xlsx", "Sheet1", "A1:B10")