Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Include Protected Members
Include Inherited Members
Excel Web Services is exposed as a web service.
The ExcelService type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
ExcelService | Initializes a new instance of the ExcelService class. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | (Inherited from WebService.) |
|
Container | (Inherited from MarshalByValueComponent.) |
|
Context | (Inherited from WebService.) |
|
DesignMode | (Inherited from MarshalByValueComponent.) |
.gif "Protected property") |
Events | (Inherited from MarshalByValueComponent.) |
|
Server | (Inherited from WebService.) |
|
Session | (Inherited from WebService.) |
|
Site | (Inherited from MarshalByValueComponent.) |
|
SoapVersion | (Inherited from WebService.) |
|
User | (Inherited from WebService.) |
Top
Methods
| Name | Description | |
|---|---|---|
|
Calculate | Calculates formulas in the open workbook, or in a range within the workbook, using numeric range coordinates. |
|
CalculateA1 | Calculates formulas in the open workbook, or in a range within the workbook, using the Excel "A1" range specification. |
|
CalculateWorkbook | Calculates the entire open workbook, using one of the supported calculation methods. |
|
CancelRequest | Cancels the most recent request if it is still pending in the session. |
|
CloseWorkbook | Closes the session and the workbook that is currently open in that session. |
|
Dispose() | (Inherited from MarshalByValueComponent.) |
.gif "Protected method") |
Dispose(Boolean) | (Overrides MarshalByValueComponent.Dispose(Boolean).) |
|
Finalize | (Inherited from MarshalByValueComponent.) |
|
GetApiVersion | Gets the Excel Web Services version information. |
|
GetCell | Gets a calculated value from a cell in the open workbook, using numeric cell coordinates. |
|
GetCellA1 | Gets a calculated value from a cell in the open workbook, using the Excel "A1" range specification. |
|
GetChartImageUrl | Gets a URL value to the chart or PivotChart image file in a workbook. |
|
GetPublishedItemNames | Gets a list of published items in a workbook. |
|
GetRange | Gets calculated values from a range in the open workbook, using numeric range coordinates. |
|
GetRangeA1 | Gets calculated values from a range in the open workbook, using the Excel "A1" range specification. |
|
GetService | (Inherited from MarshalByValueComponent.) |
|
GetSessionInformation | Gets the run-time properties for the Excel Calculation Services session. |
|
GetSheetNames | Gets a list of all of the sheet names present in a workbook. |
|
GetWorkbook | Gets the contents of the entire open workbook. |
|
NewWorkbook | Creates a new session that does not use a pre-existing workbook. |
|
OpenWorkbook | Opens an Excel workbook file in a new Excel Calculation Services session. |
|
OpenWorkbookForEditing | Opens a workbook for editing. |
|
Refresh | Retrieves updated data from external data sources for the open workbook. |
|
SaveWorkbook | Saves a workbook in the original format (.xlsx, .xlsb, .xlsm). |
|
SaveWorkbookCopy | Saves a workbook using a different file name and/or to a different SharePoint document library. |
|
SetCalculationOptions | Changes the calculation mode setting for workbooks. |
|
SetCell | Sets a value or formula into a cell. |
|
SetCellA1 | Sets a value or formula into a cell in the open workbook, using the Excel "A1" range specification. |
|
SetParameters | Sets multiple published parameters with a single Web Service call. |
|
SetRange | Sets values or formulae into a range, using numeric range coordinates. |
|
SetRangeA1 | Sets values or formulae into a range using the Excel "A1" range specification. |
|
ToString | (Inherited from MarshalByValueComponent.) |
Top
Events
| Name | Description | |
|---|---|---|
.gif "Public event") |
Disposed | (Inherited from MarshalByValueComponent.) |
Top