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

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

// Import XLS file
workbook.easy_LoadXLSFile("C:\\Samples\\Excel to import.xls");

// 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 Tutorial36");
for (int column=0; column<5; column++)
{
    xlsSecondTable.easy_getCell(1, column).setValue("Data " + (column + 1)); 
}

// Generate the XLS file
workbook.easy_WriteXLSFile("C:\\Samples\\Excel.xls");

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

' Import XLS file
workbook.easy_LoadXLSFile("C:\Samples\Excel to import.xls")    

' 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 Tutorial36")
For column As Integer = 0 To 4
    xlsSecondTable.easy_getCell(1, column).setValue("Data " & (column + 1))
Next

' Generate the XLS file
workbook.easy_WriteXLSFile("C:\Samples\Excel.xls")

C++

// Create an instance of the class that imports XLS files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                      NULL,
                      CLSCTX_ALL,
                      __uuidof(EasyXLS::IExcelDocument),
                      (void**) &workbook) ;
		
// Import XLS file
workbook->easy_LoadXLSFile("C:\\Samples\\Excel to import.xls");
   
// Get the table of the second worksheet
EasyXLS::IExcelWorksheetPtr xlsSecondTab = 
         (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheet("Second tab");
EasyXLS::IExcelTablePtr xlsSecondTable = xlsSecondTab->easy_getExcelTable();

// Add more data to the second sheet
xlsSecondTable->easy_getCell_2("A1")->setValue("Data added by Tutorial36");
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);
    
    xlsSecondTable->easy_getCell(1, column)->setValue(strcat(cellValue, columnNumber));
}

// Generate the XLS file
workbook->easy_WriteXLSFile("C:\\Samples\\Excel.xls");

Click here to see Continuous Code Listing


C++.NET

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

// Import XLS file
workbook->easy_LoadXLSFile("C:\\Samples\\Excel to import.xls");

// Get the table of the second worksheet
ExcelWorksheet ^xlsSecondTab = 
       safe_cast<ExcelWorksheet^>(workbook->easy_getSheetAt(1));
ExcelTable ^xlsSecondTable = xlsSecondTab->easy_getExcelTable();

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

// Generate the XLS file
workbook->easy_WriteXLSFile("C:\\Samples\\Excel.xls");

Click here to see Continuous Code Listing

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

// Import XLS file
FileInputStream file = new FileInputStream("C:\\Samples\\Excel to import.xls");
workbook.easy_LoadXLSFile(file);

// 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 Tutorial36");
for (int column=0; column<5; column++)
{
    xlsSecondTable.easy_getCell(1, column).setValue("Data " + (column + 1));
}

// Generate the XLS file
workbook.easy_WriteXLSFile("C:\\Samples\\Excel.xls");

.NET:

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

// Import XLS file
$workbook->easy_LoadXLSFile("C:\\Samples\\Excel to import.xls");

// 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 Tutorial37");
for ($column=0; $column<5; $column++)
{
    $xlsSecondTable->easy_getCell(1, $column)->setValue("Data " . ($column + 1));
}

// Generate the XLS file
$workbook->easy_WriteXLSFile("C:\Samples\Excel.xls");

Click here to see Continuous Code Listing


Java:

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

// Import XLS file
$workbook->easy_LoadXLSFile("C:\\Samples\\Excel to import.xls");

// 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 Tutorial37");
for ($column=0; $column<5; $column++)
{
    $xlsSecondTable->easy_getCell(1, $column)->setValue("Data " . ($column + 1));
}
		
// Generate the XLS file
$workbook->easy_WriteXLSFile("C:\Samples\Excel.xls");

Click here to see Continuous Code Listing

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

' Import XLS file
workbook.easy_LoadXLSFile("C:\Samples\Excel to import.xls")
    
' 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 Tutorial36")
for column=0 to 4
    xlsSecondTable.easy_getCell(1, column).setValue("Data " & (column + 1))
next

' Generate the XLS file
workbook.easy_WriteXLSFile ("C:\Samples\Excel.xls")

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

