Skip to main content
D
darpan13
Newcomer
January 12, 2022

Load Excel data into Custom Table Code - Failing

  • January 12, 2022
  • 1 reply
  • 0 views

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

    1 reply

    D
    darpan13Author
    Newcomer
    January 12, 2022

    e5e115f2a4b02fda6ff77cfc0ebe425ee1981479.jpg

     

      M
      MarcR
      Contributor
      January 12, 2022

      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.

        M
        MarcR
        Contributor
        January 12, 2022

        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

          Terms & ConditionsAccessibility statement