Worksheet in React Spreadsheet component
10 Jul 20261 minute to read
A Worksheet is a collection of cells organized in rows and columns. It allows you to store, format, and manipulate data efficiently within the Spreadsheet. Each worksheet provides a structured grid where you can enter values, apply formulas, and customize formatting to manage your data.
Worksheets are part of the Spreadsheet component, and you can configure them using the sheets property. This property lets you define multiple worksheets, each with its own settings such as rows, columns, data, and formatting options.
By using worksheets, you can:
- Organize data into separate tabs for better clarity.
- Apply different formatting styles to each sheet.
- Manage formulas and calculations independently across sheets.
- Import or export data while maintaining sheet-level configurations.
Overview of Worksheet Management Operations
The React Spreadsheet component offers several worksheet management features to help you organize and customize your workbook. Here is a brief explanation of each feature, with links to their documentation:
- Insert Sheet: Add a new worksheet to your workbook, allowing you to expand and organize your data as needed.
- Delete Sheet: Remove an existing worksheet from your workbook when it is no longer required.
- Rename Sheet: Change the name of a worksheet to make it more descriptive or meaningful.
- Duplicate Sheet: Create an exact copy of a worksheet, including its data and formatting.
- Move Sheet: Rearrange the order of worksheets within your workbook for better organization.
- Sheet Visibility: Show or hide specific worksheets to control what is visible to users.
- Headers and Gridlines: Display or hide row and column headers and gridlines to customize the worksheet view.
Note
You can refer to our React Spreadsheet Editor feature tour page for its groundbreaking feature representations. You can also explore our React Spreadsheet example to knows how to present and manipulate data.