The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

darpan13's avatar
darpan13
Contributor
4 years ago

Load Excel data into Custom Table Code - Failing

SOURCE: ONESTREAM CHAMPIONS     Hi Team, I am facing a typical issue ( Error Msg 1) while uploading the data from an excel. where as the code for csv upload works fine. Refer the Code attached ...
Excel Add In
darpan13's avatar
darpan13
Contributor
4 years ago

 

  • MarcR's avatar
    MarcR
    Contributor II
    4 years ago

    Hi Darpan,

    the variable tbRangeContent is not a string and that is what the logmessage needs. you can simply add .tostring after the tbRangeContent in the brapi and it will convert its contents to a string and show to you in the error log.

    • MarcR's avatar
      MarcR
      Contributor II
      4 years ago

      Hi Marc,

      Point noted , it worked partially, it removed the error , but all the excel data records were not displayed in Error Message ( where we intend to log them )

      Also 1 more question - is there any difference between the two functions mentioned in below screenshot ?

       

      https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/ba10023887f5d9100149c9980b3fb6af6840765c.jpeg
      Save Range vs Load Excel.jpg783×71 15.2 KB

       

      i could see in both the cases data is being saved.

      Regards

      Darpan Bhansali

      • darpan13's avatar
        darpan13
        Contributor
        4 years ago

        Thanks Marc for the honest response 

         

         

        i will try to read some more documents and dig further into the same, will update here, if got a chance to find the difference.

        Regards

        Darpan