Filter and autofilter

// Create an instance of the class that exports Excel files, having one sheet
ExcelDocument workbook = new ExcelDocument(1);

// Get the table of the first worksheet that will keep the data and the autofilter
ExcelWorksheet xlsTab = ((ExcelWorksheet)workbook.easy_getSheet("Sheet1"));
ExcelTable xlsTable = xlsTab.easy_getExcelTable();

// Add data to cells
...

// Add autofilter to a range of cells
ExcelFilter xlsFilter = xlsTab.easy_getFilter();
xlsFilter.setAutoFilter("A1:E1");

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

' Create an instance of the class that exports Excel files, having one sheet
Dim workbook As New ExcelDocument(1)

' Get the table of the first worksheet that will keep the data and the autofilter
Dim xlsTab As ExcelWorksheet = workbook.easy_getSheet("Sheet1")
Dim xlsTable = xlsTab.easy_getExcelTable     

' Add data to cells
...

' Add autofilter to a range of cells
Dim xlsFilter As ExcelFilter = xlsTab.easy_getFilter()
xlsFilter.setAutoFilter("A1:E1")

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

C++

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

// Create a worksheet
workbook->easy_addWorksheet_2("Sheet1");
			
// Get the table of the first worksheet that will keep the data and the autofilter
EasyXLS::IExcelWorksheetPtr xlsTab = 
        (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheet("Sheet1");
EasyXLS::IExcelTablePtr xlsTable = xlsTab->easy_getExcelTable();

// Add data to cells
...

// Add autofilter to a range of cells
EasyXLS::IExcelFilterPtr xlsFilter = 
        (EasyXLS::IExcelFilterPtr)xlsTab->easy_getFilter();
xlsFilter->setAutoFilter_2("A1:E1");

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

Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that exports Excel files, having one sheet
ExcelDocument ^workbook = gcnew ExcelDocument(1);

// Get the table of the first worksheet that will keep the data and the autofilter
ExcelWorksheet ^xlsTab = 
        safe_cast<ExcelWorksheet^>(workbook->easy_getSheet("Sheet1"));
ExcelTable ^xlsTable = xlsTab->easy_getExcelTable();

// Add data to cells
...

// Add autofilter to a range of cells
ExcelFilter ^xlsFilter = xlsTab->easy_getFilter();
xlsFilter->setAutoFilter("A1:E1");

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

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files, having one sheet
ExcelDocument workbook = new ExcelDocument(1);

// Get the table of the first worksheet that will keep the data and the autofilter
ExcelWorksheet xlsTab = ((ExcelWorksheet)workbook.easy_getSheet("Sheet1"));
ExcelTable xlsTable = xlsTab.easy_getExcelTable();

// Add data to cells
...

// Add autofilter to a range of cells
ExcelFilter xlsFilter = xlsTab.easy_getFilter();
xlsFilter.setAutoFilter("A1:E1");

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

.NET:

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

// Create a worksheet
$workbook->easy_addWorksheet_2("Sheet1");
	
// Get the table of the first worksheet that will keep the data and the autofilter
$xlsTable = $workbook->easy_getSheet("Sheet1")->easy_getExcelTable();

// Add data to cells
...

// Add autofilter to a range of cells
$xlsFilter = $xlsTab->easy_getFilter();
$xlsFilter->setAutoFilter_2("A1:E1");

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

Click here to see Continuous Code Listing


Java:

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

// Create a sheet
$workbook->easy_addWorksheet("Sheet1");

// Get the table of data for the worksheet
$xlsTab = $workbook->easy_getSheet("Sheet1");
$xlsTable = $xlsTab->easy_getExcelTable();

// Add data to cells
...

// Apply auto-filter on cell range A1:E1
$xlsFilter = $xlsTab->easy_getFilter();
$xlsFilter->setAutoFilter("A1:E1");
	
// Export Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel autofilter.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 a worksheet
workbook.easy_addWorksheet_2("Sheet1")
	
' Get the table of the first worksheet that will keep the data and the autofilter
Set xlsTable = workbook.easy_getSheet("Sheet1").easy_getExcelTable()

' Add data to cells
...

' Add autofilter to a range of cells
set xlsFilter = xlsTab.easy_getFilter()
xlsFilter.setAutoFilter_2("A1:E1")

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

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

' Create a worksheet
workbook.easy_addWorksheet_2 ("Shet1")
    
' Get the table of the first worksheet that will keep the data and the autofilter
Set xlsTable = workbook.easy_getSheet("Sheet1").easy_getExcelTable()

' Add data to cells
...

' Add autofilter to a range of cells
Set xlsFilter = xlsTab.easy_getFilter()
xlsFilter.setAutoFilter_2 ("A1:E1")

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

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

' Create a worksheet
workbook.easy_addWorksheet_2("Sheet1")
    
' Get the table of the first worksheet that will keep the data and the autofilter
Set xlsTable = workbook.easy_getSheet("Sheet1").easy_getExcelTable()

' Add data to cells
...

' Add autofilter to a range of cells
Set xlsFilter = xlsTab.easy_getFilter()
xlsFilter.setAutoFilter_2("A1:E1")

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

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

<!-- Create a worksheet -->
<cfset ret = workbook.easy_addWorksheet("Sheet1")>

<!-- Get the table of the first worksheet that will keep the data and the autofilter -->
<cfset xlsTable = workbook.easy_getSheet("Sheet1").easy_getExcelTable()>

<!-- Add data to cells -->
...

<!-- Add autofilter to a range of cells -->
<cfset xlsFilter = xlsTab.easy_getFilter()>
<cfset xlsFilter.setAutoFilter("A1:E1")>

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

.NET:

# Create an instance of the class that exports Excel files having one sheet
workbook = ExcelDocument(1)

# Get the table of data for the worksheet
xlsTab = workbook.easy_getSheet("Sheet1")
xlsTable = xlsTab.easy_getExcelTable()

# Add data in cells

...

# Apply auto-filter on cell range A1:E1
xlsFilter = xlsTab.easy_getFilter()
xlsFilter.setAutoFilter("A1:E1")

# Export Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel autofilter.xlsx")

Click here to see Continuous Code Listing


Java:

# Create an instance of the class that exports Excel files having one sheet
workbook = gateway.jvm.ExcelDocument(1)

# Get the table of data for the worksheet
xlsTab = workbook.easy_getSheet("Sheet1")
xlsTable = xlsTab.easy_getExcelTable()

# Add data in cells

...

# Apply auto-filter on cell range A1:E1
xlsFilter = xlsTab.easy_getFilter()
xlsFilter.setAutoFilter("A1:E1")

# Export Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel autofilter.xlsx")

Click here to see Continuous Code Listing