Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

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.

Comments

  • benken_parasoft
    benken_parasoft Posts: 1,228 ✭✭✭

    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!