Uses of Class EasyXLS.ExcelAutoFormat (EasyXLS API Documentation)

Namespaces that use ExcelAutoFormat

Namespace

Description

EasyXLS

Uses of ExcelAutoFormat in EasyXLS

Methods in EasyXLS that return ExcelAutoFormat

Modifier and Type

Method

Description

ExcelAutoFormat

ExcelAutoFormat.Clone()

Creates and returns a copy of this object.

ExcelAutoFormat

ExcelDataGroup.getAutoFormat()

Returns the autoformat to be applied.

Methods in EasyXLS with parameters of type ExcelAutoFormat

Modifier and Type

Method

Description

void

ExcelWorksheet.easy_addDataGroup(int firstRow, int firstColumn, int lastRow, int lastColumn, int groupRowsColumns, bool isCollapsed, ExcelAutoFormat xlsAutoFormat)

Adds a data group having the specified position, grouping per rows or colums and collapse option to worksheet.
This method is overridden as easy_addDataGroup_3 in COM+ version of EasyXLS.

void

ExcelWorksheet.easy_addDataGroup(System.String range, int groupRowsColumns, bool isCollapsed, ExcelAutoFormat xlsAutoFormat)

Adds a data group having the specified position, grouping per rows or colums and collapse option to worksheet.
This method is overridden as easy_addDataGroup_5 in COM+ version of EasyXLS.

void

ExcelWorksheet.easy_insertList(List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat)

Inserts the data from the specified List object into this ExcelWorksheet starting from the startRow row index and startCol column index.
The list must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.
This method is overridden as easy_insertList_4 in COM+ version of EasyXLS.

void

ExcelWorksheet.easy_insertList(List list, ExcelAutoFormat xlsAutoFormat)

Inserts the data from the specified List object into this ExcelWorksheet starting from the first row and first column of the worksheet data table.
This method is overridden as easy_insertList_2 in COM+ version of EasyXLS. The list must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

void

ExcelWorksheet.easy_insertList(List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat)

Inserts the data from the specified List object into this ExcelWorksheet starting with the specified cell.
The list must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.
This method is overridden as easy_insertList_6 in COM+ version of EasyXLS.

void

ExcelWorksheet.easy_insertDataSet(System.Data.DataSet rs, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, bool includeColumnNames)

Inserts the data from the specified DataSet object into this ExcelWorksheet starting from the nStartRow row index and nStartCol column index

void

ExcelWorksheet.easy_insertDataSet(System.Data.DataSet rs, ExcelAutoFormat xlsAutoFormat, bool includeColumnNames)

Inserts the data from the specified DataSet object into this ExcelWorksheet starting from first row and first column of the worksheet data table.

void

ExcelWorksheet.easy_insertDataSet(System.Data.DataSet rs, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, bool includeColumnNames)

Inserts the data from the specified DataSet object into this ExcelWorksheet starting with the specified cell

void

ExcelTable.easy_setRangeAutoFormat(int startRow, int startColumn, int endRow, int endColumn, ExcelAutoFormat xlsAutoFormat)

Sets the specified autoformat for the range.

void

ExcelTable.easy_setRangeAutoFormat(System.String range, ExcelAutoFormat xlsAutoFormat)

Sets the specified autoformat for the range.
This method is overridden as easy_setRangeAutoFormat_2 in COM+ version of EasyXLS.

void

ExcelTable.easy_setRangeAutoFormat(System.String startCellReference, System.String endCellReference, ExcelAutoFormat xlsAutoFormat)

Sets the specified autoformat for the range limited by the specified cell references.
This method is overridden as easy_setRangeAutoFormat_3 in COM+ version of EasyXLS.

void

ExcelDocument.easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSBFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSBFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromDataSet(System.String path, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromDataSet(System.String path, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSBFile_FromDataSet(System.String path, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromDataSet(System.String path, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromDataSet(System.String path, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSFile_FromDataSet(System.String path, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSXFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSXFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromDataSet(System.String path, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromDataSet(System.String path, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDocument.easy_WriteXLSXFile_FromDataSet(System.String path, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

void

ExcelDataGroup.setAutoFormat(ExcelAutoFormat xlsAutoFormat)

Sets the autoformat to be applied for the data group.

Constructors in EasyXLS with parameters of type ExcelAutoFormat

Modifier

Constructor

Description

ExcelAutoFormat(ExcelAutoFormat xlsAutoFormat)

Defines a table autoformat based on a predefined autoformat.

ExcelDataGroup(int firstRow, int firstColumn, int lastRow, int lastColumn, int groupRowsColumns, bool isCollapsed, ExcelAutoFormat xlsAutoFormat)

Defines an instance of a data group having the specified position, group per rows or columns and collapse options.

ExcelDataGroup(System.String range, int groupRowsColumns, bool isCollapsed, ExcelAutoFormat xlsAutoFormat)

Defines an instance of a data group having the specified position, group per rows or columns and collapse options.

Uses of ClassEasyXLS.ExcelAutoFormat

Uses of ExcelAutoFormat in EasyXLS

Uses of Class
EasyXLS.ExcelAutoFormat