Uses of Class
EasyXLS.ExcelAutoFormat

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.