接口的使用
com.grapecity.documents.excel.IWorksheet

使用IWorksheet的程序包

程序包	说明
com.grapecity.documents.excel
com.grapecity.documents.excel.drawing

com.grapecity.documents.excel中IWorksheet的使用

返回IWorksheet的com.grapecity.documents.excel中的方法

修饰符和类型	方法	说明
IWorksheet	IWorksheets.add()	Creates a new worksheet.
IWorksheet	IWorksheets.add(SheetType type)	Creates a new sheet.
IWorksheet	IWorksheets.addAfter(IWorksheet sheet)	Creates a new worksheet and inserts it after the specified sheet.
IWorksheet	IWorksheets.addBefore(IWorksheet sheet)	Creates a new worksheet and inserts it before the specified sheet.
IWorksheet	IWorksheet.copy()	Copies the sheet to the end of the current workbook.
IWorksheet	IWorksheet.copy(IWorkbook workbook)	Copies the sheet to the end of the specified workbook.
IWorksheet	IWorksheet.copyAfter(IWorksheet targetSheet)	Copies the sheet to the location after the specified sheet.
IWorksheet	IWorksheet.copyBefore(IWorksheet targetSheet)	Copies the sheet to the location before the specified sheet.
IWorksheet	IWorksheets.get(int index)	Gets the worksheet using the index.
IWorksheet	IWorksheets.get(String name)	Gets the worksheet using the name.
IWorksheet	IWorkbook.getActiveSheet()	Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook.
IWorksheet	Workbook.getActiveSheet()	Gets the active sheet.
final IWorksheet	SheetEventArgs.getSheet()	Gets IWorksheet of SheetEventArgs.
IWorksheet	ICalcContext.getWorksheet()	Get the IWorksheet that contains the cell which is calculating.
IWorksheet	IRange.getWorksheet()	Returns the parent IWorksheet of this range.
IWorksheet	IWorksheet.move()	Moves the sheet to the end of the current workbook.
IWorksheet	IWorksheet.move(IWorkbook workbook)	Moves the sheet to the end of the specified workbook.
IWorksheet	IWorksheet.moveAfter(IWorksheet targetSheet)	Moves the sheet to the location after the specified sheet.
IWorksheet	IWorksheet.moveBefore(IWorksheet targetSheet)	Moves the sheet to the location before the specified sheet.

参数类型为IWorksheet的com.grapecity.documents.excel中的方法

修饰符和类型	方法	说明
ISlicer	ISlicers.add(IWorksheet slicerDestination, String name, String caption, double top, double left, double width, double height)	Creates a new slicer and returns a ISlicer object.
IWorksheet	IWorksheets.addAfter(IWorksheet sheet)	Creates a new worksheet and inserts it after the specified sheet.
IWorksheet	IWorksheets.addBefore(IWorksheet sheet)	Creates a new worksheet and inserts it before the specified sheet.
ISignature	ISignatureSet.addSignatureLine(IWorksheet worksheet, double left, double top)	Adds lines to a document where signatures are collected.
ISignature	ISignatureSet.addSignatureLine(IWorksheet worksheet, double left, double top, double width)	Adds lines to a document where signatures are collected.
ISignature	ISignatureSet.addSignatureLine(IWorksheet worksheet, double left, double top, double width, double height)	Adds lines to a document where signatures are collected.
boolean	IWorksheets.contains(IWorksheet worksheet)	Returns true if the specified Worksheet is contained by the collection of worksheets; otherwise, false is returned.
IWorksheet	IWorksheet.copyAfter(IWorksheet targetSheet)	Copies the sheet to the location after the specified sheet.
IWorksheets	IWorksheets.copyAfter(IWorksheet targetWorksheet)	Copies the sheet collection to the location after the specified sheet.
IWorksheet	IWorksheet.copyBefore(IWorksheet targetSheet)	Copies the sheet to the location before the specified sheet.
IWorksheets	IWorksheets.copyBefore(IWorksheet targetWorksheet)	Copies the sheet collection to the location before the specified sheet.
IWorkbook	IWorkbook.generateReport(IWorksheet... worksheets)	Process the template and return the instance of report workbook.
IWorkbook	Workbook.generateReport(IWorksheet... worksheets)	Process the template and return the instance of report workbook.
int	IWorksheets.indexOf(IWorksheet worksheet)	Returns the zero-based index of the specified worksheet in the collection.
IWorksheet	IWorksheet.moveAfter(IWorksheet targetSheet)	Moves the sheet to the location after the specified sheet.
IWorksheets	IWorksheets.moveAfter(IWorksheet targetWorksheet)	Moves the sheet collection to the location after the specified sheet.
IWorksheet	IWorksheet.moveBefore(IWorksheet targetSheet)	Moves the sheet to the location before the specified sheet.
IWorksheets	IWorksheets.moveBefore(IWorksheet targetWorksheet)	Moves the sheet collection to the location before the specified sheet.

参数类型为IWorksheet的com.grapecity.documents.excel中的构造器

限定符	构造器	说明
	RangeTemplateCellType(IWorksheet worksheet)	Use a worksheet and it's used range info to create a RangeTemplateCellType.
	RangeTemplateCellType(IWorksheet worksheet, int row, int column, int rowCount, int columnCount)	Use a worksheet and specific range to create a RangeTemplateCellType.
	SheetEventArgs(IWorksheet sheet)	Specifies the construction.

com.grapecity.documents.excel.drawing中IWorksheet的使用

返回IWorksheet的com.grapecity.documents.excel.drawing中的方法

修饰符和类型	方法	说明
IWorksheet	IShape.getParent()	Gets the shape's parent sheet