Ask a Question

DDT Excel Driver does not read past 256 rows

Mpeterson
Occasional Contributor

DDT Excel Driver does not read past 256 rows

I am using the DDT excel driver and I noticed when I have a lot of options to check ( in my case, 815 checkboxes ) After a certain point ( I think 256 columns ) I get the Cannot find ordinal error. if I move the columns over to the left it reads just fine, so there seems to be a limitation. I a using excel 2007, I saved files as both xls and xlsx to no avail.

So my question is it there a limitation? Is there a work around ( I would like to have a thousand columns or so)?

Should I switch to a SQL database ( I assume that would be a lot of work, to rethink my flow, as I expect to walk though a excel sheet to do one test after another, not queries)

Other options ? multiple sheets in the same excel book? Can I stay on the same row and move from sheet to sheet to keep it all in line ( my test definitions are one row and around 900 cells across)



Thanks for your help,

Mark

1 REPLY 1
AlexKaras
Community Hero

Hi Mark,



256 columns by 65,536 rows is an internal Excel limit.

http://office.microsoft.com/en-us/excel-help/row-height-and-column-width-limits-in-excel-HA010137545...

http://support.microsoft.com/kb/272729

http://www.google.com/search?hl=en&source=hp&q=Excel+256+column
Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================
cancel
Showing results for 
Search instead for 
Did you mean: