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

      • ckattookaran's avatar
        ckattookaran
        Valued Contributor
        4 years ago

        I dont think there is a difference in operation. They both do the same thing. One does it by reading the fields from EXCEL, the other one you are providing the fields tokens. I’m in the process of creating a 3 part video series that explains how LoadCustomTableUsingDelimitedFile works.