# Methods
Here are the methods used to open, save, rename and close an excel workbook
# #ctor() constructor
Initializes a new instance of the class
# Method: OpenWorkBook(System.String)
Parameters:
Fields | |
---|---|
pathOfWorkbook | String - The path where the excel workbook is located |
# Method: OpenWorkSheet(System.Int32)
Parameters:
Fields | |
---|---|
selectedsheetnumber | Number- specifies the selected sheet number to open |
# Method: OpenWorkSheet(System.String)
Parameters:
Fields | |
---|---|
selectedsheetname | String- specifies the selected sheet name to open |
# Method: RenameWorkSheet(System.String)
Parameters:
Fields | |
---|---|
newSheetName | String- new name for the sheet |
# Method: RenameWorkSheet(System.String, System.String)
Parameters:
Fields | |
---|---|
oldsheetname | String- The old sheet name |
newsheetname | String- The new sheet name |
# Method: SaveAndCloseWorkBook()
Method saves and close the selected workbook
# Method: SaveAsWorkBook(System.String)
Parameters:
Fields | |
---|---|
path | String- The path of the workbook |
# Method: SaveWorkBook()
Saves the workbook
# Method: Dispose()
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources
# Method: CloseWorkBook()
Closes the work book