' Import XLS file
workbook.easy_LoadXLSFile("C:\Samples\Excel to import.xls")
    
' 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 Tutorial36")
For Column = 0 To 4
    xlsSecondTable.easy_getCell(1, Column).setValue ("Data " & (Column + 1))
Next

' Generate the XLS file
workbook.easy_WriteXLSFile ("C:\Samples\Excel.xls")

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

' Import XLS file
workbook.easy_LoadXLSFile("C:\Samples\Excel to import.xls")

' 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 Tutorial36")
for column=0 to 4
    xlsSecondTable.easy_getCell(1, column).setValue("Data " & (column + 1))
next

' Generate the XLS file
workbook.easy_WriteXLSFile ("C:\Samples\Excel.xls")

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

<!-- Import XLS file -->
<cfset success = workbook.easy_LoadXLSFile("C:\Samples\Excel to import.xls")>   
    
<!-- Get the table of the second worksheet -->
<cfset xlsSecondTable = workbook.easy_getSheet("Second tab").easy_getExcelTable()>

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

<!-- Generate the XLS file -->
<cfset ret = workbook.easy_WriteXLSFile("C:\Samples\Excel.xls")>

.NET:

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

# Read XLS file
if workbook.easy_LoadXLSFile("C:\\Samples\\Excel to import.xls"):
    # 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 Tutorial37")
			
    for column in range(5):
        xlsSecondTable.easy_getCell(1, column).setValue("Data " + str(column + 1))

    # Export the new XLS file
   workbook.easy_WriteXLSFile("C:\\Samples\\Excel.xls")

Click here to see Continuous Code Listing


Java:

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

# Read XLS file
if workbook.easy_LoadXLSFile("C:\\Samples\\Excel to import.xls"):
    # 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 Tutorial37")
			
    for column in range(5):
        xlsSecondTable.easy_getCell(1, column).setValue("Data " + str(column + 1))

    # Export the new XLS file
    workbook.easy_WriteXLSFile("C:\\Samples\\Excel.xls")

Click here to see Continuous Code Listing

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

// Import XLS file
DataSet ds = workbook.easy_ReadXLSActiveSheet_AsDataSet("C:\\Samples\\Excel file.xls");

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

' Import XLS file
Dim ds As DataSet = workbook.easy_ReadXLSActiveSheet_AsDataSet("C:\Samples\Excel file.xls")

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

// Import XLS file
DataSet ^ds = workbook->easy_ReadXLSActiveSheet_AsDataSet("C:\\Samples\\Excel file.xls");

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

// Import XLS file
ResultSet rs = workbook.easy_ReadXLSActiveSheet_AsResultSet("C:\\Samples\\Excel file.xls");

.NET:

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

// Import XLS file
$rows = $workbook->easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls");


Java:

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

// Import XLS file
$rows = $workbook->easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls");

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

' Import XLS file
Set rows = workbook.easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls")

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

// Import XLS file
EasyXLS::IListPtr rows = 
        workbook->easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls");

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

' Import XLS file
Set rows = workbook.easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls")

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

' Import XLS file
Set rows = workbook.easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls")

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

<!-- Import XLS file-->
<cfset rs = workbook.easy_ReadXLSActiveSheet_AsResultSet("C:\\Samples\\Excel file.xls")>

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

# Import XLS file
ds = workbook.easy_ReadXLSActiveSheet_AsDataSet("C:\\Samples\\Excel file.xls")

Java:

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

# Import XLS file
rows = workbook.easy_ReadXLSActiveSheet_AsList("C:\\Samples\\Excel file.xls")

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

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

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

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

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

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

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

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

.NET:

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

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


Java:

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

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

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

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

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

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

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

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

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

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

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

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

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

# Import cell range data from XLS file
rows = workbook.easy_ReadXLSSheet_AsList(
       "C:\\Samples\\Excel file.xls", "Sheet1", "A1:B10")

Java:

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

# Import cell range data from XLS file
rows = workbook.easy_ReadXLSSheet_AsList(
       "C:\\Samples\\Excel file.xls", "Sheet1", "A1:B10")