Working with Excel Rows – Aspose.Cells Cloud API
Contents
[
Hide
]
Working with rows on an Excel file
- How to get row information on an Excel worksheet.
- How to add an empty row on an Excel worksheet.
- How to copy rows on an Excel worksheet.
- How to hide rows in an Excel worksheet.
- How to unhide rows in an Excel worksheet.
- How to group rows in an Excel worksheet.
- How to ungroup rows in an Excel worksheet.
- How to delete a row from a worksheet
Quick API reference for common row operations:
| Operation | HTTP Method | Endpoint | Key Parameters |
|---|---|---|---|
| Get Row | GET | /cells/{fileName}/worksheets/{sheetName}/rows/{rowIndex} |
fileName, sheetName, rowIndex |
| Add Row | POST | /cells/{fileName}/worksheets/{sheetName}/rows |
rowIndex, height |
| Copy Rows | POST | /cells/{fileName}/worksheets/{sheetName}/rows/copy |
sourceIndex, destinationIndex, rowCount |
| Delete Row | DELETE | /cells/{fileName}/worksheets/{sheetName}/rows/{rowIndex} |
fileName, sheetName, rowIndex |
| Hide Rows | POST | /cells/{fileName}/worksheets/{sheetName}/rows/hide |
startIndex, endIndex |
| Unhide Rows | POST | /cells/{fileName}/worksheets/{sheetName}/rows/unhide |
startIndex, endIndex |
| Group Rows | POST | /cells/{fileName}/worksheets/{sheetName}/rows/group |
startIndex, endIndex |
| Ungroup Rows | POST | /cells/{fileName}/worksheets/{sheetName}/rows/ungroup |
startIndex, endIndex |