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.

Excel sheet problem

LegacyForum
LegacyForum Posts: 1,664 ✭✭
in Ask a Question
Dear SOATest Support Team,

I have a problem with the excel datasource. I'm trying to set a little bit large excel file, and SoaTest can't read it. I enclose the file could you check it? Thank You.

Best Regards,
Norbert

Comments

  • LegacyForum
    LegacyForum Posts: 1,664 ✭✭
    Hello Norbert,

    SOAtest uses a third-party API to interface with Excel files, which cannot handle complex calculations in an Excel document. For example, in the "end2endinput" sheet, the "... select" columns cannot be handled by the third-party parser. If you delete those columns, you will be able to use the excel file as expected.

    A workaround for this is to copy/paste the data needed into a regular SOAtest table datasource. This way, you will hopefully be able to continue your tests without too much disturbance. If not, please let me know what data you need from the excel file, as well as the testing circumstances, so that I can provide you with a better solution to this issue.

    Regards,
    Joseph
  • LegacyForum
    LegacyForum Posts: 1,664 ✭✭
    Hello Joseph,

    Thank you for help, I could modify the excel to be readable for the SoaTest.

    Regards,
    Norbert

Categories