Working with Excel Worksheets

A worksheet is a collection of cells where you store and manipulate data. Each Excel workbook can contain multiple worksheets.

Worksheet Operations

• Get all worksheets – Retrieves the complete list of worksheets in a workbook.
• Get a worksheet in a specific format – Returns a worksheet in JSON, XML, CSV, or other supported formats.
• Export a worksheet area in different formats – Converts a selected cell range to PDF, HTML, or image formats.
• Export a worksheet page in different formats – Retrieves a particular page of a worksheet as PDF, PNG, or other formats.
• Convert a worksheet to an image – Renders the entire worksheet as a PNG, JPEG, or BMP image.
• Add a new worksheet – Creates an empty worksheet within the specified workbook.
• Add a background to a worksheet – Applies a background image to the chosen worksheet.
• Sort data in a worksheet – Sorts rows or columns based on defined criteria.
• Hide a worksheet – Makes the selected worksheet invisible without deleting it.
• Unhide a worksheet – Restores visibility to a previously hidden worksheet.
• Move a worksheet – Changes the position of a worksheet within the workbook.
• Calculate a worksheet formula – Evaluates formulas in the worksheet and returns the results.
• Copy a worksheet – Duplicates an existing worksheet into the same or another workbook.
• Rename a worksheet – Changes the name of an existing worksheet.
• Update worksheet properties – Modifies properties such as tab color, visibility, and protection settings.
• Set worksheet zoom – Adjusts the zoom level for the worksheet view.
• Freeze panes in a worksheet – Locks rows and/or columns so they remain visible while scrolling.
• Unfreeze panes in a worksheet – Removes any existing pane‑freezing settings.
• Delete a worksheet – Removes the specified worksheet from the workbook.
• Delete a worksheet background – Removes the background image from a worksheet.
• Autofit a worksheet – Automatically adjusts column widths and row heights to fit the content.