Forum Discussion

royari's avatar
royari
Contributor
3 years ago

Unable to load from Excel file to custom table

I have created an extender BR to load from a  xlsx file with xft named range into a custom table. The file is in the OS cloud fileshare in a specific folder. I am 100% sure the file is set up correct...
Admin
Extenders
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    Try this one. You need to provide where the share folder is, which was missing from the previous code.

    Dim fileName As String = "XFD_Plan1.xlsx" '<-- Enter name of Excel file
Dim filePath As String = BRApi.Utilities.GetFileShareFolder(si, FileShareFolderTypes.BatchHarvest, Nothing) '<-- Enter path to Excel file
BRApi.Utilities.LoadCustomTableUsingExcel(si, SourceDataOriginTypes.FromFileShare, filePath & fileName, Nothing)

      

ckattookaran's avatar
ckattookaran
VIP
3 years ago

Try this one. You need to provide where the share folder is, which was missing from the previous code.

Dim fileName As String = "XFD_Plan1.xlsx" '<-- Enter name of Excel file
Dim filePath As String = BRApi.Utilities.GetFileShareFolder(si, FileShareFolderTypes.BatchHarvest, Nothing) '<-- Enter path to Excel file
BRApi.Utilities.LoadCustomTableUsingExcel(si, SourceDataOriginTypes.FromFileShare, filePath & fileName, Nothing)