ExcelService Members
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