Web API Core | ComponentOne
Services / Excel Services / Add/Delete Columns
In This Topic
    Add/Delete Columns
    In This Topic

    Excel Web API service allows the user to add, update or delete columns from an excel sheet. Your client application sends an HTTP request to the Web API service application. This request uses GET and POST methods to seek a response from the service. While, GET method retrieves the intended information from the resource specified, POST method submits the data to the resource.

    Excel Path, Sheet Name, and Column Indexes are common parameters for all the three operations specified below.

    Add Column

    To add a column in an excel sheet, you need to use a POST method.

    POST: http://<host>[port]/api/excel/{excel path}/{sheet name}/columns/{column index}

    The following illustration depicts a request URL with parameters to Add/Delete Column in an Excel file.


    The following table elaborates request URL parameters required to Add/Delete Column in an Excel file.

    Parameter

    Values Supported

    Description

    ExcelPath

    xls, xlsx

    The excel file name that storage manager can recognize.

    Sheet Name

    String

    The sheet name.

    Column Index

    Integer

    The column index.

    Update Columns

    Allows the user to update the columns in an excel sheet, you can also use this REST API to hide/unhide or group/ungroup columns. To update a column in an excel sheet, you need to use the PUT method.

    PUT: http://<host>[port]/api/excel/{excel path}/{sheet name}/columns/{column indexes}

    Note: You can also update the column properties using the same Excel API service by specifying the column property name and value. Available properties are Visible(Boolean) and OutlineLevel(int).

    Delete Columns

    Allows the user to delete a column in an excel sheet. To delete a column in an excel sheet, you need to use the DELETE method.

    DELETE: http://<host>[port]/api/excel/{excel path}/{sheet name}/columns/{column indexes}