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
    VIP
    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
      VIP
      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 ?

       

      Save%20Range%20vs%20Load%20Excel
      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