Web API Edition | ComponentOne
Services / Excel Services / Add/Delete Row
In This Topic
    Add/Delete Row
    In This Topic

    Excel Web API service allows the user to add, update or delete rows 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 Row Indexes are common parameters for all the three operations specified below.

    Add Row

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

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

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

    The following table elaborates request URL parameters required to Add/Delete Row 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.

    Row Index

    Integer

    The row index.

    Update Rows

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

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

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

    Delete Rows

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

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