How many worksheets can be created in an Excel workbook for automation testing?

excel selenium junit apache-poi data-driven-tests
MKod picture MKod · Mar 13, 2013 · Viewed 73k times · Source

I am working on a data driven framework for automating test cases. I use Selenium with Java, Junit, Apachi-Poi etc to create and run my test cases.

Each sheet contains data that I will use for a class (or for a testcase). So now, if I create N testcases then there should be N sheets in a workbook. But I need to know how many sheets can be created in an Excel workbook.

Answer

John Bustos picture John Bustos · Mar 13, 2013

... It depends on the Excel version, but 2007 +, there is no limit other than the amount of available memory:

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx#BMworksheetworkbook

Related questions

Handling excel spreadsheets with Cucumber Scenario Outline

I am trying to see, if possible, to have a more elegant way to handle calling nTh numbers from a Cucumber Scenario Outline that correlates to an excel spreadsheet row(nth). Currently I am using iteration numbers to define the …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More