Datasource stop recognizing the Excel tabs when the 5th tab was added

I am using a single excel file as a datasource and have created multiple tabs in it to provide in SOATest datasource for different tests. It was working fine with 4 tabs. when I added 5th tab, Soatest stopped recognizing the tabs (Sheet) in data source. Is this known issue? anyone else have encountered it? could you please suggest a solution if I want to still use a single excel file.


  • benken_parasoftbenken_parasoft Posts: 809 ✭✭✭

    Works for me:

  • I found out the issue. There were special characters in few cells of the 5th tab (as a input to my test) but I had not formatted cell as a 'text', so it was regarding it as a formula or a link. once I formatted these cells as text (by adding single quote ' at the start) the tab was recognized by SOATest.

    Thank you for your inluts!

Sign In or Register to comment.