Aspose.Cells+API+中文版文檔完整

Aspose.Cells1,WorkbookworkBook=newExcel獲取或設(shè)置是否將字符串轉(zhuǎn)換至數(shù)字默認(rèn)值為獲取或設(shè)置工作簿獲取工作簿獲取工作簿CountryCode獲取或設(shè)置工作簿CountryCode獲取或設(shè)置工作簿區(qū)域(指當(dāng)前使用獲取或設(shè)置當(dāng)前工作簿獲取或設(shè)置是否顯示標(biāo)簽（工作表標(biāo)CalculateFormula(bool,ICustomFunctioncustomFunction)ChangePalette(Colorcolor,intCombine(WorkbooksecondWorkbookworkSheetCopy(WorkbookDecrypt(stringIsColorInPalette(ColorcolorExcelLoadData(stringLoadData(System.IO.StreamExcelWorkbookOpen(stringstringpassword);+8ExcelstringReplace(stringstringnewValue);工作簿中類型和值完全符合的單元Save(Server.UrlEncode("測(cè)試SaveType.OpenInExcel,Response);+8Unprotect(stringValidateFormula(stringWorksheetworksheet=workbook.Worksheets[index];Worksheetworksheet=new自動(dòng)默認(rèn)為獲取當(dāng)前工作表索引（標(biāo)簽位置0Excel默認(rèn)為SheetType—10-400voidWorksheet.AutoFitColumn(columnIndex,firstRow,lastRow);000voidvoidWorksheet.AutoFitRow(rowIndex,firstColumn,lastColumn);000voidvoidvoidvoidWorksheet.FreezePanes(cellName,freezedRows,freezedColumns)(Row,Column,freezedRows,freezedColumns);單元格名稱;例ArrayListvoidvoidWorksheet.Protect(type,password,oldPassword)；ProtectionType–voidvoidvoidWorksheet.Replace(oldString,要替換字符串（完全相等voidvoidvoidvoidWorksheetsworksheets=workbook.Worksheets;Worksheetsworksheets=new承接定做活的HTTP獲取或設(shè)置工作表標(biāo)簽列表顯示寬AddWorksheetWorksheets.Add();WorksheetWorksheets.Add(type)WorksheetSheetType–AddCopyintWorksheets.AddCopy(sheetIndex);intvoid刪除指定的voidrangeIEnumeratorrangeRange[]range根據(jù)rangeRangeWorksheets.rangevoidvoidSetsdisplayedsizewhenWorkbookfileisusedasanOlevoidvoidCellscells=newCells();獲取有效單元格數(shù)量(非空單元獲取或設(shè)置是否用字符來(lái)代替密0獲取最大包含數(shù)據(jù)列;列下標(biāo)從獲取最大包含數(shù)據(jù)行;行下標(biāo)從000rangevoid0void0void檢查單元格，如果為空返回-1,00int如果為空返回-1,00voidvoidvoidvoidvoidvoidvoidCells.CopyRow(sourceCells,sourceRowIndex,創(chuàng)建RangeCells.CreateRange(upperLeftCell,lowerRightCell);RangeRangerangeisVertical指定rangeisVertical是否垂直延伸；TruerangerangeDeleteColumnvoidCells.DeleteColumn(columnIndex);voidCells.DeleteColumn(columnIndex,rangerangevoidShiftType–rangevoidDeleteRowsvoidCells.DeleteRows(rowIndex,rowNumber);voidEndCellInColumnvoidCells.EndCellInColumn(columnIndex);voidCells.EndCellInRowvoidCells.EndCellInRow(rowIndex);voidrange單元格內(nèi)容到objectobject[,]ExportDataTableDataTableCells.ExportDataTable(firstRow,firstColumn,rowNumber,columnNuber);DataTableCells.ExportDataTable(firstRow,firstColumn,rowNumber,columnNuber,exportColumnName);DataTableCells.ExportDataTable(firstRow,firstColumn,rowNumber,columnNumber,defaultValues);DataTableisVerticaltrue，DataTableisVerticalfalse,DataTablerange單元格數(shù)據(jù)以字符串格式輸出到DataTablerange單元格數(shù)據(jù)以字符串格式輸出到DataTableDataTableCells.ExportDataTableAsString(firstRow,firstColumn,rowNumber,columnNumber);DataTableCells.ExportDataTableAsString(firstRow,firstColumn,rowNumber,columnNumber,rangeCellValueTypeCellValueType[,]formulaCellExcelformulaCell公式字符串;例:‖=‖,‖SUM‖F(xiàn)indNumberCellCells.FindNumber(inputNumber,previousCell);Cell公式字符串;例:‖=‖,‖SUM‖CellCells.FindString(inputString,previousCell);CellCells.FindString(inputString,previousCell,upDown);CellFindStringContainsCellCells.FindStringContains(inputString,previousCell);CellCells.FindStringContains(inputString,previousCell,isCaseSensitive);CellCells.返回當(dāng)前工作表中單元格格式為字符串并值尾部位置為inputStringCellCells.FindStringEndsWith返回當(dāng)前工作表中單元格格式為字符串并值頭部位置為inputStringCellCells.doubleintIEnumeratordoubleintGroupColumnsvoidCells.GroupColumns(firstIndex,lastIndex);voidGroupRowsvoidCells.GroupRows(firstIndex,lastIndex);voidvoidvoidImportArrayvoidCells.ImportArray(doubleArray,firstRow,firstColumn);voidvoidvoidvoidvoid導(dǎo)入工作表方向，truefalsearrayListvoid導(dǎo)入工作表方向，true，falseImportDataColumndataTable/dataViewvoidCells.ImportDataColumn(dataTable,isFieldNameShown,firstRow,firstColumn,importColumnIndex,voidCells.ImportDataColumn(dataTable,isFieldNameShown,firstRow,firstColumn,importColumnName,voidCells.ImportDataColumn(dataTable,ifFieldNameShown,firstRow,firstColumn,importColumnIndex,voidDataTable0DataTableImportDataGridDataGridintCells.ImportDataGrid(dataGrid,firstRow,firstColumn,insertRows);intdataGriddataGridDataGridintdataGriddataGridDataRowvoidImportDataTableDataTableintCells.ImportDataTable(dataTable,isFieldNameShown,startCell);intCells.ImportDataTable(dataTable,isFieldNameShown,firstRow,firstColumn);intCells.ImportDataTable(dataTable,isFieldNameShown,firstRow,firstColumn,insertRows);intCells.ImportDataTable(dataTable,isFieldNameShown,firstRow,firstColumn,insertRows,intCells.ImportDataTable(dataTable,isFieldNameShown,firstRow,firstColumn,rowNumber,columnNumber);intCells.ImportDataTable(dataTable,isFileldNameShown,firstRow,firstColumn,rowNumber,columnNumber,intCells.ImportDataTable(dataTable,isFileldNameShown,firstRow,firstColumn,rowNumber,columnNumber,insertRows,dateFormatString);intCells.ImportDataTable(dataTable,isFileldNameShown,firstRow,firstColumn,rowNumber,columnNumber,insertRows,dateFormatString,convertStringToNumber);起始單元格名稱;例dataTabledataTableImportDataViewDataViewintCells.ImportDataView(dataView,firstRow,firstColumn);intintintintintCells.ImportDataView(dataView,isFieldNameShown,firstRow,firstColumn,rowNumber,columnNumber,insertRows);intCells.ImportDataView(dataView,isFieldNameShown,firstRow,firstColumn,rowNumber,columnNumber,string[]voidExcelisVerticaltrue，isVerticalfalse,ImportFromDataReaderDataReaderintCells.ImportFromDataReader(oleReader,firstRow,firstColumn,insertRows);intintCells.ImportFromDataReader(sqlReader,firstRow,firstColumn,insertRows);intGridViewGridViewintobject[]voidCells.ImportObjectArray(objArray,firstRow,firstColumn,isVerticaltrue，isVerticalfalse,objectobject[,]voidCells.ImportTwoDimensionArray(objArray,firstRow,InsertColumnvoidCells.InsertColumn(columnIndex);voidInsertRangevoidCells.InsertRange(area,shiftType);voidCells.InsertRange(area,shiftNumber,shiftType);voidCells.ShiftType–voidInsertRowsvoidCells.InsertRows(rowIndex,rowNumber);voidintvoidvoidvoidvoidvoidvoidCells.voidvoidvoidvoidvoidvoidvoidCellcells=newCell();Worksheets.Cells[intindex]Worksheets.Cells[stringcellName]Worksheets.Cells[introw,intdoublefloatHTMLintstringCellValueType–Characters獲取字符偏移量（個(gè)數(shù)RangePutValuevoidCell.PutValue(boolValue);voidvoidvoidvoidvoidvoidfalsevoidvoidvoidvoidRangesranges=newRanges();Rangesranges=Worksheets.Cells.RangevoidRangerange=newRange();Rangerange=Worksheets.Cells.Ranges[intrangerangerangerangerange獲取range獲取range獲取或設(shè)置rangerangevoidRange.ApplyStyle(style,拷貝voidrangevoid導(dǎo)出所選擇rangeDataTableDataTable導(dǎo)出所選擇rangeDataTableDataTable合并range合并rangevoid設(shè)置rangevoidBorderType—CellBorderType—SetOutlineBordersrange邊界線樣式（外部所有相鄰單元格相鄰邊界線）Range.SetOutlineBorders(borderStyle,borderColor);Range.SetOutlineBorders(borderStyles,CellBorderTypeCellBorderType[]-取消合并rangevoidAspose.Cells.Stylestyle=Workbook.DefaultStyle;Aspose.Cells.Stylestyle=Workbook.Styles[Workbook.Styles.Add()];Stylesstyles=workbook.Styles;intstyleIndex=styles.Add();Aspose.Cells.Stylestyle=值;"\"$\"#,##0";等TextAlignmentType-style9–百分比;8-￥BackgroundTypeTextDirectionTypeTextAlignmentTypeStyleFlagflag=newDataSorterDataSorterdsor=newDataSorter();DataSorterdsor=SortOrder–SortOrder–SortOrder–voidvoidDataSorter.Sort(cells,AutoFilterAutoFilteraf=newAutoFilter();AutoFilteraf=獲取或設(shè)置voidvoidvoidChartsChartscharts=newCharts();Chartscharts=intChartType–voidChartChartchart=charts[intindex];Chartchart=charts[stringname];Chartchart=Worksheet.Charts[intindex];Chartchart=