|
ActiveXLS v6.4.0 API Documentation | ||||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||||
| Namespaces that use ExcelAutoFormat | |
| ActiveXLS | |
| Uses of ExcelAutoFormat in ActiveXLS |
| Methods in ActiveXLS that return ExcelAutoFormat | |
ExcelAutoFormat |
ExcelDataGroup.getAutoFormat()
Returns the autoformat to be applied. |
ExcelAutoFormat |
ExcelAutoFormat.Clone()
Creates and returns a copy of this object. |
| Methods in ActiveXLS with parameters of type ExcelAutoFormat | |
void |
ExcelWorksheet.esd_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.esd_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.esd_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 |
ExcelWorksheet.esd_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. |
void |
ExcelWorksheet.esd_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. |
void |
ExcelWorksheet.esd_insertList(List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat)
Inserts the data from the specified List object into this ExcelWorksheet starting with the specified cell. |
void |
ExcelWorksheet.esd_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. |
void |
ExcelWorksheet.esd_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. |
void |
ExcelTable.esd_setRangeAutoFormat(int startRow,
int startColumn,
int endRow,
int endColumn,
ExcelAutoFormat xlsAutoFormat)
Sets the specified autoformat for the range. |
void |
ExcelTable.esd_setRangeAutoFormat(System.String range,
ExcelAutoFormat xlsAutoFormat)
Sets the specified autoformat for the range. |
void |
ExcelTable.esd_setRangeAutoFormat(System.String startCellReference,
System.String endCellReference,
ExcelAutoFormat xlsAutoFormat)
Sets the specified autoformat for the range limited by the specified cell references. |
void |
ExcelDocument.esd_WriteXLSFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromList(System.IO.Stream f,
List list,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromList(System.IO.Stream f,
List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromList(System.IO.Stream f,
List list,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromList(System.String sPath,
List list,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromList(System.String sPath,
List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSFile_FromList(System.String sPath,
List list,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDocument.esd_WriteXLSXFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromList(System.IO.Stream f,
List list,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromList(System.IO.Stream f,
List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromList(System.IO.Stream f,
List list,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromList(System.String sPath,
List list,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromList(System.String sPath,
List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSXFile_FromList(System.String sPath,
List list,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromDataSet(System.IO.Stream f,
System.Data.DataSet ds,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromDataSet(System.String sPath,
System.Data.DataSet ds,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromList(System.IO.Stream f,
List list,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromList(System.IO.Stream f,
List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromList(System.IO.Stream f,
List list,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromList(System.String sPath,
List list,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromList(System.String sPath,
List list,
System.String startCellReference,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
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.esd_WriteXLSBFile_FromList(System.String sPath,
List list,
int startRow,
int startCol,
ExcelAutoFormat xlsAutoFormat,
System.String sSheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer |
void |
ExcelDataGroup.setAutoFormat(ExcelAutoFormat xlsAutoFormat)
Sets the autoformat to be applied for the data group. |
| Constructors in ActiveXLS with parameters of type ExcelAutoFormat | |
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. |
|
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. |
|
ExcelAutoFormat(ExcelAutoFormat xlsAutoFormat)
Defines a table autoformat based on a predefined autoformat. |
|
|
Copyright 2009 On Time Computing Solutions | ||||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||||