Export (0) Print
Expand All

ExcelService Methods

The ExcelService type exposes the following members.

  Name Description
Public method Calculate Calculates formulas in the open workbook, or in a range within the workbook, using numeric range coordinates.
Public method CalculateA1 Calculates formulas in the open workbook, or in a range within the workbook, using the Excel "A1" range specification.
Public method CalculateWorkbook Calculates the entire open workbook, using one of the supported calculation methods.
Public method CancelRequest Cancels the most recent request if it is still pending in the session.
Public method CloseWorkbook Closes the session and the workbook that is currently open in that session.
Public method Dispose() (Inherited from MarshalByValueComponent.)
Protected method Dispose(Boolean) (Overrides MarshalByValueComponent.Dispose(Boolean).)
Protected method Finalize (Inherited from MarshalByValueComponent.)
Public method GetApiVersion Gets the Excel Web Services version information.
Public method GetCell Gets a calculated value from a cell in the open workbook, using numeric cell coordinates.
Public method GetCellA1 Gets a calculated value from a cell in the open workbook, using the Excel "A1" range specification.
Public method GetChartImageUrl Gets a URL value to the chart or PivotChart image file in a workbook.
Public method GetPublishedItemNames Gets a list of published items in a workbook.
Public method GetRange Gets calculated values from a range in the open workbook, using numeric range coordinates.
Public method GetRangeA1 Gets calculated values from a range in the open workbook, using the Excel "A1" range specification.
Public method GetService (Inherited from MarshalByValueComponent.)
Public method GetSessionInformation Gets the run-time properties for the Excel Calculation Services session.
Public method GetSheetNames Gets a list of all of the sheet names present in a workbook.
Public method GetWorkbook Gets the contents of the entire open workbook.
Public method NewWorkbook Creates a new session that does not use a pre-existing workbook.
Public method OpenWorkbook Opens an Excel workbook file in a new Excel Calculation Services session.
Public method OpenWorkbookForEditing Opens a workbook for editing.
Public method Refresh Retrieves updated data from external data sources for the open workbook.
Public method SaveWorkbook Saves a workbook in the original format (.xlsx, .xlsb, .xlsm).
Public method SaveWorkbookCopy Saves a workbook using a different file name and/or to a different SharePoint document library.
Public method SetCalculationOptions Changes the calculation mode setting for workbooks.
Public method SetCell Sets a value or formula into a cell.
Public method SetCellA1 Sets a value or formula into a cell in the open workbook, using the Excel "A1" range specification.
Public method SetParameters Sets multiple published parameters with a single Web Service call.
Public method SetRange Sets values or formulae into a range, using numeric range coordinates.
Public method SetRangeA1 Sets values or formulae into a range using the Excel "A1" range specification.
Public method ToString (Inherited from MarshalByValueComponent.)
Top
Show:
© 2015 Microsoft