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 here by for reference.

can any one help here to find what wrong am i doing in the below code.

Also i want to fetch the range selected somewhere in the error log… or the message box… how to achieve that ?

Also i could not find and XF Market place solution which enables this excel upload feature, Any guess on that as well.

Regards and Thanks

Darpan Bhansali

Excel Add In

7 Replies

    • 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