Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface ICells

com.aspose.cells.Cells

Hierarchy 层级

Index 目录

Methods 方法

Methods 方法

addRange

  • addRange(rangeObject: IRange): void

  • void addRange(com.aspose.cells.Range)

    Parameters 参数

    Returns 返回值 void

applyColumnStyle

  • void applyColumnStyle(int, com.aspose.cells.Style, com.aspose.cells.StyleFlag)

    Parameters 参数

    Returns 返回值 void

applyRowStyle

  • void applyRowStyle(int, com.aspose.cells.Style, com.aspose.cells.StyleFlag)

    Parameters 参数

    Returns 返回值 void

applyStyle

  • void applyStyle(com.aspose.cells.Style, com.aspose.cells.StyleFlag)

    Parameters 参数

    Returns 返回值 void

checkCell

  • checkCell(row: number, column: number): ICell

  • com.aspose.cells.Cell checkCell(int, int)

    Parameters 参数

    • row: number
    • column: number

    Returns 返回值 ICell

checkColumn

  • checkColumn(columnIndex: number): IColumn

  • com.aspose.cells.Column checkColumn(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 IColumn

checkRow

  • checkRow(row: number): IRow

  • com.aspose.cells.Row checkRow(int)

    Parameters 参数

    • row: number

    Returns 返回值 IRow

clear

  • clear(): void

  • void clear()

    Returns 返回值 void

clearContents

  • clearContents(startRow: number, startColumn: number, endRow: number, endColumn: number): void
  • clearContents(range: ICellArea): void

  • void clearContents(int, int, int, int)

    Parameters 参数

    • startRow: number
    • startColumn: number
    • endRow: number
    • endColumn: number

    Returns 返回值 void

  • void clearContents(com.aspose.cells.CellArea)

    Parameters 参数

    Returns 返回值 void

clearFormats

  • clearFormats(startRow: number, startColumn: number, endRow: number, endColumn: number): void
  • clearFormats(range: ICellArea): void

  • void clearFormats(int, int, int, int)

    Parameters 参数

    • startRow: number
    • startColumn: number
    • endRow: number
    • endColumn: number

    Returns 返回值 void

  • void clearFormats(com.aspose.cells.CellArea)

    Parameters 参数

    Returns 返回值 void

clearRange

  • clearRange(range: ICellArea): void
  • clearRange(startRow: number, startColumn: number, endRow: number, endColumn: number): void

  • void clearRange(com.aspose.cells.CellArea)

    Parameters 参数

    Returns 返回值 void

  • void clearRange(int, int, int, int)

    Parameters 参数

    • startRow: number
    • startColumn: number
    • endRow: number
    • endColumn: number

    Returns 返回值 void

convertStringToNumericValue

  • convertStringToNumericValue(): void

  • void convertStringToNumericValue()

    Returns 返回值 void

copyColumn

  • copyColumn(sourceCells: ICells, sourceColumnIndex: number, destinationColumnIndex: number): void

  • void copyColumn(com.aspose.cells.Cells, int, int)

    Parameters 参数

    • sourceCells: ICells
    • sourceColumnIndex: number
    • destinationColumnIndex: number

    Returns 返回值 void

copyColumns

  • copyColumns(sourceCells0: ICells, sourceColumnIndex: number, destinationColumnIndex: number, columnNumber: number, pasteOptions: IPasteOptions): void
  • copyColumns(sourceCells0: ICells, sourceColumnIndex: number, destinationColumnIndex: number, columnNumber: number): void
  • copyColumns(sourceCells: ICells, sourceColumnIndex: number, sourceTotalColumns: number, destinationColumnIndex: number, destinationTotalColumns: number): void

  • void copyColumns(com.aspose.cells.Cells, int, int, int, com.aspose.cells.PasteOptions)

    Parameters 参数

    • sourceCells0: ICells
    • sourceColumnIndex: number
    • destinationColumnIndex: number
    • columnNumber: number
    • pasteOptions: IPasteOptions

    Returns 返回值 void

  • void copyColumns(com.aspose.cells.Cells, int, int, int)

    Parameters 参数

    • sourceCells0: ICells
    • sourceColumnIndex: number
    • destinationColumnIndex: number
    • columnNumber: number

    Returns 返回值 void

  • void copyColumns(com.aspose.cells.Cells, int, int, int, int)

    Parameters 参数

    • sourceCells: ICells
    • sourceColumnIndex: number
    • sourceTotalColumns: number
    • destinationColumnIndex: number
    • destinationTotalColumns: number

    Returns 返回值 void

copyRow

  • copyRow(sourceCells: ICells, sourceRowIndex: number, destinationRowIndex: number): void

  • void copyRow(com.aspose.cells.Cells, int, int)

    Parameters 参数

    • sourceCells: ICells
    • sourceRowIndex: number
    • destinationRowIndex: number

    Returns 返回值 void

copyRows

  • copyRows(sourceCells: ICells, sourceRowIndex: number, destinationRowIndex: number, rowNumber: number): void
  • copyRows(sourceCells0: ICells, sourceRowIndex: number, destinationRowIndex: number, rowNumber: number, copyOptions: ICopyOptions, pasteOptions: IPasteOptions): void
  • copyRows(sourceCells0: ICells, sourceRowIndex: number, destinationRowIndex: number, rowNumber: number, copyOptions: ICopyOptions): void

  • void copyRows(com.aspose.cells.Cells, int, int, int)

    Parameters 参数

    • sourceCells: ICells
    • sourceRowIndex: number
    • destinationRowIndex: number
    • rowNumber: number

    Returns 返回值 void

  • void copyRows(com.aspose.cells.Cells, int, int, int, com.aspose.cells.CopyOptions, com.aspose.cells.PasteOptions)

    Parameters 参数

    Returns 返回值 void

  • void copyRows(com.aspose.cells.Cells, int, int, int, com.aspose.cells.CopyOptions)

    Parameters 参数

    • sourceCells0: ICells
    • sourceRowIndex: number
    • destinationRowIndex: number
    • rowNumber: number
    • copyOptions: ICopyOptions

    Returns 返回值 void

createRange

  • createRange(upperLeftCell: string, lowerRightCell: string): IRange
  • createRange(firstIndex: number, number: number, isVertical: boolean): IRange
  • createRange(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number): IRange
  • createRange(address: string): IRange

  • com.aspose.cells.Range createRange(java.lang.String, java.lang.String)

    Parameters 参数

    • upperLeftCell: string
    • lowerRightCell: string

    Returns 返回值 IRange

  • com.aspose.cells.Range createRange(int, int, boolean)

    Parameters 参数

    • firstIndex: number
    • number: number
    • isVertical: boolean

    Returns 返回值 IRange

  • com.aspose.cells.Range createRange(int, int, int, int)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number

    Returns 返回值 IRange

  • com.aspose.cells.Range createRange(java.lang.String)

    Parameters 参数

    • address: string

    Returns 返回值 IRange

deleteBlankColumns

  • deleteBlankColumns(): void
  • deleteBlankColumns(options: IDeleteOptions): void

  • void deleteBlankColumns()

    Returns 返回值 void

  • void deleteBlankColumns(com.aspose.cells.DeleteOptions)

    Parameters 参数

    Returns 返回值 void

deleteBlankRows

  • deleteBlankRows(options: IDeleteOptions): void
  • deleteBlankRows(): void

  • void deleteBlankRows(com.aspose.cells.DeleteOptions)

    Parameters 参数

    Returns 返回值 void

  • void deleteBlankRows()

    Returns 返回值 void

deleteColumn

  • deleteColumn(columnIndex: number, updateReference: boolean): void
  • deleteColumn(columnIndex: number): void

  • void deleteColumn(int, boolean)

    Parameters 参数

    • columnIndex: number
    • updateReference: boolean

    Returns 返回值 void

  • void deleteColumn(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 void

deleteColumns

  • deleteColumns(columnIndex: number, totalColumns: number, updateReference: boolean): void

  • void deleteColumns(int, int, boolean)

    Parameters 参数

    • columnIndex: number
    • totalColumns: number
    • updateReference: boolean

    Returns 返回值 void

deleteRange

  • deleteRange(startRow: number, startColumn: number, endRow: number, endColumn: number, shiftType: number): void

  • void deleteRange(int, int, int, int, int)

    Parameters 参数

    • startRow: number
    • startColumn: number
    • endRow: number
    • endColumn: number
    • shiftType: number

    Returns 返回值 void

deleteRow

  • deleteRow(rowIndex: number): void

  • void deleteRow(int)

    Parameters 参数

    • rowIndex: number

    Returns 返回值 void

deleteRows

  • deleteRows(rowIndex: number, totalRows: number): boolean
  • deleteRows(rowIndex: number, totalRows: number, updateReference: boolean): boolean

  • boolean deleteRows(int, int)

    Parameters 参数

    • rowIndex: number
    • totalRows: number

    Returns 返回值 boolean

  • boolean deleteRows(int, int, boolean)

    Parameters 参数

    • rowIndex: number
    • totalRows: number
    • updateReference: boolean

    Returns 返回值 boolean

dispose

  • dispose(): void

  • void dispose()

    Returns 返回值 void

endCellInColumn

  • endCellInColumn(startRow: number, endRow: number, startColumn: number, endColumn: number): ICell
  • endCellInColumn(columnIndex: number): ICell

  • com.aspose.cells.Cell endCellInColumn(int, int, short, short)

    Parameters 参数

    • startRow: number
    • endRow: number
    • startColumn: number
    • endColumn: number

    Returns 返回值 ICell

  • com.aspose.cells.Cell endCellInColumn(short)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 ICell

endCellInRow

  • endCellInRow(startRow: number, endRow: number, startColumn: number, endColumn: number): ICell
  • endCellInRow(rowIndex: number): ICell

  • com.aspose.cells.Cell endCellInRow(int, int, int, int)

    Parameters 参数

    • startRow: number
    • endRow: number
    • startColumn: number
    • endColumn: number

    Returns 返回值 ICell

  • com.aspose.cells.Cell endCellInRow(int)

    Parameters 参数

    • rowIndex: number

    Returns 返回值 ICell

exportArray

  • exportArray(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number): any[][]

  • java.lang.Object[][] exportArray(int, int, int, int)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number

    Returns 返回值 any[][]

exportTypeArray

  • exportTypeArray(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number): number[][]

  • int[][] exportTypeArray(int, int, int, int)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number

    Returns 返回值 number[][]

find

  • com.aspose.cells.Cell find(java.lang.Object, com.aspose.cells.Cell)

    Parameters 参数

    • what: any
    • previousCell: ICell

    Returns 返回值 ICell

  • com.aspose.cells.Cell find(java.lang.Object, com.aspose.cells.Cell, com.aspose.cells.FindOptions)

    Parameters 参数

    Returns 返回值 ICell

findFormula

  • findFormula(formula: string, previousCell: ICell): ICell

  • com.aspose.cells.Cell findFormula(java.lang.String, com.aspose.cells.Cell)

    Parameters 参数

    • formula: string
    • previousCell: ICell

    Returns 返回值 ICell

findFormulaContains

  • findFormulaContains(formula: string, previousCell: ICell): ICell

  • com.aspose.cells.Cell findFormulaContains(java.lang.String, com.aspose.cells.Cell)

    Parameters 参数

    • formula: string
    • previousCell: ICell

    Returns 返回值 ICell

get

  • get(cellName: string): ICell
  • get(index: number): ICell
  • get(row: number, column: number): ICell

  • com.aspose.cells.Cell get(java.lang.String)

    Parameters 参数

    • cellName: string

    Returns 返回值 ICell

  • com.aspose.cells.Cell get(int)

    Parameters 参数

    • index: number

    Returns 返回值 ICell

  • com.aspose.cells.Cell get(int, int)

    Parameters 参数

    • row: number
    • column: number

    Returns 返回值 ICell

getCell

  • getCell(row: number, column: number): ICell

  • com.aspose.cells.Cell getCell(int, int)

    Parameters 参数

    • row: number
    • column: number

    Returns 返回值 ICell

getCellStyle

  • getCellStyle(row: number, column: number): IStyle

  • com.aspose.cells.Style getCellStyle(int, int)

    Parameters 参数

    • row: number
    • column: number

    Returns 返回值 IStyle

getColumn

  • getColumn(columnIndex: number): IColumn

  • com.aspose.cells.Column getColumn(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 IColumn

getColumnWidth

  • getColumnWidth(column: number): number

  • double getColumnWidth(int)

    Parameters 参数

    • column: number

    Returns 返回值 number

getColumnWidthInch

  • getColumnWidthInch(column: number): number

  • double getColumnWidthInch(int)

    Parameters 参数

    • column: number

    Returns 返回值 number

getColumnWidthPixel

  • getColumnWidthPixel(column: number): number

  • int getColumnWidthPixel(int)

    Parameters 参数

    • column: number

    Returns 返回值 number

getColumns

getCount

  • getCount(): number

  • int getCount()

    Returns 返回值 number

getCountLarge

  • getCountLarge(): number

  • long getCountLarge()

    Returns 返回值 number

getDependents

  • getDependents(isAll: boolean, row: number, column: number): ICell[]

  • com.aspose.cells.Cell[] getDependents(boolean, int, int)

    Parameters 参数

    • isAll: boolean
    • row: number
    • column: number

    Returns 返回值 ICell[]

getFirstCell

  • com.aspose.cells.Cell getFirstCell()

    Returns 返回值 ICell

getGroupedColumnOutlineLevel

  • getGroupedColumnOutlineLevel(columnIndex: number): number

  • int getGroupedColumnOutlineLevel(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 number

getGroupedRowOutlineLevel

  • getGroupedRowOutlineLevel(rowIndex: number): number

  • int getGroupedRowOutlineLevel(int)

    Parameters 参数

    • rowIndex: number

    Returns 返回值 number

getLastCell

  • com.aspose.cells.Cell getLastCell()

    Returns 返回值 ICell

getLastDataRow

  • getLastDataRow(column: number): number

  • int getLastDataRow(int)

    Parameters 参数

    • column: number

    Returns 返回值 number

getMaxColumn

  • getMaxColumn(): number

  • int getMaxColumn()

    Returns 返回值 number

getMaxDataColumn

  • getMaxDataColumn(): number

  • int getMaxDataColumn()

    Returns 返回值 number

getMaxDataRow

  • getMaxDataRow(): number

  • int getMaxDataRow()

    Returns 返回值 number

getMaxDisplayRange

  • getMaxDisplayRange(): IRange

  • com.aspose.cells.Range getMaxDisplayRange()

    Returns 返回值 IRange

getMaxGroupedColumnOutlineLevel

  • getMaxGroupedColumnOutlineLevel(): number

  • int getMaxGroupedColumnOutlineLevel()

    Returns 返回值 number

getMaxGroupedRowOutlineLevel

  • getMaxGroupedRowOutlineLevel(): number

  • int getMaxGroupedRowOutlineLevel()

    Returns 返回值 number

getMaxRow

  • getMaxRow(): number

  • int getMaxRow()

    Returns 返回值 number

getMemorySetting

  • getMemorySetting(): number

  • int getMemorySetting()

    Returns 返回值 number

getMergedCells

  • getMergedCells(): object[]

  • java.util.ArrayList getMergedCells()

    Returns 返回值 object[]

getMinColumn

  • getMinColumn(): number

  • int getMinColumn()

    Returns 返回值 number

getMinDataColumn

  • getMinDataColumn(): number

  • int getMinDataColumn()

    Returns 返回值 number

getMinDataRow

  • getMinDataRow(): number

  • int getMinDataRow()

    Returns 返回值 number

getMinRow

  • getMinRow(): number

  • int getMinRow()

    Returns 返回值 number

getMultiThreadReading

  • getMultiThreadReading(): boolean

  • boolean getMultiThreadReading()

    Returns 返回值 boolean

getOdsCellFields

getPreserveString

  • getPreserveString(): boolean

  • boolean getPreserveString()

    Returns 返回值 boolean

getRanges

  • com.aspose.cells.RangeCollection getRanges()

    Returns 返回值 IRangeCollection

getRow

  • getRow(row: number): IRow

  • com.aspose.cells.Row getRow(int)

    Parameters 参数

    • row: number

    Returns 返回值 IRow

getRowEnumerator

  • getRowEnumerator(): any

  • java.util.Iterator getRowEnumerator()

    Returns 返回值 any

getRowHeight

  • getRowHeight(row: number): number

  • double getRowHeight(int)

    Parameters 参数

    • row: number

    Returns 返回值 number

getRowHeightInch

  • getRowHeightInch(row: number): number

  • double getRowHeightInch(int)

    Parameters 参数

    • row: number

    Returns 返回值 number

getRowHeightPixel

  • getRowHeightPixel(row: number): number

  • int getRowHeightPixel(int)

    Parameters 参数

    • row: number

    Returns 返回值 number

getRows

  • com.aspose.cells.RowCollection getRows()

    Returns 返回值 IRowCollection

getStandardHeight

  • getStandardHeight(): number

  • double getStandardHeight()

    Returns 返回值 number

getStandardHeightPixels

  • getStandardHeightPixels(): number

  • int getStandardHeightPixels()

    Returns 返回值 number

getStandardWidth

  • getStandardWidth(): number

  • double getStandardWidth()

    Returns 返回值 number

getStandardWidthInch

  • getStandardWidthInch(): number

  • double getStandardWidthInch()

    Returns 返回值 number

getStandardWidthPixels

  • getStandardWidthPixels(): number

  • int getStandardWidthPixels()

    Returns 返回值 number

getStyle

  • com.aspose.cells.Style getStyle()

    Returns 返回值 IStyle

getViewColumnWidthPixel

  • getViewColumnWidthPixel(column: number): number

  • int getViewColumnWidthPixel(int)

    Parameters 参数

    • column: number

    Returns 返回值 number

getViewRowHeight

  • getViewRowHeight(row: number): number

  • double getViewRowHeight(int)

    Parameters 参数

    • row: number

    Returns 返回值 number

getViewRowHeightInch

  • getViewRowHeightInch(row: number): number

  • double getViewRowHeightInch(int)

    Parameters 参数

    • row: number

    Returns 返回值 number

groupColumns

  • groupColumns(firstIndex: number, lastIndex: number): void
  • groupColumns(firstIndex: number, lastIndex: number, isHidden: boolean): void

  • void groupColumns(int, int)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number

    Returns 返回值 void

  • void groupColumns(int, int, boolean)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number
    • isHidden: boolean

    Returns 返回值 void

groupRows

  • groupRows(firstIndex: number, lastIndex: number, isHidden: boolean): void
  • groupRows(firstIndex: number, lastIndex: number): void

  • void groupRows(int, int, boolean)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number
    • isHidden: boolean

    Returns 返回值 void

  • void groupRows(int, int)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number

    Returns 返回值 void

hideColumn

  • hideColumn(column: number): void

  • void hideColumn(int)

    Parameters 参数

    • column: number

    Returns 返回值 void

hideColumns

  • hideColumns(column: number, totalColumns: number): void

  • void hideColumns(int, int)

    Parameters 参数

    • column: number
    • totalColumns: number

    Returns 返回值 void

hideGroupDetail

  • hideGroupDetail(isVertical: boolean, index: number): void

  • void hideGroupDetail(boolean, int)

    Parameters 参数

    • isVertical: boolean
    • index: number

    Returns 返回值 void

hideRow

  • hideRow(row: number): void

  • void hideRow(int)

    Parameters 参数

    • row: number

    Returns 返回值 void

hideRows

  • hideRows(row: number, totalRows: number): void

  • void hideRows(int, int)

    Parameters 参数

    • row: number
    • totalRows: number

    Returns 返回值 void

importArray

  • importArray(stringArray: string[], firstRow: number, firstColumn: number, isVertical: boolean): void
  • importArray(stringArray: string[][], firstRow: number, firstColumn: number): void
  • importArray(doubleArray: number[][], firstRow: number, firstColumn: number): void
  • importArray(intArray: number[], firstRow: number, firstColumn: number, isVertical: boolean): void
  • importArray(doubleArray: number[], firstRow: number, firstColumn: number, isVertical: boolean): void
  • importArray(intArray: number[][], firstRow: number, firstColumn: number): void

  • void importArray(java.lang.String[], int, int, boolean)

    Parameters 参数

    • stringArray: string[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean

    Returns 返回值 void

  • void importArray(java.lang.String[][], int, int)

    Parameters 参数

    • stringArray: string[][]
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

  • void importArray(double[][], int, int)

    Parameters 参数

    • doubleArray: number[][]
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

  • void importArray(int[], int, int, boolean)

    Parameters 参数

    • intArray: number[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean

    Returns 返回值 void

  • void importArray(double[], int, int, boolean)

    Parameters 参数

    • doubleArray: number[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean

    Returns 返回值 void

  • void importArray(int[][], int, int)

    Parameters 参数

    • intArray: number[][]
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

importArrayList

  • importArrayList(arrayList: object[], firstRow: number, firstColumn: number, isVertical: boolean): void

  • void importArrayList(java.util.ArrayList, int, int, boolean)

    Parameters 参数

    • arrayList: object[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean

    Returns 返回值 void

importCSV

  • importCSV(fileName: string, splitter: string, convertNumericData: boolean, firstRow: number, firstColumn: number): void
  • importCSV(fileName: string, options: ITxtLoadOptions, firstRow: number, firstColumn: number): void
  • importCSV(stream: any, options: ITxtLoadOptions, firstRow: number, firstColumn: number): void
  • importCSV(stream: any, splitter: string, convertNumericData: boolean, firstRow: number, firstColumn: number): void

  • void importCSV(java.lang.String, java.lang.String, boolean, int, int)

    Parameters 参数

    • fileName: string
    • splitter: string
    • convertNumericData: boolean
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

  • void importCSV(java.lang.String, com.aspose.cells.TxtLoadOptions, int, int)

    Parameters 参数

    • fileName: string
    • options: ITxtLoadOptions
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

  • void importCSV(java.io.InputStream, com.aspose.cells.TxtLoadOptions, int, int)

    Parameters 参数

    • stream: any
    • options: ITxtLoadOptions
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

  • void importCSV(java.io.InputStream, java.lang.String, boolean, int, int)

    Parameters 参数

    • stream: any
    • splitter: string
    • convertNumericData: boolean
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

importCustomObjects

  • importCustomObjects(list: object[], firstRow: number, firstColumn: number, options: IImportTableOptions): number
  • importCustomObjects(list: object[], propertyNames: string[], isPropertyNameShown: boolean, firstRow: number, firstColumn: number, rowNumber: number, insertRows: boolean, dateFormatString: string, convertStringToNumber: boolean): number

  • int importCustomObjects(java.util.Collection, int, int, com.aspose.cells.ImportTableOptions)

    Parameters 参数

    Returns 返回值 number

  • int importCustomObjects(java.util.Collection, java.lang.String[], boolean, int, int, int, boolean, java.lang.String, boolean)

    Parameters 参数

    • list: object[]
    • propertyNames: string[]
    • isPropertyNameShown: boolean
    • firstRow: number
    • firstColumn: number
    • rowNumber: number
    • insertRows: boolean
    • dateFormatString: string
    • convertStringToNumber: boolean

    Returns 返回值 number

importData

  • int importData(com.aspose.cells.ICellsDataTable, int, int, com.aspose.cells.ImportTableOptions)

    Parameters 参数

    Returns 返回值 number

importFormulaArray

  • importFormulaArray(stringArray: string[], firstRow: number, firstColumn: number, isVertical: boolean): void

  • void importFormulaArray(java.lang.String[], int, int, boolean)

    Parameters 参数

    • stringArray: string[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean

    Returns 返回值 void

importObjectArray

  • importObjectArray(objArray: any[], firstRow: number, firstColumn: number, isVertical: boolean): void
  • importObjectArray(objArray: any[], firstRow: number, firstColumn: number, isVertical: boolean, skip: number): void

  • void importObjectArray(java.lang.Object[], int, int, boolean)

    Parameters 参数

    • objArray: any[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean

    Returns 返回值 void

  • void importObjectArray(java.lang.Object[], int, int, boolean, int)

    Parameters 参数

    • objArray: any[]
    • firstRow: number
    • firstColumn: number
    • isVertical: boolean
    • skip: number

    Returns 返回值 void

importResultSet

  • importResultSet(rs: any, rowIndex: number, columnIndex: number, options: IImportTableOptions): number
  • importResultSet(rs: any, rowIndex: number, columnIndex: number, rowNum: number, columnNum: number, isFieldNameShown: boolean, customDateFormatString: string, convertStringToNumber: boolean): number
  • importResultSet(rs: any, startCell: string, options: IImportTableOptions): number
  • importResultSet(rs: any, startCell: string, rowNum: number, columnNum: number, isFieldNameShown: boolean): number
  • importResultSet(rs: any, rowIndex: number, columnIndex: number, isFieldNameShown: boolean): number
  • importResultSet(rs: any, rowIndex: number, columnIndex: number, rowNum: number, columnNum: number, isFieldNameShown: boolean): number
  • importResultSet(rs: any, startCell: string, isFieldNameShown: boolean): number
  • importResultSet(rs: any, rowIndex: number, columnIndex: number, isFieldNameShown: boolean, customDateFormatString: string, convertStringToNumber: boolean): number

  • int importResultSet(java.sql.ResultSet, int, int, com.aspose.cells.ImportTableOptions)

    Parameters 参数

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, int, int, int, int, boolean, java.lang.String, boolean)

    Parameters 参数

    • rs: any
    • rowIndex: number
    • columnIndex: number
    • rowNum: number
    • columnNum: number
    • isFieldNameShown: boolean
    • customDateFormatString: string
    • convertStringToNumber: boolean

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, java.lang.String, com.aspose.cells.ImportTableOptions)

    Parameters 参数

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, java.lang.String, int, int, boolean)

    Parameters 参数

    • rs: any
    • startCell: string
    • rowNum: number
    • columnNum: number
    • isFieldNameShown: boolean

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, int, int, boolean)

    Parameters 参数

    • rs: any
    • rowIndex: number
    • columnIndex: number
    • isFieldNameShown: boolean

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, int, int, int, int, boolean)

    Parameters 参数

    • rs: any
    • rowIndex: number
    • columnIndex: number
    • rowNum: number
    • columnNum: number
    • isFieldNameShown: boolean

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, java.lang.String, boolean)

    Parameters 参数

    • rs: any
    • startCell: string
    • isFieldNameShown: boolean

    Returns 返回值 number

  • int importResultSet(java.sql.ResultSet, int, int, boolean, java.lang.String, boolean)

    Parameters 参数

    • rs: any
    • rowIndex: number
    • columnIndex: number
    • isFieldNameShown: boolean
    • customDateFormatString: string
    • convertStringToNumber: boolean

    Returns 返回值 number

importTwoDimensionArray

  • importTwoDimensionArray(objArray: any[][], firstRow: number, firstColumn: number): void
  • importTwoDimensionArray(objArray: any[][], firstRow: number, firstColumn: number, convertStringToNumber: boolean): void
  • importTwoDimensionArray(objArray: any[][], styles: any[][], firstRow: number, firstColumn: number, opts: ITxtLoadOptions): void
  • importTwoDimensionArray(objArray: any[][], styles: any[][], firstRow: number, firstColumn: number, convertStringToNumber: boolean): void

  • void importTwoDimensionArray(java.lang.Object[][], int, int)

    Parameters 参数

    • objArray: any[][]
    • firstRow: number
    • firstColumn: number

    Returns 返回值 void

  • void importTwoDimensionArray(java.lang.Object[][], int, int, boolean)

    Parameters 参数

    • objArray: any[][]
    • firstRow: number
    • firstColumn: number
    • convertStringToNumber: boolean

    Returns 返回值 void

  • void importTwoDimensionArray(java.lang.Object[][], java.lang.Object[][], int, int, com.aspose.cells.TxtLoadOptions)

    Parameters 参数

    • objArray: any[][]
    • styles: any[][]
    • firstRow: number
    • firstColumn: number
    • opts: ITxtLoadOptions

    Returns 返回值 void

  • void importTwoDimensionArray(java.lang.Object[][], java.lang.Object[][], int, int, boolean)

    Parameters 参数

    • objArray: any[][]
    • styles: any[][]
    • firstRow: number
    • firstColumn: number
    • convertStringToNumber: boolean

    Returns 返回值 void

insertColumn

  • insertColumn(columnIndex: number, updateReference: boolean): void
  • insertColumn(columnIndex: number): void

  • void insertColumn(int, boolean)

    Parameters 参数

    • columnIndex: number
    • updateReference: boolean

    Returns 返回值 void

  • void insertColumn(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 void

insertColumns

  • insertColumns(columnIndex: number, totalColumns: number): void
  • insertColumns(columnIndex: number, totalColumns: number, updateReference: boolean): void

  • void insertColumns(int, int)

    Parameters 参数

    • columnIndex: number
    • totalColumns: number

    Returns 返回值 void

  • void insertColumns(int, int, boolean)

    Parameters 参数

    • columnIndex: number
    • totalColumns: number
    • updateReference: boolean

    Returns 返回值 void

insertCutCells

  • insertCutCells(cutRange: IRange, row: number, column: number, shiftType: number): void

  • void insertCutCells(com.aspose.cells.Range, int, int, int)

    Parameters 参数

    • cutRange: IRange
    • row: number
    • column: number
    • shiftType: number

    Returns 返回值 void

insertRange

  • insertRange(area: ICellArea, shiftNumber: number, shiftType: number, updateReference: boolean): void
  • insertRange(area: ICellArea, shiftType: number): void
  • insertRange(area: ICellArea, shiftNumber: number, shiftType: number): void

  • void insertRange(com.aspose.cells.CellArea, int, int, boolean)

    Parameters 参数

    • area: ICellArea
    • shiftNumber: number
    • shiftType: number
    • updateReference: boolean

    Returns 返回值 void

  • void insertRange(com.aspose.cells.CellArea, int)

    Parameters 参数

    Returns 返回值 void

  • void insertRange(com.aspose.cells.CellArea, int, int)

    Parameters 参数

    • area: ICellArea
    • shiftNumber: number
    • shiftType: number

    Returns 返回值 void

insertRow

  • insertRow(rowIndex: number): void

  • void insertRow(int)

    Parameters 参数

    • rowIndex: number

    Returns 返回值 void

insertRows

  • insertRows(rowIndex: number, totalRows: number, options: IInsertOptions): void
  • insertRows(rowIndex: number, totalRows: number): void
  • insertRows(rowIndex: number, totalRows: number, updateReference: boolean): void

  • void insertRows(int, int, com.aspose.cells.InsertOptions)

    Parameters 参数

    Returns 返回值 void

  • void insertRows(int, int)

    Parameters 参数

    • rowIndex: number
    • totalRows: number

    Returns 返回值 void

  • void insertRows(int, int, boolean)

    Parameters 参数

    • rowIndex: number
    • totalRows: number
    • updateReference: boolean

    Returns 返回值 void

isBlankColumn

  • isBlankColumn(columnIndex: number): boolean

  • boolean isBlankColumn(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 boolean

isColumnHidden

  • isColumnHidden(columnIndex: number): boolean

  • boolean isColumnHidden(int)

    Parameters 参数

    • columnIndex: number

    Returns 返回值 boolean

isDefaultRowHeightMatched

  • isDefaultRowHeightMatched(): boolean

  • boolean isDefaultRowHeightMatched()

    Returns 返回值 boolean

isDefaultRowHidden

  • isDefaultRowHidden(): boolean

  • boolean isDefaultRowHidden()

    Returns 返回值 boolean

isDeletingRangeEnabled

  • isDeletingRangeEnabled(startRow: number, startColumn: number, totalRows: number, totalColumns: number): boolean

  • boolean isDeletingRangeEnabled(int, int, int, int)

    Parameters 参数

    • startRow: number
    • startColumn: number
    • totalRows: number
    • totalColumns: number

    Returns 返回值 boolean

isRowHidden

  • isRowHidden(rowIndex: number): boolean

  • boolean isRowHidden(int)

    Parameters 参数

    • rowIndex: number

    Returns 返回值 boolean

iterator

  • iterator(): any

  • java.util.Iterator iterator()

    Returns 返回值 any

linkToXmlMap

  • linkToXmlMap(mapName: string, row: number, column: number, path: string): void

  • void linkToXmlMap(java.lang.String, int, int, java.lang.String)

    Parameters 参数

    • mapName: string
    • row: number
    • column: number
    • path: string

    Returns 返回值 void

merge

  • merge(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number, mergeConflict: boolean): void
  • merge(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number, checkConflict: boolean, mergeConflict: boolean): void
  • merge(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number): void

  • void merge(int, int, int, int, boolean)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number
    • mergeConflict: boolean

    Returns 返回值 void

  • void merge(int, int, int, int, boolean, boolean)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number
    • checkConflict: boolean
    • mergeConflict: boolean

    Returns 返回值 void

  • void merge(int, int, int, int)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number

    Returns 返回值 void

moveRange

  • moveRange(sourceArea: ICellArea, destRow: number, destColumn: number): void

  • void moveRange(com.aspose.cells.CellArea, int, int)

    Parameters 参数

    • sourceArea: ICellArea
    • destRow: number
    • destColumn: number

    Returns 返回值 void

removeDuplicates

  • removeDuplicates(): void
  • removeDuplicates(startRow: number, startColumn: number, endRow: number, endColumn: number): void
  • removeDuplicates(startRow: number, startColumn: number, endRow: number, endColumn: number, hasHeaders: boolean, columnOffsets: number[]): void

  • void removeDuplicates()

    Returns 返回值 void

  • void removeDuplicates(int, int, int, int)

    Parameters 参数

    • startRow: number
    • startColumn: number
    • endRow: number
    • endColumn: number

    Returns 返回值 void

  • void removeDuplicates(int, int, int, int, boolean, int[])

    Parameters 参数

    • startRow: number
    • startColumn: number
    • endRow: number
    • endColumn: number
    • hasHeaders: boolean
    • columnOffsets: number[]

    Returns 返回值 void

removeFormulas

  • removeFormulas(): void

  • void removeFormulas()

    Returns 返回值 void

retrieveSubtotalSetting

  • com.aspose.cells.SubtotalSetting retrieveSubtotalSetting(com.aspose.cells.CellArea)

    Parameters 参数

    Returns 返回值 ISubtotalSetting

setColumnWidth

  • setColumnWidth(column: number, width: number): void

  • void setColumnWidth(int, double)

    Parameters 参数

    • column: number
    • width: number

    Returns 返回值 void

setColumnWidthInch

  • setColumnWidthInch(column: number, inches: number): void

  • void setColumnWidthInch(int, double)

    Parameters 参数

    • column: number
    • inches: number

    Returns 返回值 void

setColumnWidthPixel

  • setColumnWidthPixel(column: number, pixels: number): void

  • void setColumnWidthPixel(int, int)

    Parameters 参数

    • column: number
    • pixels: number

    Returns 返回值 void

setDefaultRowHeightMatched

  • setDefaultRowHeightMatched(value: boolean): void

  • void setDefaultRowHeightMatched(boolean)

    Parameters 参数

    • value: boolean

    Returns 返回值 void

setDefaultRowHidden

  • setDefaultRowHidden(value: boolean): void

  • void setDefaultRowHidden(boolean)

    Parameters 参数

    • value: boolean

    Returns 返回值 void

setMemorySetting

  • setMemorySetting(value: number): void

  • void setMemorySetting(int)

    Parameters 参数

    • value: number

    Returns 返回值 void

setMultiThreadReading

  • setMultiThreadReading(value: boolean): void

  • void setMultiThreadReading(boolean)

    Parameters 参数

    • value: boolean

    Returns 返回值 void

setPreserveString

  • setPreserveString(value: boolean): void

  • void setPreserveString(boolean)

    Parameters 参数

    • value: boolean

    Returns 返回值 void

setRowHeight

  • setRowHeight(row: number, height: number): void

  • void setRowHeight(int, double)

    Parameters 参数

    • row: number
    • height: number

    Returns 返回值 void

setRowHeightInch

  • setRowHeightInch(row: number, inches: number): void

  • void setRowHeightInch(int, double)

    Parameters 参数

    • row: number
    • inches: number

    Returns 返回值 void

setRowHeightPixel

  • setRowHeightPixel(row: number, pixels: number): void

  • void setRowHeightPixel(int, int)

    Parameters 参数

    • row: number
    • pixels: number

    Returns 返回值 void

setStandardHeight

  • setStandardHeight(value: number): void

  • void setStandardHeight(double)

    Parameters 参数

    • value: number

    Returns 返回值 void

setStandardHeightPixels

  • setStandardHeightPixels(value: number): void

  • void setStandardHeightPixels(int)

    Parameters 参数

    • value: number

    Returns 返回值 void

setStandardWidth

  • setStandardWidth(value: number): void

  • void setStandardWidth(double)

    Parameters 参数

    • value: number

    Returns 返回值 void

setStandardWidthInch

  • setStandardWidthInch(value: number): void

  • void setStandardWidthInch(double)

    Parameters 参数

    • value: number

    Returns 返回值 void

setStandardWidthPixels

  • setStandardWidthPixels(value: number): void

  • void setStandardWidthPixels(int)

    Parameters 参数

    • value: number

    Returns 返回值 void

setStyle

  • setStyle(value: IStyle): void

  • void setStyle(com.aspose.cells.Style)

    Parameters 参数

    Returns 返回值 void

setViewColumnWidthPixel

  • setViewColumnWidthPixel(column: number, pixels: number): void

  • void setViewColumnWidthPixel(int, int)

    Parameters 参数

    • column: number
    • pixels: number

    Returns 返回值 void

showGroupDetail

  • showGroupDetail(isVertical: boolean, index: number): void

  • void showGroupDetail(boolean, int)

    Parameters 参数

    • isVertical: boolean
    • index: number

    Returns 返回值 void

subtotal

  • subtotal(ca: ICellArea, groupBy: number, fn: number, totalList: number[]): void
  • subtotal(ca: ICellArea, groupBy: number, fn: number, totalList: number[], replace: boolean, pageBreaks: boolean, summaryBelowData: boolean): void

  • void subtotal(com.aspose.cells.CellArea, int, int, int[])

    Parameters 参数

    • ca: ICellArea
    • groupBy: number
    • fn: number
    • totalList: number[]

    Returns 返回值 void

  • void subtotal(com.aspose.cells.CellArea, int, int, int[], boolean, boolean, boolean)

    Parameters 参数

    • ca: ICellArea
    • groupBy: number
    • fn: number
    • totalList: number[]
    • replace: boolean
    • pageBreaks: boolean
    • summaryBelowData: boolean

    Returns 返回值 void

textToColumns

  • textToColumns(row: number, column: number, totalRows: number, options: ITxtLoadOptions): void

  • void textToColumns(int, int, int, com.aspose.cells.TxtLoadOptions)

    Parameters 参数

    Returns 返回值 void

unMerge

  • unMerge(firstRow: number, firstColumn: number, totalRows: number, totalColumns: number): void

  • void unMerge(int, int, int, int)

    Parameters 参数

    • firstRow: number
    • firstColumn: number
    • totalRows: number
    • totalColumns: number

    Returns 返回值 void

ungroupColumns

  • ungroupColumns(firstIndex: number, lastIndex: number): void

  • void ungroupColumns(int, int)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number

    Returns 返回值 void

ungroupRows

  • ungroupRows(firstIndex: number, lastIndex: number): void
  • ungroupRows(firstIndex: number, lastIndex: number, isAll: boolean): void

  • void ungroupRows(int, int)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number

    Returns 返回值 void

  • void ungroupRows(int, int, boolean)

    Parameters 参数

    • firstIndex: number
    • lastIndex: number
    • isAll: boolean

    Returns 返回值 void

unhideColumn

  • unhideColumn(column: number, width: number): void

  • void unhideColumn(int, double)

    Parameters 参数

    • column: number
    • width: number

    Returns 返回值 void

unhideColumns

  • unhideColumns(column: number, totalColumns: number, width: number): void

  • void unhideColumns(int, int, double)

    Parameters 参数

    • column: number
    • totalColumns: number
    • width: number

    Returns 返回值 void

unhideRow

  • unhideRow(row: number, height: number): void

  • void unhideRow(int, double)

    Parameters 参数

    • row: number
    • height: number

    Returns 返回值 void

unhideRows

  • unhideRows(row: number, totalRows: number, height: number): void

  • void unhideRows(int, int, double)

    Parameters 参数

    • row: number
    • totalRows: number
    • height: number

    Returns 返回值 void