Forum Discussion

mpatel1's avatar
mpatel1
New Contributor
2 years ago

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
Spreadsheet
XFBR
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

Adding to SeanV 's suggestion for parsing your file, here's some code to help get you started getting a file into your rule to parse it:

Dim objXFFileEx As XFFileEx = BRApi.FileSystem.GetFile(si, FileSystemLocation.ApplicationDatabase, fileFullName, includeContentFileBytes, failGracefully)
Dim folderName As String = objXFFileEx.XFFile.FileInfo.FolderFullName 'Just an attribute
Dim bytes As Byte() = objXFFileEx.XFFile.ContentFileBytes