Create a Function to read data from excel file in local file system Using BR api
I want to read a list of members from a excel file which is store in OS file system and store that list of member ID in a list to perform further calculation
Forum Discussion
I did something similar using a dashboard extender rule to get a file from a file share folder and load it to a custom table. I know you are not trying to load to a custom table. (I used BRApi.Utilities.LoadCustomTableUsingDelimitedFile)
However BRApi.Utilities.GetFileShareFolder will grab the path of the file
then maybe BRApi.Utilities.ReadExcelTableRangeContent ? will get the contents? sounds promising, might be worth a look.