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

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

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

// 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 XLSM file
workbook.easy_WriteXLSXFileC:\\Samples\\Excel with macro.xlsm");

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

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

' 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 XLSM file
workbook.easy_WriteXLSXFile("C:\Samples\Excel with macro.xlsm")

C++

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

// 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 XLSM file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel with macro.xlsm");


Click here to see Continuous Code Listing


C++.NET

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

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

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

// Generate the XLSM file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel with macro.xlsm");

Click here to see Continuous Code Listing

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

// Import XLSM file
FileInputStream file = new FileInputStream("C:\\Samples\\Excel to import.xlsm");
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 XLSM file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel with macro.xlsm");

.NET:

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

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

// 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 XLSM file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel with macro.xlsm");

Click here to see Continuous Code Listing


Java:

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

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

// 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 XLSM file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel with macro.xlsm");

Click here to see Continuous Code Listing

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

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

' 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 XLSM file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel with macro.xlsm")

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

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

' 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 XLSM file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel with macro.xlsm")

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

' Import XLSM file
workbook.easy_LoadXLSXFile("C:\Samples\Excel to import.xlsm")
    
' 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 XLSM file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel with macro.xlsm")

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

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

<!-- 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 XLSM file -->
<cfset ret = workbook.easy_WriteXLSXFile("C:\Samples\Excel with macro.xlsm")>

.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 with macro.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 with macro.xlsx")

Click here to see Continuous Code Listing

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

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

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

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

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

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

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

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

.NET:

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

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


Java:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Java:

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

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

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

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

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

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

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

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

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

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

.NET:

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

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


Java:

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

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

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

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

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

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

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

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

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

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

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

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

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

# Import cell range data from XLSM file
rows = workbook.easy_ReadXLSMSheet_AsList(
       "C:\\Samples\\Excel file.xlsm", "Sheet1", "A1:B10")

Java:

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

# Import cell range data from XLSM file
rows = workbook.easy_ReadXLSMSheet_AsList(
       "C:\\Samples\\Excel file.xlsm", "Sheet1", "A1:B10")