Index
All Classes|All Namespaces|Constant Field Values|Deprecated API
E
- easy_addArrayFormula(int, int, int, int, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds an array formula at the specified range to worksheet.
This method is overridden as easy_addArrayFormula_2 in COM+ version of EasyXLS.
- easy_addArrayFormula(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds an array formula at the specified range to worksheet.
- easy_addCell(ExcelCell) - Method in class EasyXLS.ExcelRow
-
Adds the specified cell to row.
- easy_addChart(ExcelChart) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified chart to worksheet.
- easy_addChart(ExcelChart, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Adds a chart that has the specified location to worksheet.
This method is overridden as easy_addChart_2 in COM+ version of EasyXLS.
- easy_addChart(ExcelChart, int, int, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Adds a chart that has the specified location and size to worksheet.
This method is overridden as easy_addChart_3 in COM+ version of EasyXLS.
- easy_addChart(ExcelChart, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a chart that has the specified location to worksheet.
This method is overridden as easy_addChart_4 in COM+ version of EasyXLS.
- easy_addChart(ExcelChart, String, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Adds a chart that has the specified location and size to worksheet.
This method is overridden as easy_addChart_5 in COM+ version of EasyXLS.
- easy_addChart(ExcelChartSheet) - Method in class EasyXLS.ExcelDocument
-
Adds a chart to the sheet list.
- easy_addChart(String) - Method in class EasyXLS.ExcelDocument
-
Adds a chart sheet having the specified sheet name to the sheet list
This method is overridden as easy_addChart_2 in COM+ version of EasyXLS.
- easy_addChart(String, bool) - Method in class EasyXLS.ExcelDocument
-
Adds a chart sheet having the sheet name and selected option specified
This method is overridden as easy_addChart_3 in COM+ version of EasyXLS.
- easy_addChart(String, bool, String, int) - Method in class EasyXLS.ExcelDocument
-
Adds a chart sheet to the sheet list and the chart has the sheet name, the selected option, the data range and the type of the series specified
This method is overridden as easy_addChart_4 in COM+ version of EasyXLS.
- easy_addChart(String, String, int) - Method in class EasyXLS.ExcelDocument
-
Adds a chart sheet to the sheet list and the chart has the sheet name, the data range and the type of the series specified
This method is overridden as easy_addChart_5 in COM+ version of EasyXLS.
- easy_addColumn() - Method in class EasyXLS.ExcelTable
-
Adds a column to table.
- easy_addColumn(ExcelColumn) - Method in class EasyXLS.ExcelTable
-
Adds the specified column to table.
This method is overridden as easy_addColumn_2 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(int, int, int, int, List) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting at the specified range to worksheet.
This method is overridden as easy_addConditionalFormatting_2 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(ExcelConditionalFormatting) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified conditional formatting range to worksheet.
- easy_addConditionalFormatting(String, int, String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting having the specified range, operator and formula restrictions to worksheet.
This method is overridden as easy_addConditionalFormatting_4 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(String, int, String, String, bool, bool, ThemeColor, ThemeColor) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting having the specified range, operator, formulas restrictions, font settings and background to worksheet.
This method is overridden as easy_addConditionalFormatting_6 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(String, int, String, String, bool, bool, Color) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting having the specified range, operator, formulas restrictions and font settings to worksheet.
This method is overridden as easy_addConditionalFormatting_5 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(String, int, String, String, bool, bool, Color, Color) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting having the specified range, operator, formulas restrictions, font settings and background to worksheet.
This method is overridden as easy_addConditionalFormatting_7 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(String, int, String, String, ThemeColor) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting having the specified range, operator, formulas restrictions and background to worksheet.
This method is overridden as easy_addConditionalFormatting_8 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(String, int, String, String, Color) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting having the specified range, operator, formulas restrictions and background to worksheet.
This method is overridden as easy_addConditionalFormatting_9 in COM+ version of EasyXLS.
- easy_addConditionalFormatting(String, List) - Method in class EasyXLS.ExcelWorksheet
-
Adds a conditional formatting at the specified range to worksheet.
This method is overridden as easy_addConditionalFormatting_3 in COM+ version of EasyXLS.
- easy_addDataGroup(int, int, int, int, int, bool) - Method in class EasyXLS.ExcelWorksheet
-
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_2 in COM+ version of EasyXLS.
- easy_addDataGroup(int, int, int, int, int, bool, ExcelAutoFormat) - Method in class EasyXLS.ExcelWorksheet
-
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.
- easy_addDataGroup(ExcelDataGroup) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified data group to worksheet.
- easy_addDataGroup(String, int, bool) - Method in class EasyXLS.ExcelWorksheet
-
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_4 in COM+ version of EasyXLS.
- easy_addDataGroup(String, int, bool, ExcelAutoFormat) - Method in class EasyXLS.ExcelWorksheet
-
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.
- easy_addDataValidator(int, int, int, int, int, int, String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a data validator having the specified position, validation type, operator and formula restrictions to worksheet.
This method is overridden as easy_addDataValidator_2 in COM+ version of EasyXLS.
- easy_addDataValidator(ExcelDataValidator) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified data validator to worksheet.
- easy_addDataValidator(String, int, int, String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a data validator having the specified position, validation type, operator and formulas restrictions to worksheet.
This method is overridden as easy_addDataValidator_3 in COM+ version of EasyXLS.
- easy_addFooter(ExcelFooter) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified footer to worksheet.
- easy_addFooter(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds the footer having the specified text and position to worksheet.
This method is overridden as easy_addFooter_2 in COM+ version of EasyXLS.
- easy_addFooter(String, String, String, int, bool, bool) - Method in class EasyXLS.ExcelWorksheet
-
Adds the footer having the specified text, position and font settings to worksheet.
This method is overridden as easy_addFooter_3 in COM+ version of EasyXLS.
- easy_addHeader(ExcelHeader) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified header to worksheet.
- easy_addHeader(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds the header having the specified text and position to worksheet.
This method is overridden as easy_addHeader_2 in COM+ version of EasyXLS.
- easy_addHeader(String, String, String, int, bool, bool) - Method in class EasyXLS.ExcelWorksheet
-
Adds the header having the specified text, position and font settings to worksheet.
This method is overridden as easy_addHeader_3 in COM+ version of EasyXLS.
- easy_addHyperlink(ExcelHyperlink) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified hyperlink to worksheet.
- easy_addHyperlink(String, String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a hyperlink having the specified type, url and position to worksheet.
This method is overridden as easy_addHyperlink_2 in COM+ version of EasyXLS.
- easy_addHyperlink(String, String, String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a hyperlink having the specified type, url, tooltip and position to worksheet.
This method is overridden as easy_addHyperlink_3 in COM+ version of EasyXLS.
- easy_addImage(ExcelImage) - Method in class EasyXLS.ExcelSheet
-
Adds the specified image to the sheet.
- easy_addImage(String) - Method in class EasyXLS.ExcelSheet
-
Adds an image that has the specified path to the sheet.
This method is overridden as easy_addImage_2 in COM+ version of EasyXLS.
- easy_addImage(String, int, int) - Method in class EasyXLS.ExcelChartSheet
-
Adds an image that has the specified path and location to chart sheet.
- easy_addImage(String, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Adds an image that has the specified path and location to worksheet.
This method is overridden as easy_addImage_3 in COM+ version of EasyXLS.
- easy_addImage(String, int, int, int, int) - Method in class EasyXLS.ExcelChartSheet
-
Adds an image that has the specified path, location and size to chart sheet.
- easy_addImage(String, int, int, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Adds an image that has the specified path, location and size to worksheet.
This method is overridden as easy_addImage_4 in COM+ version of EasyXLS.
- easy_addImage(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds an image that has the specified path and location to worksheet.
This method is overridden as easy_addImage_5 in COM+ version of EasyXLS.
- easy_addImage(String, String, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Adds an image that has the specified path, location and size to worksheet.
This method is overridden as easy_addImage_6 in COM+ version of EasyXLS.
- easy_addName(ExcelName) - Method in class EasyXLS.ExcelWorksheet
-
Adds the specified name to worksheet.
- easy_addName(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Adds a name having the specified title and formula to worksheet.
This method is overridden as easy_addName_2 in COM+ version of EasyXLS.
- easy_addPivotChart(ExcelPivotChart) - Method in class EasyXLS.ExcelWorksheet
-
Adds a pivot chart to the worksheet.
- easy_addPivotTable(ExcelPivotTable) - Method in class EasyXLS.ExcelWorksheet
-
Adds a pivot table to the worksheet.
- easy_addPivotTable(String, String, String, ExcelDocument) - Method in class EasyXLS.ExcelWorksheet
-
Adds a pivot table having the specified name, location and data source to the worksheet.
This method is overridden as easy_addPivotTable_2 in COM+ version of EasyXLS.
- easy_addRow() - Method in class EasyXLS.ExcelTable
-
Adds a row to table.
- easy_addRow(ExcelRow) - Method in class EasyXLS.ExcelTable
-
Adds the specified row to table.
This method is overridden as easy_addRow_2 in COM+ version of EasyXLS.
- easy_addSeries(ExcelSeries) - Method in class EasyXLS.Charts.ExcelChart
-
Adds a new series to the chart.
- easy_addSeries(String, String) - Method in class EasyXLS.Charts.ExcelChart
-
Adds a new series to the chart.
This method is overridden as easy_addSeries_2 in COM+ version of EasyXLS.
- easy_addWorksheet(ExcelWorksheet) - Method in class EasyXLS.ExcelDocument
-
Adds a worksheet to the sheet list.
- easy_addWorksheet(String) - Method in class EasyXLS.ExcelDocument
-
Adds a worksheet having the specified worksheet name to the sheet list
This method is overridden as easy_addWorksheet_2 in COM+ version of EasyXLS.
- easy_addWorksheet(String, bool) - Method in class EasyXLS.ExcelDocument
-
Adds a worksheet having the worksheet name and selected option specified
This method is overridden as easy_addWorksheet_3 in COM+ version of EasyXLS.
- easy_computeFormulas(ExcelDocument, bool) - Method in class EasyXLS.ExcelWorksheet
-
Calculates all formulas existing in the cells of this ExcelWorksheet
- easy_freezePanes(int, int) - Method in class EasyXLS.ExcelTable
-
Sets the freeze panes for the table.
- easy_freezePanes(int, int, int, int) - Method in class EasyXLS.ExcelTable
-
Sets the freeze panes for the table.
This method is overridden as easy_freezePanes_2 in COM+ version of EasyXLS.
- easy_get3DElevation() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the 3D elevation setting of the chart.
- easy_get3DHeight() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the 3D height setting of the chart.
- easy_get3DPerspective() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the 3D perspective setting of the chart.
- easy_get3DRotation() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the 3D rotation setting of the chart.
- easy_getArrayFormulaAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the array formula from the specified index.
This method is overridden as easy_getArrayFormulaAt_3 in COM+ version of EasyXLS.
- easy_getArrayFormulaAt(int, int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the array formula located at the specified row number and row column.
- easy_getArrayFormulaAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the array formula located at the specified range.
This method is overridden as easy_getArrayFormulaAt_2 in COM+ version of EasyXLS.
- easy_getCategoryXAxis() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the chart category X axis.
- easy_getCategoryXAxisLabels() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the labels of category X axis.
- easy_getCell(int) - Method in class EasyXLS.ExcelRow
-
If a cell does not exist at the specified index, it creates a cell, and returns the cell from the specified index.
- easy_getCell(int, int) - Method in class EasyXLS.ExcelTable
-
If a cell does not exist at the specified position, it creates one, and returns the cell.
- easy_getCell(String) - Method in class EasyXLS.ExcelTable
-
Returns the cell at the specified reference.
This method is overridden as easy_getCell_2 in COM+ version of EasyXLS.
- easy_getCellAt(int) - Method in class EasyXLS.ExcelRow
-
Returns the cell from the specified index.
- easy_getCellAt(int, int) - Method in class EasyXLS.ExcelTable
-
Returns the cell at the specified row and column.
- easy_getCellMergingFirstCol(int) - Method in class EasyXLS.ExcelTable
-
Returns the first column of the specified cell merging range.
- easy_getCellMergingFirstRow(int) - Method in class EasyXLS.ExcelTable
-
Returns the first row of the specified cell merging range.
- easy_getCellMergingLastCol(int) - Method in class EasyXLS.ExcelTable
-
Returns the last column of the specified cell merging range.
- easy_getCellMergingLastRow(int) - Method in class EasyXLS.ExcelTable
-
Returns the last row of the specified cell merging range.
- easy_getChartArea() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the chart area.
- easy_getChartAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the chart from the specified index.
- easy_getChartDataTable() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the chart data table.
- easy_getChartType() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the type of the chart.
- easy_getColumnAt(int) - Method in class EasyXLS.ExcelTable
-
Returns the column at the specified position.
- easy_getColumnsToRepeatAtLeft() - Method in class EasyXLS.ExcelPageSetup
-
Returns the columns to repeat at left.
- easy_getConditionalFormattingAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the conditional formatting range from the specified index.
- easy_getConditionalFormattingAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the conditional formatting from the specified range.
- easy_getDataGroupAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the data group from the specified index.
- easy_getDataGroupAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the data group from the specified range.
This method is overridden as easy_getDataGroupAt_2 in COM+ version of EasyXLS.
- easy_getDataValidatorAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the data validator from the specified index.
- easy_getDataValidatorAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the data validator from the specified range.
- easy_getError() - Method in class EasyXLS.ExcelDocument
-
Returns the error generated during processing the file.
- easy_getExcelChart() - Method in class EasyXLS.ExcelChartSheet
-
Returns the chart of the sheet.
- easy_getExcelTable() - Method in class EasyXLS.ExcelWorksheet
-
Returns the table of the worksheet.
- easy_getFilter() - Method in class EasyXLS.ExcelWorksheet
-
Returns the filter for the worksheet.
- easy_getFooterAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the footer from the specified index.
- easy_getFooterAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the footer from the specified position.
- easy_getHeaderAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the header from the specified index.
- easy_getHeaderAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the header from the specified position.
- easy_getHyperlinkAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the hyperlink from the specified index.
- easy_getHyperlinkAt(int, int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the hyperlink at the specified row index and column index.
This method is overridden as easy_getHyperlinkAt_2 in COM+ version of EasyXLS.
- easy_getHyperlinkAt(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the hyperlink from the specified index.
This method is overridden as easy_getHyperlinkAt_3 in COM+ version of EasyXLS.
- easy_getImage(String) - Method in class EasyXLS.ExcelSheet
-
Returns the image that has the specified path.
- easy_getImageAt(int) - Method in class EasyXLS.ExcelSheet
-
Returns the image from the specified index.
- easy_getLegend() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the chart legend.
- easy_getMergingRangeAsA1Reference(int) - Method in class EasyXLS.ExcelTable
-
Internal use only Returns the cell merging range at the specified range as A1 reference (e.g.
- easy_getName(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the name having the specified title.
- easy_getNameAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the name from the specified index.
- easy_getOptions() - Method in class EasyXLS.ExcelDocument
-
Returns the options of an Excel document, available in the main menu Tools/Options window.
- easy_getPageSetup() - Method in class EasyXLS.ExcelWorksheet
-
Returns the page setup options for the worksheet.
- easy_getPivotTable(String) - Method in class EasyXLS.ExcelWorksheet
-
Returns the pivot table having the specified name.
- easy_getPivotTableAt(int) - Method in class EasyXLS.ExcelWorksheet
-
Returns the pivot table from the specified index.
- easy_getPlotArea() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the chart plot area.
- easy_getPrintArea() - Method in class EasyXLS.ExcelPageSetup
-
Returns the print area.
- easy_getRowAt(int) - Method in class EasyXLS.ExcelTable
-
Returns the row at specified position.
- easy_getRowsToRepeatAtTop() - Method in class EasyXLS.ExcelPageSetup
-
Returns the rows to repeat at top.
- easy_getSeriesAt(int) - Method in class EasyXLS.Charts.ExcelChart
-
Returns the series from the specified index.
- easy_getSeriesGap() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the gap of the chart series.
- easy_getSeriesOverlap() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the overlap of the chart series.
- easy_getSheet(String) - Method in class EasyXLS.ExcelDocument
-
Returns the sheet that has the specified name.
- easy_getSheetAt(int) - Method in class EasyXLS.ExcelDocument
-
Returns the sheet on the specified position.
- easy_getSheetPosition(String) - Method in class EasyXLS.ExcelDocument
-
Returns the position in the sheet list of the sheet that has the specified name.
- easy_getTitle() - Method in class EasyXLS.Charts.ExcelChart
-
Deprecated.
- easy_getValueYAxis() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the chart value Y axis.
- easy_getWarnings() - Method in class EasyXLS.ExcelDocument
-
Returns the warnings occured during processing the file.
- easy_getXAxisMajorGridlines() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the style of the major gridlines for the X axis.
- easy_getXAxisMinorGridlines() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the style of the minor gridlines for the X axis.
- easy_getYAxisMajorGridlines() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the style of the major gridlines for the Y axis.
- easy_getYAxisMinorGridlines() - Method in class EasyXLS.Charts.ExcelChart
-
Returns the style of the minor gridlines for the Y axis.
- easy_insertCellAt(ExcelCell, int) - Method in class EasyXLS.ExcelRow
-
Inserts the specified cell at the specified index.
- easy_insertChart(int, ExcelChartSheet) - Method in class EasyXLS.ExcelDocument
-
Inserts a chart sheet in the sheet list on the specified position.
- easy_insertChart(int, String) - Method in class EasyXLS.ExcelDocument
-
Inserts a chart sheet having the specified sheet name in the sheet list on the specified position
This method is overridden as easy_insertChart_2 in COM+ version of EasyXLS.
- easy_insertChart(int, String, bool) - Method in class EasyXLS.ExcelDocument
-
Inserts a chart sheet having the sheet name and selected option specified
This method is overridden as easy_insertChart_3 in COM+ version of EasyXLS.
- easy_insertChart(int, String, bool, String, int) - Method in class EasyXLS.ExcelDocument
-
Inserts a chart sheet in the sheet list on the specified position
This method is overridden as easy_insertChart_4 in COM+ version of EasyXLS.
The chart has the sheet name, the selected option, the data range and the type of the series specified. - easy_insertChart(int, String, String, int) - Method in class EasyXLS.ExcelDocument
-
Inserts a chart sheet in the sheet list on the specified position and the chart has the sheet name, the data range and the type of the series specified
This method is overridden as easy_insertChart_5 in COM+ version of EasyXLS.
- easy_insertColumn(int, ExcelColumn) - Method in class EasyXLS.ExcelTable
-
Inserts the specified column to table into the specified position.
- easy_insertList(List) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified List object into this ExcelWorksheet starting from the first row and first column of the worksheet data table.
- easy_insertList(List, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified List object into this ExcelWorksheet starting from the
startRow
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_3 in COM+ version of EasyXLS.
- easy_insertList(List, int, int, ExcelAutoFormat) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified List object into this ExcelWorksheet starting from the
startRow
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.
- easy_insertList(List, ExcelAutoFormat) - Method in class EasyXLS.ExcelWorksheet
-
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. - easy_insertList(List, String) - Method in class EasyXLS.ExcelWorksheet
-
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_5 in COM+ version of EasyXLS.
- easy_insertList(List, String, ExcelAutoFormat) - Method in class EasyXLS.ExcelWorksheet
-
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.
- easy_insertPageBreakAtColumn(int) - Method in class EasyXLS.ExcelTable
-
Inserts a page break after the specified column.
- easy_insertPageBreakAtRow(int) - Method in class EasyXLS.ExcelTable
-
Inserts a page break after the specified row.
- easy_insertDataSet(DataSet, bool) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified DataSet object into this ExcelWorksheet starting from first row and first column of the worksheet data table
- easy_insertDataSet(DataSet, int, int, bool) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified DataSet object into this ExcelWorksheet starting from the
nStartRow
row index andnStartCol
column index - easy_insertDataSet(DataSet, int, int, ExcelAutoFormat, bool) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified DataSet object into this ExcelWorksheet starting from the
nStartRow
row index andnStartCol
column index - easy_insertDataSet(DataSet, ExcelAutoFormat, bool) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified DataSet object into this ExcelWorksheet starting from first row and first column of the worksheet data table.
- easy_insertDataSet(DataSet, String, bool) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified DataSet object into this ExcelWorksheet starting with the specified cell
- easy_insertDataSet(DataSet, String, ExcelAutoFormat, bool) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the data from the specified DataSet object into this ExcelWorksheet starting with the specified cell
- easy_insertRow(int, ExcelRow) - Method in class EasyXLS.ExcelTable
-
Inserts the specified row to table into the specified position.
- easy_insertWorksheet(int, ExcelWorksheet) - Method in class EasyXLS.ExcelDocument
-
Inserts a worksheet to the sheet list on the specified position.
- easy_insertWorksheet(int, String) - Method in class EasyXLS.ExcelDocument
-
Inserts a worksheet having the specified worksheet name to the sheet list on the specified position
This method is overridden as easy_insertWorksheet_2 in COM+ version of EasyXLS.
- easy_insertWorksheet(int, String, bool) - Method in class EasyXLS.ExcelDocument
-
Inserts a worksheet having the worksheet name and selected option specified
This method is overridden as easy_insertWorksheet_3 in COM+ version of EasyXLS.
- easy_insertXMLFromFile(InputStream) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified stream into this ExcelWorksheet starting from first row and first column of the worksheet data table
- easy_insertXMLFromFile(InputStream, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified stream into this ExcelWorksheet starting from the
nStartRow
row index andnStartCol
column index - easy_insertXMLFromFile(InputStream, String) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified stream into this ExcelWorksheet starting with the specified cell
- easy_insertXMLFromFile(String) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified XML file into this ExcelWorksheet starting from first row and first column of the worksheet data table
- easy_insertXMLFromFile(String, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified XML file into this ExcelWorksheet starting from the
nStartRow
row index andnStartCol
column index
This method is overridden as easy_insertXMLFromFile_2 in COM+ version of EasyXLS.
- easy_insertXMLFromFile(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified XML file into this ExcelWorksheet starting with the specified cell
This method is overridden as easy_insertXMLFromFile_3 in COM+ version of EasyXLS.
- easy_insertXMLFromString(String) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified string into this ExcelWorksheet starting from first row and first column of the worksheet data table
- easy_insertXMLFromString(String, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified string into this ExcelWorksheet starting from the
nStartRow
row index andnStartCol
column index
This method is overridden as easy_insertXMLFromString_2 in COM+ version of EasyXLS.
- easy_insertXMLFromString(String, String) - Method in class EasyXLS.ExcelWorksheet
-
Inserts the XML data from the specified XML file into this ExcelWorksheet starting with the specified cell
This method is overridden as easy_insertXMLFromString_3 in COM+ version of EasyXLS.
- easy_IsExcel(InputStream) - Method in class EasyXLS.ExcelDocument
-
Checks if the specified file is a Microsoft Excel document.
- easy_IsExcel(String) - Method in class EasyXLS.ExcelDocument
-
Checks if the specified file is a Microsoft Excel document.
- easy_LoadCSVFile(InputStream) - Method in class EasyXLS.ExcelDocument
-
Generates the document at the specified stream
Available for: Professional, Reader
- easy_LoadCSVFile(InputStreamReader) - Method in class EasyXLS.ExcelDocument
-
Generates the document at the specified stream
Available for: Professional, Reader
- easy_LoadCSVFile(String) - Method in class EasyXLS.ExcelDocument
-
Loads a specified CSV document
Available for: Professional, Reader
- easy_LoadCSVFile(String, String) - Method in class EasyXLS.ExcelDocument
-
Loads the CSV file with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_LoadCSVFile_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_LoadHTMLFile(InputStream) - Method in class EasyXLS.ExcelDocument
-
Loads the specified HTML file
Available for: Professional, Reader
- easy_LoadHTMLFile(InputStreamReader) - Method in class EasyXLS.ExcelDocument
-
Loads the specified HTML file and the character encoding can be set to the stream
Available for: Professional, Reader
- easy_LoadHTMLFile(String) - Method in class EasyXLS.ExcelDocument
-
Loads the specified HTML file
This method is overridden as easy_LoadHTMLFile_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_LoadHTMLFile(String, String) - Method in class EasyXLS.ExcelDocument
-
Loads the HTML file with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_LoadHTMLFile_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_LoadTXTFile(InputStreamReader, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the document at the specified stream and the character encoding can be set to the stream
Available for: Professional, Reader
- easy_LoadTXTFile(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the document at the specified stream
Available for: Professional, Reader
- easy_LoadTXTFile(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Loads a specified document
Available for: Professional, Reader
- easy_LoadTXTFile(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Loads the TXT file with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_LoadTXTFile_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_LoadXLSBFile(InputStream) - Method in class EasyXLS.ExcelDocument
-
Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_LoadXLSBFile(String) - Method in class EasyXLS.ExcelDocument
-
Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_LoadXLSFile(InputStream) - Method in class EasyXLS.ExcelDocument
-
Loads a specified Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_LoadXLSFile(String) - Method in class EasyXLS.ExcelDocument
-
Loads a specified Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_LoadXLSXFile(InputStream) - Method in class EasyXLS.ExcelDocument
-
Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_LoadXLSXFile(String) - Method in class EasyXLS.ExcelDocument
-
Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_LoadXMLSpreadsheetFile(InputStream) - Method in class EasyXLS.ExcelDocument
-
Loads a specified XML Spreadsheet document
Available for: Professional, Reader
- easy_LoadXMLSpreadsheetFile(String) - Method in class EasyXLS.ExcelDocument
-
Loads a specified XML Spreadsheet document
Available for: Professional, Reader
- easy_mergeCells(int, int, int, int) - Method in class EasyXLS.ExcelTable
-
Merging the cells inside the specified range.
- easy_mergeCells(String) - Method in class EasyXLS.ExcelTable
-
Merging the cells inside the specified range.
This method is overridden as easy_mergeCells_2 in COM+ version of EasyXLS.
- easy_mergeCells(String, String) - Method in class EasyXLS.ExcelTable
-
Merging the cells inside the range limited by the specified cell references.
This method is overridden as easy_mergeCells_3 in COM+ version of EasyXLS.
- easy_ReadCSVFile_AsList(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV document
Available for: Professional, Reader
- easy_ReadCSVFile_AsList(InputStreamReader) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV document
Available for: Professional, Reader
- easy_ReadCSVFile_AsList(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV document
Available for: Professional, Reader
- easy_ReadCSVFile_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV file with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_ReadCSVFile_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadCSVFile_AsDataSet(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV document
Available for: Professional, Reader
- easy_ReadCSVFile_AsDataSet(InputStreamReader) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV document
Available for: Professional, Reader
- easy_ReadCSVFile_AsDataSet(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified CSV document
Available for: Professional, Reader
- easy_ReadCSVFile_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the CSV file with specified encoding; most common values are available in
Encoding
class
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsList(ExcelWorksheet) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsList(ExcelWorksheet, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsList(ExcelWorksheet, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsList(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsList(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_6 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsDataSet(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsDataSet(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(OutputStream, ExcelWorksheet) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(OutputStream, ExcelWorksheet, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(OutputStream, ExcelWorksheet, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(OutputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(OutputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(OutputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(String, ExcelWorksheet) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(String, ExcelWorksheet, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(String, ExcelWorksheet, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadExcelWorksheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_6 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadTXTFile_AsList(InputStreamReader, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified TXT document
Available for: Professional, Reader
- easy_ReadTXTFile_AsList(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified TXT document
Available for: Professional, Reader
- easy_ReadTXTFile_AsList(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified TXT document
Available for: Professional, Reader
- easy_ReadTXTFile_AsList(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the TXT file with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_ReadTXTFile_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadTXTFile_AsDataSet(InputStreamReader, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified TXT document
Available for: Professional, Reader
- easy_ReadTXTFile_AsDataSet(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified TXT document
Available for: Professional, Reader
- easy_ReadTXTFile_AsDataSet(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified TXT document
Available for: Professional, Reader
- easy_ReadTXTFile_AsDataSet(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the TXT file with specified encoding; most common values are available in
Encoding
class
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsList(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsList(InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsList(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsList(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsDataSet(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsDataSet(InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsDataSet(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsDataSet(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsXML(OutputStream, InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsXML(OutputStream, InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsXML(OutputStream, InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsXML(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsXML(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSActiveSheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSActiveSheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSActiveSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsList(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsList(InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsList(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsList(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsDataSet(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsDataSet(InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsDataSet(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsDataSet(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsXML(OutputStream, InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsXML(OutputStream, InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsXML(OutputStream, InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsXML(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsXML(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBActiveSheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBActiveSheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBActiveSheet_AsXML_3 in of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBFile_SheetNames(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the sheet names of the Microsoft Excel document (XLSB file format)
Available for: Professional, Reader
- easy_ReadXLSBFile_SheetNames(String) - Method in class EasyXLS.ExcelDocument
-
Reads the sheet names of the Microsoft Excel document (XLSB file format)
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsList(InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsList(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsList(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsList(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
This method is overridden as easy_ReadXLSBSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsDataSet(InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsDataSet(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsDataSet(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsDataSet(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsXML(OutputStream, InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsXML(OutputStream, InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsXML(OutputStream, InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBSheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsXML(String, String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSBSheet_AsXML(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSFile_SheetNames(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the sheet names of the Microsoft Excel document (XLS file format)
Available for: Professional, Reader
- easy_ReadXLSFile_SheetNames(String) - Method in class EasyXLS.ExcelDocument
-
Reads the sheet names of the Microsoft Excel document (XLS file format)
Available for: Professional, Reader
- easy_ReadXLSSheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSSheet_AsList(InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsList(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
This method is overridden as easy_ReadXLSSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSSheet_AsList(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsList(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSSheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSSheet_AsDataSet(InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsDataSet(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
- easy_ReadXLSSheet_AsDataSet(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsDataSet(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSSheet_AsXML(OutputStream, InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSSheet_AsXML(OutputStream, InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSSheet_AsXML(OutputStream, InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSSheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSSheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSSheet_AsXML(String, String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSSheet_AsXML(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsList(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsList(InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsList(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsList(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsDataSet(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsDataSet(InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsDataSet(String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsDataSet(String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsXML(OutputStream, InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsXML(OutputStream, InputStream, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsXML(OutputStream, InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsXML(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsXML(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXActiveSheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXActiveSheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXActiveSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXFile_SheetNames(InputStream) - Method in class EasyXLS.ExcelDocument
-
Reads the sheet names of the Microsoft Excel document (XLSX file format)
Available for: Professional, Reader
- easy_ReadXLSXFile_SheetNames(String) - Method in class EasyXLS.ExcelDocument
-
Reads the sheet names of the Microsoft Excel document (XLSX file format)
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsList(InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsList(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsList(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsList(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
This method is overridden as easy_ReadXLSXSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsDataSet(InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsDataSet(InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsDataSet(String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsDataSet(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsXML(OutputStream, InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsXML(OutputStream, InputStream, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsXML(OutputStream, InputStream, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsXML(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXSheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsXML(String, String, String, int, int, int, int) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader
- easy_ReadXLSXSheet_AsXML(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXMLSpreadsheet_AsList(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a List object
Available for: Professional, Reader
- easy_ReadXMLSpreadsheet_AsList(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
This method is overridden as easy_ReadXMLSpreadsheet_AsList_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
- easy_ReadXMLSpreadsheet_AsDataSet(InputStream, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
Available for: Professional, Reader
- easy_ReadXMLSpreadsheet_AsDataSet(String, String) - Method in class EasyXLS.ExcelDocument
-
Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
Available for: Professional, Reader
- easy_removeArrayFormula(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the array formula from the specified index.
- easy_removeArrayFormula(int, int, int, int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the array formula located at the specified reference.
This method is overridden as easy_removeArrayFormula_3 in COM+ version of EasyXLS.
- easy_removeArrayFormula(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the array formula located at the specified reference.
This method is overridden as easy_removeArrayFormula_2 in COM+ version of EasyXLS.
- easy_removeCellAt(int) - Method in class EasyXLS.ExcelRow
-
Removes the cell from the specified index
- easy_removeCellMerging(int) - Method in class EasyXLS.ExcelTable
-
Removes the cell merging area at the specified index from the table
- easy_removeCellRange(int, int) - Method in class EasyXLS.ExcelRow
-
Removes a range of cells from the row
- easy_removeChart(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the chart from the specified index.
- easy_removeColumn(int) - Method in class EasyXLS.ExcelTable
-
Removes the column at the specified index from the table
- easy_removeColumnRange(int, int) - Method in class EasyXLS.ExcelTable
-
Removes a range of columns from the table
- easy_removeConditionalFormatting(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the conditional formatting range from the specified index.
- easy_removeConditionalFormatting(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the conditional formatting from the specified range.
- easy_removeDataGroup(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the data group from the specified index.
- easy_removeDataGroup(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the data group from the specified range.
This method is overridden as easy_removeDataGroup_2 in COM+ version of EasyXLS.
- easy_removeDataValidator(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the data validator from the specified index.
- easy_removeDataValidator(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the data validator from the specified range.
This method is overridden as easy_removeDataValidator_2 in COM+ version of EasyXLS.
- easy_removeFooter(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the footer from the specified index.
- easy_removeFooter(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the footer from the specified position.
- easy_removeHeader(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the header from the specified index.
- easy_removeHeader(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the header from the specified position.
- easy_removeHyperlink(int, bool) - Method in class EasyXLS.ExcelWorksheet
-
Removes the hyperlink from the specified index.
- easy_removeHyperlink(String, bool) - Method in class EasyXLS.ExcelWorksheet
-
Removes the hyperlink from the specified position.
This method is overridden as easy_removeHyperlink_2 in COM+ version of EasyXLS.
- easy_removeImage(int) - Method in class EasyXLS.ExcelSheet
-
Removes the image from the specified index.
- easy_removeImage(String) - Method in class EasyXLS.ExcelSheet
-
Removes the image that has the specified path from the sheet.
This method is overridden as easy_removeImage_2 in COM+ version of EasyXLS.
- easy_removeName(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the name from the specified index.
- easy_removeName(String) - Method in class EasyXLS.ExcelWorksheet
-
Removes the name having the specified title.
- easy_removePivotTable(int) - Method in class EasyXLS.ExcelWorksheet
-
Removes the pivot table from the specified index.
- easy_removePrintArea() - Method in class EasyXLS.ExcelPageSetup
-
Removes the print area.
- easy_removeRow(int) - Method in class EasyXLS.ExcelTable
-
Removes the row at the specified index from the table
- easy_removeRowRange(int, int) - Method in class EasyXLS.ExcelTable
-
Removes a range of rows from the table
- easy_removeSeries(int) - Method in class EasyXLS.Charts.ExcelChart
-
Removes the series from the specified index.
- easy_removeSheet(int) - Method in class EasyXLS.ExcelDocument
-
Removes a sheet from the sheet list on the specified position.
- easy_removeSheet(String) - Method in class EasyXLS.ExcelDocument
-
Removes the sheet that has the specified name from the sheet list
This method is overridden as easy_removeSheet_2 in COM+ version of EasyXLS.
- easy_removeSplit() - Method in class EasyXLS.ExcelTable
-
Removes the split option for the table.
- easy_removeVBMacros() - Method in class EasyXLS.ExcelDocument
-
Removes the VB project and macros if any.
- easy_resetAllPageBreaks() - Method in class EasyXLS.ExcelTable
-
Resets all the defined page breaks.
- easy_set3DElevation(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the 3D elevation setting of the chart.
- easy_set3DHeight(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the 3D height of the chart.
- easy_set3DPerspective(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the 3D perspective of the chart.
- easy_set3DRotation(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the 3D rotation of the chart.
- easy_setCategoryXAxis(ExcelAxis) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the chart category X axis.
- easy_setCategoryXAxisLabels(String) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the labels of category X axis.
- easy_setCellAt(ExcelCell, int) - Method in class EasyXLS.ExcelRow
-
Sets the specified cell at the specified index.
- easy_setCellAt(ExcelCell, int, int) - Method in class EasyXLS.ExcelTable
-
Sets the cell at the specified position.
- easy_setChartArea(ExcelChartArea) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the chart area.
- easy_setChartDataTable(ExcelDataTable) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the chart data table.
- easy_setChartType(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the type of the chart.
- easy_setColumnsToRepeatAtLeft(int, int) - Method in class EasyXLS.ExcelPageSetup
-
Sets the columns to repeat at left.
- easy_setColumnsToRepeatAtLeft(int, int, bool) - Method in class EasyXLS.ExcelPageSetup
-
Sets the columns to repeat at left.
This method is overridden as easy_setColumnsToRepeatAtLeft_2 in COM+ version of EasyXLS.
- easy_setColumnsToRepeatAtLeft(String) - Method in class EasyXLS.ExcelPageSetup
-
Sets the columns to repeat at left.
This method is overridden as easy_setColumnsToRepeatAtLeft_3 in COM+ version of EasyXLS.
- easy_setExcelChart(ExcelChart) - Method in class EasyXLS.ExcelChartSheet
-
Sets the chart of the sheet.
- easy_setExcelTable(ExcelTable) - Method in class EasyXLS.ExcelWorksheet
-
Sets the table of the worksheet.
- easy_setLegend(ExcelChartLegend) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the chart legend.
- easy_setOptions(ExcelOptions) - Method in class EasyXLS.ExcelDocument
-
Sets the options of an Excel document, available in the main menu Tools/Options window.
- easy_setPlotArea(ExcelPlotArea) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the chart plot area.
- easy_setPrintArea(int, int, int, int) - Method in class EasyXLS.ExcelPageSetup
-
Sets the print area.
- easy_setPrintArea(int, int, int, int, bool) - Method in class EasyXLS.ExcelPageSetup
-
Sets the print area.
This method is overridden as easy_setPrintArea_2 in COM+ version of EasyXLS.
- easy_setPrintArea(String) - Method in class EasyXLS.ExcelPageSetup
-
Sets the print area.
This method is overridden as easy_setPrintArea_3 in COM+ version of EasyXLS.
- easy_setRangeAutoFormat(int, int, int, int, ExcelAutoFormat) - Method in class EasyXLS.ExcelTable
-
Sets the specified autoformat for the range.
- easy_setRangeAutoFormat(String, ExcelAutoFormat) - Method in class EasyXLS.ExcelTable
-
Sets the specified autoformat for the range.
This method is overridden as easy_setRangeAutoFormat_2 in COM+ version of EasyXLS.
- easy_setRangeAutoFormat(String, String, ExcelAutoFormat) - Method in class EasyXLS.ExcelTable
-
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.
- easy_setRangeStyle(int, int, int, int, ExcelStyle) - Method in class EasyXLS.ExcelTable
-
Sets the specified style for the range limited by the rows and columns.
- easy_setRangeStyle(String, ExcelStyle) - Method in class EasyXLS.ExcelTable
-
Sets the specified style for the range.
This method is overridden as easy_setRangeStyle_2 in COM+ version of EasyXLS.
- easy_setRangeStyle(String, String, ExcelStyle) - Method in class EasyXLS.ExcelTable
-
Sets the specified style for the range limited by the specified cell references.
This method is overridden as easy_setRangeStyle_3 in COM+ version of EasyXLS.
- easy_setRowsToRepeatAtTop(int, int) - Method in class EasyXLS.ExcelPageSetup
-
Sets the rows to repeat at top.
- easy_setRowsToRepeatAtTop(int, int, bool) - Method in class EasyXLS.ExcelPageSetup
-
Sets the rows to repeat at top.
This method is overridden as easy_setRowsToRepeatAtTop_2 in COM+ version of EasyXLS.
- easy_setRowsToRepeatAtTop(String) - Method in class EasyXLS.ExcelPageSetup
-
Sets the rows to repeat at top.
This method is overridden as easy_setRowsToRepeatAtTop_3 in COM+ version of EasyXLS.
- easy_setSeriesGap(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the gap of the chart series.
- easy_setSeriesOverlap(int) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the overlap of the chart series.
- easy_setTitle(String) - Method in class EasyXLS.Charts.ExcelChart
-
Deprecated.As of version 8.3, replaced by
ExcelTitle.setText(System.String)
- easy_setUse3DPerspective(bool) - Method in class EasyXLS.Charts.ExcelChart
-
Sets if the 3D setting of the chart is used.
- easy_setValueYAxis(ExcelAxis) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the chart value Y axis.
- easy_setXAxisMajorGridlines(ExcelChartGridlines) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the style of the major gridlines for the X axis.
- easy_setXAxisMinorGridlines(ExcelChartGridlines) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the style of the minor gridlines for the X axis.
- easy_setYAxisMajorGridlines(ExcelChartGridlines) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the style of the major gridlines for the Y axis.
- easy_setYAxisMinorGridlines(ExcelChartGridlines) - Method in class EasyXLS.Charts.ExcelChart
-
Sets the style of the major gridlines for the Y axis.
- easy_split(int, int) - Method in class EasyXLS.ExcelTable
-
Sets the split option for the table.
- easy_split(int, int, int, int) - Method in class EasyXLS.ExcelTable
-
Sets the split option for the table.
This method is overridden as easy_split_2 in COM+ version of EasyXLS.
- easy_unfreezePanes() - Method in class EasyXLS.ExcelTable
-
Unfreezes panes for the table.
- easy_Use3DPerspective() - Method in class EasyXLS.Charts.ExcelChart
-
Returns if the 3D perspective of the chart is used
- easy_WriteCSVFile(OutputStream, String) - Method in class EasyXLS.ExcelDocument
-
Generates the CSV at the specified stream
Available for: Professional, Writer
- easy_WriteCSVFile(OutputStreamWriter, String) - Method in class EasyXLS.ExcelDocument
-
Generates the CSV at the specified stream and the character encoding can be set to the stream
Available for: Professional, Writer
- easy_WriteCSVFile(String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the CSV document at the specified path
Available for: Professional, Writer
- easy_WriteCSVFile(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the CSV file at the specified path with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_WriteCSVFile_4 in COM+ version of EasyXLS.
Available for: Professional, Writer
- easy_WriteHTMLFile(OutputStream, String) - Method in class EasyXLS.ExcelDocument
-
Generates the HTML at the specified stream
Available for: Professional, Writer
- easy_WriteHTMLFile(OutputStreamWriter, String) - Method in class EasyXLS.ExcelDocument
-
Generates the HTML at the specified stream and the character encoding can be set to the stream.
Available for: Professional, Writer
- easy_WriteHTMLFile(String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the HTML document at the specified path
This method is overridden as easy_WriteHTMLFile_3 in COM+ version of EasyXLS.
Available for: Professional, Writer
- easy_WriteHTMLFile(String, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the HTML file at the specified path with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_WriteHTMLFile_4 in COM+ version of EasyXLS.
Available for: Professional, Writer
- easy_WriteTXTFile(OutputStream, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the document at the specified stream
Available for: Professional, Writer
- easy_WriteTXTFile(OutputStreamWriter, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the document at the specified stream and the character encoding can be set to the stream
Available for: Professional, Writer
- easy_WriteTXTFile(String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the TXT document at the specified path
Available for: Professional, Writer
- easy_WriteTXTFile(String, String, String, String, String) - Method in class EasyXLS.ExcelDocument
-
Generates the TXT file at the specified path with specified encoding; most common values are available in
Encoding
class
This method is overridden as easy_WriteTXTFile_4 in COM+ version of EasyXLS.
Available for: Professional, Writer
- easy_WriteXLSBFile(OutputStream) - Method in class EasyXLS.ExcelDocument
-
Generates the Microsoft Excel document (Office 2007 binary file format) at the specified stream
Available for: Professional, Writer
- easy_WriteXLSBFile(String) - Method in class EasyXLS.ExcelDocument
-
Generates the Microsoft Excel Office2007 binary document at the specified path
Available for: Professional, Writer
- easy_WriteXLSBFile_FromList(OutputStream, List, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromList(OutputStream, List, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromList(OutputStream, List, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromList(String, List, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromList(String, List, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
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
- easy_WriteXLSBFile_FromList(String, List, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
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
- easy_WriteXLSBFile_FromDataSet(OutputStream, DataSet, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromDataSet(OutputStream, DataSet, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromDataSet(OutputStream, DataSet, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromDataSet(String, DataSet, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromDataSet(String, DataSet, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSBFile_FromDataSet(String, DataSet, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile(OutputStream) - Method in class EasyXLS.ExcelDocument
-
Generates the Microsoft Excel document (Office 97-2003) at the specified stream
Available for: Professional, Writer
- easy_WriteXLSFile(String) - Method in class EasyXLS.ExcelDocument
-
Generates the Microsoft Excel document (Office 97-2003) at the specified path
Available for: Professional, Writer
- easy_WriteXLSFile_FromList(OutputStream, List, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromList(OutputStream, List, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromList(OutputStream, List, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromList(String, List, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromList(String, List, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
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
- easy_WriteXLSFile_FromList(String, List, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
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
- easy_WriteXLSFile_FromDataSet(OutputStream, DataSet, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromDataSet(OutputStream, DataSet, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromDataSet(OutputStream, DataSet, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromDataSet(String, DataSet, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromDataSet(String, DataSet, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSFile_FromDataSet(String, DataSet, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile(OutputStream) - Method in class EasyXLS.ExcelDocument
-
Generates the Microsoft Excel document (Office 2007 file format) at the specified stream
Available for: Professional, Writer
- easy_WriteXLSXFile(String) - Method in class EasyXLS.ExcelDocument
-
Generates the Microsoft Excel Office2007 document at the specified path
Available for: Professional, Writer
- easy_WriteXLSXFile_FromList(OutputStream, List, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromList(OutputStream, List, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromList(OutputStream, List, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromList(String, List, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromList(String, List, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
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
- easy_WriteXLSXFile_FromList(String, List, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
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
- easy_WriteXLSXFile_FromDataSet(OutputStream, DataSet, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromDataSet(OutputStream, DataSet, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromDataSet(OutputStream, DataSet, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromDataSet(String, DataSet, int, int, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromDataSet(String, DataSet, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXLSXFile_FromDataSet(String, DataSet, String, ExcelAutoFormat, String) - Method in class EasyXLS.ExcelDocument
-
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer
- easy_WriteXMLFile(OutputStream) - Method in class EasyXLS.ExcelDocument
-
Generates the XML document at the specified stream
Available for: Professional, Writer
- easy_WriteXMLFile(String) - Method in class EasyXLS.ExcelDocument
-
Generates the XML document at the specified path
Available for: Professional, Writer
- EasyXLS - package EasyXLS
- EasyXLS.Charts - package EasyXLS.Charts
- EasyXLS.Constants - package EasyXLS.Constants
- EasyXLS.Drawings - package EasyXLS.Drawings
- EasyXLS.Drawings.Formatting - package EasyXLS.Drawings.Formatting
- EasyXLS.FileProperties - package EasyXLS.FileProperties
- EasyXLS.PivotTables - package EasyXLS.PivotTables
- EasyXLS.Themes - package EasyXLS.Themes
- EasyXLS.Util - package EasyXLS.Util
- EffectDrawingObject - Class in EasyXLS.Drawings
-
This class stores a drawing shape having a 3D-formatting.
- EffectDrawingObject() - Constructor for class EasyXLS.Drawings.EffectDrawingObject
-
Defines an instance of a drawing shape having a 3D-formatting.
- elementAt(int) - Method in class EasyXLS.Util.List
-
Returns the element from the specified index
- Encoding - Class in EasyXLS.Constants
-
This class contains the constants for handling encoding in text file formats
- Encoding() - Constructor for class EasyXLS.Constants.Encoding
- Encrypt - Class in EasyXLS.Constants
-
This class contains the constants for available encryption types.
- Encrypt() - Constructor for class EasyXLS.Constants.Encrypt
- ENCRYPTION_NONE - Constant in class EasyXLS.Constants.Encrypt
-
A constant indicating that no encryption is set for the document.
- ENCRYPTION_OFFICE_97_2000_COMPATIBLE - Constant in class EasyXLS.Constants.Encrypt
-
A constant indicating the encryption type that is Office 97/2000 compatible.
- ENCRYPTION_WEAK_XOR - Constant in class EasyXLS.Constants.Encrypt
-
A constant indicating the weak encryption (XOR).
- ERROR - Constant in class EasyXLS.Constants.DataType
-
A constant indicating the "error" data type.
- ERROR_INFO - Constant in class EasyXLS.Constants.DataValidator
-
A constant indicating the "Error message" box type.
- ERROR_STOP - Constant in class EasyXLS.Constants.DataValidator
-
A constant indicating the "Error message" box type.
- ERROR_WARNING - Constant in class EasyXLS.Constants.DataValidator
-
A constant indicating the "Error message" box type.
- ErrorType - Class in EasyXLS.Constants
-
This class contains the constants for possible errors.
- ErrorType() - Constructor for class EasyXLS.Constants.ErrorType
- ExcelArrayFormula - Class in EasyXLS
-
This class describes a formula that was array-entered into a range of cells.
- ExcelArrayFormula() - Constructor for class EasyXLS.ExcelArrayFormula
-
Defines an empty instance of the array formula
- ExcelArrayFormula(int, int, int, int, String) - Constructor for class EasyXLS.ExcelArrayFormula
-
Defines an instance of the array formula
- ExcelArrayFormula(String, String) - Constructor for class EasyXLS.ExcelArrayFormula
-
Defines an instance of the array formula having the specified range and formula restrictions.
- ExcelAutoFormat - Class in EasyXLS
-
This class stores the table autoformat information like font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, cell locked or hidden, shrink, border type, border color.
- ExcelAutoFormat() - Constructor for class EasyXLS.ExcelAutoFormat
-
Defines a table autoformat that is initialized with the default style.
- ExcelAutoFormat(int) - Constructor for class EasyXLS.ExcelAutoFormat
-
Defines a table autoformat that is one of the predefined autoformats.
- ExcelAutoFormat(ExcelAutoFormat) - Constructor for class EasyXLS.ExcelAutoFormat
-
Defines a table autoformat based on a predefined autoformat.
- ExcelAutoFormat(ExcelStyle) - Constructor for class EasyXLS.ExcelAutoFormat
-
Defines a table autoformat that is initialized with a specific style.
- ExcelAutoFormat(ExcelStyle, ExcelStyle, ExcelStyle) - Constructor for class EasyXLS.ExcelAutoFormat
-
Defines a table autoformat that is initialized with a specific style and has a specific header row and footer row style.
- ExcelAutoFormat(ExcelStyle, ExcelStyle, ExcelStyle, ExcelStyle) - Constructor for class EasyXLS.ExcelAutoFormat
-
Defines a table autoformat that is initialized with a specific striped style and has a specific header row and footer row style.
- ExcelAxis - Class in EasyXLS.Charts
-
This class stores the chart axis information like extends label, fill settings, font settings, line settings, shadow settings, alignment settings, type of major and minor tick mark, tick mark label, number format, rotation of the axis, visibility.
- ExcelAxis() - Constructor for class EasyXLS.Charts.ExcelAxis
-
Defines an instance of the excel axis.
- ExcelCalculatedField - Class in EasyXLS.PivotTables
-
This class stores the formula for a calculated field of pivot table.
- ExcelCalculatedField() - Constructor for class EasyXLS.PivotTables.ExcelCalculatedField
-
Defines an instance of the pivot table field.
- ExcelCell - Class in EasyXLS
-
This class stores the cell information like value, format (font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, cell locked or hidden, shrink, border type, border color) and comment.
- ExcelCell() - Constructor for class EasyXLS.ExcelCell
-
Defines an instance of the Excel cell.
- ExcelChart - Class in EasyXLS.Charts
-
This class stores chart information like series, legend, axis, plot area, chart area, data table, title, series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.
- ExcelChart() - Constructor for class EasyXLS.Charts.ExcelChart
-
Defines an instance of the chart.
- ExcelChart(int, int) - Constructor for class EasyXLS.Charts.ExcelChart
-
Defines an instance of the chart having the specified location
This constructor is applicable only to adding charts to ExcelWorksheet objects
- ExcelChart(int, int, int, int) - Constructor for class EasyXLS.Charts.ExcelChart
-
Defines an instance of the chart having the specified location and size
This constructor is applicable only to adding charts to ExcelWorksheet objects
- ExcelChart(String) - Constructor for class EasyXLS.Charts.ExcelChart
-
Defines an instance of the chart having the specified location
This constructor is applicable only to adding charts to ExcelWorksheet objects
- ExcelChart(String, int, int) - Constructor for class EasyXLS.Charts.ExcelChart
-
Defines an instance of the chart having the specified location and size
This constructor is applicable only to adding charts to ExcelWorksheet objects
- ExcelChartArea - Class in EasyXLS.Charts
-
This class stores the chart area information like fill settings, font settings, line settings and shadow settings.
- ExcelChartArea() - Constructor for class EasyXLS.Charts.ExcelChartArea
-
Defines an instance of the chart area.
- ExcelChartGridlines - Class in EasyXLS.Charts
-
This class stores the chart gridlines information like line settings, shadow settings and visibility.
- ExcelChartGridlines() - Constructor for class EasyXLS.Charts.ExcelChartGridlines
-
Defines an instance of the chart gridlines.
- ExcelChartLegend - Class in EasyXLS.Charts
-
This class stores the ChartLegend information like fill settings, font settings, line settings, shadow settings, legend position, keys arrangement direction, visibility .
- ExcelChartLegend() - Constructor for class EasyXLS.Charts.ExcelChartLegend
-
Defines an instance of the excel legend.
- ExcelChartSheet - Class in EasyXLS
-
This class stores chart information like series, legend, axis, plot area, chart area, data table, title, series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.
- ExcelChartSheet() - Constructor for class EasyXLS.ExcelChartSheet
-
Defines an instance of a sheet that contains a chart.
- ExcelChartSheet(String) - Constructor for class EasyXLS.ExcelChartSheet
-
Defines an instance of a sheet that has the sheet name defined and contains a chart.
- ExcelColorScheme - Class in EasyXLS.Themes
-
This class stores the colors information for a theme.
- ExcelColorScheme() - Constructor for class EasyXLS.Themes.ExcelColorScheme
-
Defines a color scheme that is initialized with the built-in Office colors.
- ExcelColorScheme(String) - Constructor for class EasyXLS.Themes.ExcelColorScheme
-
Defines a color scheme that is initialized with the specified built-in theme colors.
- ExcelColumn - Class in EasyXLS
-
This class stores the column information extends width and format (font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, column cells locked or hidden, shrink, border type, border color).
- ExcelColumn() - Constructor for class EasyXLS.ExcelColumn
-
Defines an instance of the Excel column.
- ExcelComment - Class in EasyXLS.Drawings
-
This class stores the comment information like text, font name, font size, font style, foreground and comment position.
- ExcelComment() - Constructor for class EasyXLS.Drawings.ExcelComment
-
Defines an instance of the Excel comment.
- ExcelComment(String) - Constructor for class EasyXLS.Drawings.ExcelComment
-
Defines an instance of the Excel comment having the specified text.
- ExcelComment(String, int, int) - Constructor for class EasyXLS.Drawings.ExcelComment
-
Defines an instance of the Excel comment having the specified text and size.
- ExcelComment(String, String, int, bool, bool, Color) - Constructor for class EasyXLS.Drawings.ExcelComment
-
Defines an instance of the Excel comment having the specified text and font settings.
- ExcelCondition - Class in EasyXLS
-
This class stores the condition of the conditional formatting information like type, operator, first and second formula, font, border and pattern style.
- ExcelCondition() - Constructor for class EasyXLS.ExcelCondition
-
Defines an instance of the condition.
- ExcelCondition(int, String, String) - Constructor for class EasyXLS.ExcelCondition
-
Defines an instance of the condition, having the specified operator and formula restrictions.
- ExcelCondition(int, String, String, bool, bool, Color) - Constructor for class EasyXLS.ExcelCondition
-
Defines an instance of the condition, having the specified operator, formula restrictions and font settings.
- ExcelCondition(int, String, String, bool, bool, Color, Color) - Constructor for class EasyXLS.ExcelCondition
-
Defines an instance of the condition, having the specified operator, formula restrictions, font settings and background.
- ExcelCondition(int, String, String, Color) - Constructor for class EasyXLS.ExcelCondition
-
Defines an instance of the condition, having the specified operator, formula restrictions and background.
- ExcelConditionalFormatting - Class in EasyXLS
-
This class stores the conditional formatting information like cells range and conditions.
- ExcelConditionalFormatting() - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting.
- ExcelConditionalFormatting(int, int, int, int, List) - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting having the specified range.
- ExcelConditionalFormatting(String, int, String, String) - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting having the specified position, operator and formula restrictions.
- ExcelConditionalFormatting(String, int, String, String, bool, bool, Color) - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting having the specified position, operator, formula restrictions and font settings.
- ExcelConditionalFormatting(String, int, String, String, bool, bool, Color, Color) - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting having the specified position, operator, formula restrictions, font settings and background.
- ExcelConditionalFormatting(String, int, String, String, Color) - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting having the specified position, operator, formula restrictions and background.
- ExcelConditionalFormatting(String, List) - Constructor for class EasyXLS.ExcelConditionalFormatting
-
Defines an instance of the conditional formatting on the specified range.
- ExcelDataGroup - Class in EasyXLS
-
This class allows to group and outline the cell ranges.
- ExcelDataGroup() - Constructor for class EasyXLS.ExcelDataGroup
-
Defines an instance of a data group.
- ExcelDataGroup(int, int, int, int, int, bool) - Constructor for class EasyXLS.ExcelDataGroup
-
Defines an instance of a data group having the specified position, group per rows or columns and collapse options.
- ExcelDataGroup(int, int, int, int, int, bool, ExcelAutoFormat) - Constructor for class EasyXLS.ExcelDataGroup
-
Defines an instance of a data group having the specified position, group per rows or columns and collapse options.
- ExcelDataGroup(String, int, bool) - Constructor for class EasyXLS.ExcelDataGroup
-
Defines an instance of a data group having the specified position, group per rows or columns and collapse options.
- ExcelDataGroup(String, int, bool, ExcelAutoFormat) - Constructor for class EasyXLS.ExcelDataGroup
-
Defines an instance of a data group having the specified position, group per rows or columns and collapse options.
- ExcelDataLabels - Class in EasyXLS.Charts
-
This class stores the data labels settings like label options, number format, fill settings, line settings, (font settings), 3D-format settings, alignment settings and shadow settings.
- ExcelDataLabels() - Constructor for class EasyXLS.Charts.ExcelDataLabels
-
Defines an instance of the data label.
- ExcelDataTable - Class in EasyXLS.Charts
-
This class stores the data table information like line settings, fill settings, font settings, shadow settings, legend key visibility, horizontal lines visibility, vertical lines visibility, outlines visibility, visibility.
- ExcelDataTable() - Constructor for class EasyXLS.Charts.ExcelDataTable
-
Defines an instance of the excel data table.
- ExcelDataValidator - Class in EasyXLS
-
This class restricts the cell entries to a specific data type (integers, decimal numbers, or text) and sets limits on the valid entries.
- ExcelDataValidator() - Constructor for class EasyXLS.ExcelDataValidator
-
Defines an instance of the validator.
- ExcelDataValidator(int, int, int, int, int, int, String, String) - Constructor for class EasyXLS.ExcelDataValidator
-
Defines an instance of the validator having the specified position, validation type, operator and formula restrictions.
- ExcelDataValidator(String, int, int, String, String) - Constructor for class EasyXLS.ExcelDataValidator
-
Defines an instance of the validator having the specified position, validation type, operator and formula restrictions.
- ExcelDocument - Class in EasyXLS
-
The
ExcelDocument
class is the main class that contains methods to generate or read a Microsoft Excel file. - ExcelDocument() - Constructor for class EasyXLS.ExcelDocument
-
Defines an instance of the object that reads/writes Excel files.
- ExcelDocument(int) - Constructor for class EasyXLS.ExcelDocument
-
Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets.
- ExcelDocument(int, int) - Constructor for class EasyXLS.ExcelDocument
-
Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets and chart sheets.
- ExcelEffectScheme - Class in EasyXLS.Themes
-
This class stores the effects information for a theme.
- ExcelEffectScheme() - Constructor for class EasyXLS.Themes.ExcelEffectScheme
-
Defines an effect scheme that is initialized with the office built-in theme effects.
- ExcelEffectScheme(String) - Constructor for class EasyXLS.Themes.ExcelEffectScheme
-
Defines an effect scheme that is initialized with the specified built-in theme effects.
- ExcelField - Class in EasyXLS.PivotTables
-
This class stores pivot table field information like name, area location, subtotals & filters options, layout & print options and sort order.
- ExcelField() - Constructor for class EasyXLS.PivotTables.ExcelField
-
Defines an instance of the pivot table field.
- ExcelFilter - Class in EasyXLS
-
This class stores the auto-filter and advanced filter information.
- ExcelFontScheme - Class in EasyXLS.Themes
-
This class stores the font information for a theme.
- ExcelFontScheme() - Constructor for class EasyXLS.Themes.ExcelFontScheme
-
Defines a font scheme that is initialized with the built-in Office fonts.
- ExcelFontScheme(String) - Constructor for class EasyXLS.Themes.ExcelFontScheme
-
Defines a font scheme that is initialized with the specified built-in theme fonts.
- ExcelFooter - Class in EasyXLS
-
This class stores the footer information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.
- ExcelFooter() - Constructor for class EasyXLS.ExcelFooter
-
Defines an instance of the footer.
- ExcelFooter(String, String) - Constructor for class EasyXLS.ExcelFooter
-
Defines an instance of the footer having the specified text and position.
- ExcelFooter(String, String, String, int, bool, bool) - Constructor for class EasyXLS.ExcelFooter
-
Defines an instance of the footer having the specified text, position and font settings.
- ExcelHeader - Class in EasyXLS
-
This class stores the header information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.
- ExcelHeader() - Constructor for class EasyXLS.ExcelHeader
-
Defines an instance of the header.
- ExcelHeader(String, String) - Constructor for class EasyXLS.ExcelHeader
-
Defines an instance of the header having the specified text and position.
- ExcelHeader(String, String, String, int, bool, bool) - Constructor for class EasyXLS.ExcelHeader
-
Defines an instance of the header having the specified text, position and font settings.
- ExcelHyperlink - Class in EasyXLS
-
This class stores the hyperlink information like position (first row, first column, last row, last column), hyperlink type, description, URL, target frame, text mark and tool tip.
- ExcelHyperlink() - Constructor for class EasyXLS.ExcelHyperlink
-
Defines an instance of the Excel hyperlink.
- ExcelHyperlink(String, String, String) - Constructor for class EasyXLS.ExcelHyperlink
-
Defines an instance of the Excel hyperlink with the specified type, url and position.
- ExcelHyperlink(String, String, String, String) - Constructor for class EasyXLS.ExcelHyperlink
-
Defines an instance of the Excel hyperlink with the specified type, url, tooltip and position.
- ExcelImage - Class in EasyXLS.Drawings
-
This class stores image information like image path and position in worksheet.
- ExcelImage() - Constructor for class EasyXLS.Drawings.ExcelImage
-
Defines an instance of the image.
- ExcelImage(String) - Constructor for class EasyXLS.Drawings.ExcelImage
-
Defines an instance of the image having the specified path.
- ExcelImage(String, int, int) - Constructor for class EasyXLS.Drawings.ExcelImage
-
Defines an instance of the image having the specified path and location
This constructor is applicable only to adding images to ExcelWorksheet objects
- ExcelImage(String, int, int, int, int) - Constructor for class EasyXLS.Drawings.ExcelImage
-
Defines an instance of the image having the specified path, location and size
This constructor is applicable only to adding images to ExcelWorksheet objects
- ExcelImage(String, String) - Constructor for class EasyXLS.Drawings.ExcelImage
-
Defines an instance of the image having the specified path and location
This constructor is applicable only to adding images to ExcelWorksheet objects
- ExcelImage(String, String, int, int) - Constructor for class EasyXLS.Drawings.ExcelImage
-
Defines an instance of the image having the specified path, location and size
This constructor is applicable only to adding images to ExcelWorksheet objects
- ExcelName - Class in EasyXLS
-
This class stores names with its information like title and formula.
- ExcelName() - Constructor for class EasyXLS.ExcelName
-
Defines an instance of a name.
- ExcelName(String, String) - Constructor for class EasyXLS.ExcelName
-
Defines an instance of a name with the specified title and formula.
- ExcelOptions - Class in EasyXLS
-
This class stores some of the options of an Excel document, available in the main menu Tools/Options window.
- ExcelOptions() - Constructor for class EasyXLS.ExcelOptions
-
Defines an instance of the ExcelOption class.
- ExcelPageSetup - Class in EasyXLS
-
This class stores page setup settings like print area, the rows to be repeated at top, columns to be repeated at left, page orientation (portrait, landscape), paper size, scaling factor, fit to pages width/height, paper margins, print order, horizontal and vertical page breaks and other customizations like: print gridlines, print black and white, print draft quality, print row and column headings, print comments.
- ExcelPivotChart - Class in EasyXLS.PivotTables
-
This class stores pivot chart information like pivot table source and chart information.
- ExcelPivotChart() - Constructor for class EasyXLS.PivotTables.ExcelPivotChart
-
Defines an instance of the pivot chart.
- ExcelPivotTable - Class in EasyXLS.PivotTables
-
This class stores pivot table information like name, location, data source, layout & format options, totals & filters, display, printing and data options.
- ExcelPivotTable() - Constructor for class EasyXLS.PivotTables.ExcelPivotTable
-
Defines an instance of the pivot table.
- ExcelPlotArea - Class in EasyXLS.Charts
-
This class stores the plot area information like fill settings, line settings and shadow settings.
- ExcelPlotArea() - Constructor for class EasyXLS.Charts.ExcelPlotArea
-
Defines an instance of the excel plot area.
- ExcelRow - Class in EasyXLS
-
This class is a collection of cells.
- ExcelRow() - Constructor for class EasyXLS.ExcelRow
-
Defines an instance of the row.
- ExcelSeries - Class in EasyXLS.Charts
-
This class stores the series information like values, name, fill settings, line settings, shadow settings, data labels type, legend key visibility next to label, marker type.
- ExcelSeries() - Constructor for class EasyXLS.Charts.ExcelSeries
-
Defines an instance of the excel series.
- ExcelSeries(String, String) - Constructor for class EasyXLS.Charts.ExcelSeries
-
Defines an instance of the excel series that has the name and the values defined.
- ExcelSheet - Class in EasyXLS
-
This class simulates a sheet.
- ExcelSheet() - Constructor for class EasyXLS.ExcelSheet
-
Defines an instance of the sheet.
- ExcelStyle - Class in EasyXLS
-
This class stores the style information like font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, cell locked or hidden, shrink, border type, border color.
- ExcelStyle() - Constructor for class EasyXLS.ExcelStyle
-
Defines an instance of the style.
- ExcelStyle(Color) - Constructor for class EasyXLS.ExcelStyle
-
Defines an instance of the style that is initialized with background color.
- ExcelStyle(String, int, bool, bool, Color) - Constructor for class EasyXLS.ExcelStyle
-
Defines an instance of the style that is initialized with font settings.
- ExcelStyle(String, int, bool, bool, Color, Color) - Constructor for class EasyXLS.ExcelStyle
-
Defines an instance of the style that is initialized with font and background settings.
- ExcelTable - Class in EasyXLS
-
This class simulates a worksheet table.
- ExcelTable() - Constructor for class EasyXLS.ExcelTable
-
Defines an instance of the worksheet table.
- ExcelTheme - Class in EasyXLS.Themes
-
This class stores the theme information like theme colors, theme fonts and theme effects.
- ExcelTheme() - Constructor for class EasyXLS.Themes.ExcelTheme
-
Defines a theme that is initialized with the default Office theme schemes: colors, fonts and effects.
- ExcelTheme(String) - Constructor for class EasyXLS.Themes.ExcelTheme
-
Defines a theme that is one of the built-in themes.
- ExcelTitle - Class in EasyXLS.Charts
-
This class stores the titles information like text, fill settings, line settings, font settings, alignment settings and shadow settings.
- ExcelTitle() - Constructor for class EasyXLS.Charts.ExcelTitle
-
Defines an instance of a title.
- ExcelValueField - Class in EasyXLS.PivotTables
-
This class stores pivot table value field information like name, basic field, subtotal and number format.
- ExcelValueField() - Constructor for class EasyXLS.PivotTables.ExcelValueField
-
Defines an instance of the pivot table value field.
- ExcelWorksheet - Class in EasyXLS
-
This class simulates a worksheet.
- ExcelWorksheet() - Constructor for class EasyXLS.ExcelWorksheet
-
Defines an instance of the worksheet.
- ExcelWorksheet(String) - Constructor for class EasyXLS.ExcelWorksheet
-
Defines an instance of the worksheet that has the worksheet name defined.
- ExternalLinks - Class in EasyXLS
-
This class contains the external links from the formulas inside the document.
- ExternalLinks() - Constructor for class EasyXLS.ExternalLinks
All Classes|All Namespaces|Constant Field Values|Deprecated API
ExcelChart.getChartTitle()