How many worksheets can be created in an Excel workbook for automation testing?
... It depends on the Excel version, but 2007 +, there is no limit other than the amount of available memory:
The number of sheets (tabs) is only limited by the available memory you have available. To see information about this (and various other Excel limits) follow these five steps:
- Ensure you are in an activate session of Excel and press F1
- Enter "Excel limits" in the Type a question for help text box and press Enter
- From the Search Results window, click on the Excel specifications and limits hyperlink
- Show (expand out) the Worksheet and workbook heading
- Under the Feature field, refer to the Sheets in a workbook heading