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

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

// Import XLSB file
workbook.easy_LoadXLSBFile("C:\\Samples\\Excel to import.xlsb");

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

// Generate the XLSB file
workbook.easy_WriteXLSBFile("C:\\Samples\\Excel.xlsb");

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

' Import XLSB file
workbook.easy_LoadXLSBFile("C:\Samples\Excel to import.xlsb")

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

' Generate the XLSB file
workbook.easy_WriteXLSBFile("C:\Samples\Excel.xlsb")

C++

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

// 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 Tutorial38");
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 XLSB file
workbook->easy_WriteXLSBFile("C:\\Samples\\Excel.xlsb");

Click here to see Continuous Code Listing


C++.NET

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

// Import XLSB file
workbook->easy_LoadXLSBFile("C:\\Samples\\Excel to import.xlsb");

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

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

// Generate the XLSB file
workbook->easy_WriteXLSBFile("C:\\Samples\\Excel.xlsb");

Click here to see Continuous Code Listing

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

// Import XLSB file
FileInputStream file = new FileInputStream("C:\\Samples\\Excel to import.xlsb");
workbook.easy_LoadXLSBFile(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 Tutorial38");
for (int column=0; column<5; column++)
{
    xlsSecondTable.easy_getCell(1, column).setValue("Data " + (column + 1));
}

// Generate the XLSB file
workbook.easy_WriteXLSBFile("C:\\Samples\\Excel.xlsb");

.NET:

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

// Import XLSB file
$workbook->easy_LoadXLSBFile("C:\\Samples\\Excel to import.xlsb");

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

// Generate the XLSB file
$workbook->easy_WriteXLSBFile("C:\Samples\Excel.xlsb");

Click here to see Continuous Code Listing


Java:

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

// Import XLSB file
$workbook->easy_LoadXLSBFile("C:\\Samples\\Excel to import.xlsb");

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

Click here to see Continuous Code Listing

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

' Import XLSB file
workbook.easy_LoadXLSBFile("C:\Samples\Excel to import.xlsb")

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

' Generate the XLSB file
workbook.easy_WriteXLSBFile ("C:\Samples\Excel.xlsb")

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

' Import XLSB file
workbook.easy_LoadXLSBFile("C:\Samples\Excel to import.xlsb")

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

' Generate the XLSB file
workbook.easy_WriteXLSBFile ("C:\Samples\Excel.xlsb")

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

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

' Generate the XLSB file
workbook.easy_WriteXLSBFile ("C:\Samples\Excel.xlsb")

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

<!-- Import XLSB file -->
<cfset success = workbook.easy_LoadXLSBFile("C:\Samples\Excel to import.xlsb")>

<!-- 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 Tutorial38")>
<cfloop from="0" to="4" index="column">
    <cfset xlsTable.easy_getCell(1,evaluate(column)).setValue(
            "Data " & evaluate(column + 1))>
</cfloop>

<!-- Generate the XLSB file -->
<cfset ret = workbook.easy_WriteXLSBFile("C:\Samples\Excel.xlsb")>

.NET:

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

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

    # Export the new XLSB file
   workbook.easy_WriteXLSBFile("C:\\Samples\\Excel.xlsb")

Click here to see Continuous Code Listing


Java:

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

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

    # Export the new XLSB file
    workbook.easy_WriteXLSBFile("C:\\Samples\\Excel.xlsb")

Click here to see Continuous Code Listing

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

// Import XLSB file
DataSet ds = workbook.easy_ReadXLSBActiveSheet_AsDataSet("C:\\Samples\\Excel file.xlsb");

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

' Import XLSB file
Dim ds As DataSet = workbook.easy_ReadXLSBActiveSheet_AsDataSet("C:\Samples\Excel file.xlsb")

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

// Import XLSB file
DataSet ^ds = workbook->easy_ReadXLSBActiveSheet_AsDataSet("C:\\Samples\\Excel file.xlsb");

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

// Import XLSB file
ResultSet rs = workbook.easy_ReadXLSBActiveSheet_AsResultSet("C:\\Samples\\Excel file.xlsb");

.NET:

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

// Import XLSB file
$rows = $workbook->easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb");


Java:

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

// Import XLSB file
$rows = $workbook->easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb");

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

' Import XLSB file
Set rows = workbook.easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb")

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

// Import XLSB file
EasyXLS::IListPtr rows = 
        workbook->easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb");

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

' Import XLSB file
Set rows = workbook.easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb")

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

' Import XLSB file
Set rows = workbook.easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb")

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

<!-- Import XLSB file-->
<cfset rs = workbook.easy_ReadXLSBActiveSheet_AsResultSet("C:\\Samples\\Excel file.xlsb")>

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

# Import XLSB file
ds = workbook.easy_ReadXLSBActiveSheet_AsDataSet("C:\\Samples\\Excel file.xlsb")

Java:

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

# Import XLSB file
rows = workbook.easy_ReadXLSBActiveSheet_AsList("C:\\Samples\\Excel file.xlsb")

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

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

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

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

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

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

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

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

.NET:

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

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


Java:

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

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

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

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

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

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

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

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

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

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

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

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

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

# Import cell range data from XLSB file
rows = workbook.easy_ReadXLSBSheet_AsList(
       "C:\\Samples\\Excel file.xlsb", "Sheet1", "A1:B10")

Java:

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

# Import cell range data from XLSB file
rows = workbook.easy_ReadXLSBSheet_AsList(
       "C:\\Samples\\Excel file.xlsb", "Sheet1", "A1:B10")