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

Aspose.Cells1,WorkbookworkBook=newExcel获取或设置是否将字符串转换至数字默认值为获取或设置工作簿获取工作簿获取工作簿CountryCode获取或设置工作簿CountryCode获取或设置工作簿区域(指当前使用获取或设置当前工作簿获取或设置是否显示标签（工作表标CalculateFormula(bool,ICustomFunctioncustomFunction)ChangePalette(Colorcolor,intCombine(WorkbooksecondWorkbookworkSheetCopy(WorkbookDecrypt(stringIsColorInPalette(ColorcolorExcelLoadData(stringLoadData(System.IO.StreamExcelWorkbookOpen(stringstringpassword);+8ExcelstringReplace(stringstringnewValue);工作簿中类型和值完全符合的单元Save(Server.UrlEncode("测试SaveType.OpenInExcel,Response);+8Unprotect(stringValidateFormula(stringWorksheetworksheet=workbook.Worksheets[index];Worksheetworksheet=new自动默认为获取当前工作表索引（标签位置0Excel默认为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获取或设置工作表标签列表显示宽AddWorksheetWorksheets.Add();WorksheetWorksheets.Add(type)WorksheetSheetType–AddCopyintWorksheets.AddCopy(sheetIndex);intvoid删除指定的voidrangeIEnumeratorrangeRange[]range根据rangeRangeWorksheets.rangevoidvoidSetsdisplayedsizewhenWorkbookfileisusedasanOlevoidvoidCellscells=newCells();获取有效单元格数量(非空单元获取或设置是否用字符来代替密0获取最大包含数据列;列下标从获取最大包含数据行;行下标从000rangevoid0void0void检查单元格，如果为空返回-1,00int如果为空返回-1,00voidvoidvoidvoidvoidvoidvoidCells.CopyRow(sourceCells,sourceRowIndex,创建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单元格内容到objectobject[,]ExportDataTableDataTableCells.ExportDataTable(firstRow,firstColumn,rowNumber,columnNuber);DataTableCells.ExportDataTable(firstRow,firstColumn,rowNumber,columnNuber,exportColumnName);DataTableCells.ExportDataTable(firstRow,firstColumn,rowNumber,columnNumber,defaultValues);DataTableisVerticaltrue，DataTableisVerticalfalse,DataTablerange单元格数据以字符串格式输出到DataTablerange单元格数据以字符串格式输出到DataTableDataTableCells.ExportDataTableAsString(firstRow,firstColumn,rowNumber,columnNumber);DataTableCells.ExportDataTableAsString(firstRow,firstColumn,rowNumber,columnNumber,rangeCellValueTypeCellValueType[,]formulaCellExcelformulaCell公式字符串;例:‖=‖,‖SUM‖FindNumberCellCells.FindNumber(inputNumber,previousCell);Cell公式字符串;例:‖=‖,‖SUM‖CellCells.FindString(inputString,previousCell);CellCells.FindString(inputString,previousCell,upDown);CellFindStringContainsCellCells.FindStringContains(inputString,previousCell);CellCells.FindStringContains(inputString,previousCell,isCaseSensitive);CellCells.返回当前工作表中单元格格式为字符串并值尾部位置为inputStringCellCells.FindStringEndsWith返回当前工作表中单元格格式为字符串并值头部位置为inputStringCellCells.doubleintIEnumeratordoubleintGroupColumnsvoidCells.GroupColumns(firstIndex,lastIndex);voidGroupRowsvoidCells.GroupRows(firstIndex,lastIndex);voidvoidvoidImportArrayvoidCells.ImportArray(doubleArray,firstRow,firstColumn);voidvoidvoidvoidvoid导入工作表方向，truefalsearrayListvoid导入工作表方向，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获取字符偏移量（个数RangePutValuevoidCell.PutValue(boolValue);voidvoidvoidvoidvoidvoidfalsevoidvoidvoidvoidRangesranges=newRanges();Rangesranges=Worksheets.Cells.RangevoidRangerange=newRange();Rangerange=Worksheets.Cells.Ranges[intrangerangerangerangerange获取range获取range获取或设置rangerangevoidRange.ApplyStyle(style,拷贝voidrangevoid导出所选择rangeDataTableDataTable导出所选择rangeDataTableDataTable合并range合并rangevoid设置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=获取或设置voidvoidvoidChartsChartscharts=newCharts();Chartscharts=intChartType–voidChartChartchart=charts[intindex];Chartchart=charts[stringname];Chartchart=Worksheet.Charts[intindex];Chartchart=