Sheet properties

// Create an instance of the class that exports Excel files, having two sheets
ExcelDocument workbook = new ExcelDocument(2);

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

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

' Create an instance of the class that exports Excel files, having two sheets
Dim workbook As New ExcelDocument(2)

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

' Export Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Excel sheet name.xlsx")

C++

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

// Create two sheets
workbook->easy_addWorksheet_2("First tab");
workbook->easy_addWorksheet_2("Second tab");

// Export Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel sheet name.xlsx");

Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that exports Excel files, having two sheets
ExcelDocument ^workbook = gcnew ExcelDocument(2);

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

// Export Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel sheet name.xlsx");

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files, having two sheets
ExcelDocument workbook = new ExcelDocument(2);

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

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

.NET:

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

// Create two sheets
$workbook->easy_addWorksheet_2("First tab");
$workbook->easy_addWorksheet_2("Second tab");
 
// Export Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel sheet name.xlsx");

Click here to see Continuous Code Listing


Java:

// Create an instance of the class that creates Excel files
$workbook = new java("EasyXLS.ExcelDocument"); 
	
// Create two sheets
$workbook->easy_addWorksheet("First tab");
$workbook->easy_addWorksheet("Second tab");
	
// Create Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel sheet name.xlsx");

Click here to see Continuous Code Listing

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

' Create two sheets
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")

' Export Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel sheet name.xlsx")

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

' Create two sheets
workbook.easy_addWorksheet_2 ("First tab")
workbook.easy_addWorksheet_2 ("Second tab")

' Export Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel sheet name.xlsx")

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

' Create two sheets
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")

' Export Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Excel sheet name.xlsx")

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

<!-- Create two sheets -->
<cfset ret = workbook.easy_addWorksheet("First tab")>
<cfset ret = workbook.easy_addWorksheet("Second tab")>

<!-- Export Excel file -->
<cfset ret = workbook.easy_WriteXLSXFile("C:\Samples\Excel sheet name.xlsx")>

.NET:

# Create an instance of the class that creates Excel files, having two sheets
workbook = ExcelDocument(2)

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

# Create the Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel sheet name.xlsx")
        
Click here to see Continuous Code Listing


Java:

# Create an instance of the class that creates Excel files, having two sheets
workbook = gateway.jvm.ExcelDocument(2) 

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

# Create the Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel sheet name.xlsx")

Click here to see Continuous Code Listing