Uses of Class
EasyXLS.ExcelAutoFormat
Namespaces that use ExcelAutoFormat
-
Uses of ExcelAutoFormat in EasyXLS
Methods in EasyXLS that return ExcelAutoFormatModifier and TypeMethodDescriptionExcelAutoFormat.Clone()
Creates and returns a copy of this object.ExcelDataGroup.getAutoFormat()
Returns the autoformat to be applied.Methods in EasyXLS with parameters of type ExcelAutoFormatModifier and TypeMethodDescriptionvoid
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 thestartRow
row index andstartCol
column index.
Thelist
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.
Thelist
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.
Thelist
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 thenStartRow
row index andnStartCol
column indexvoid
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 cellvoid
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 ExcelAutoFormatModifierConstructorDescriptionExcelAutoFormat(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.