Search code examples
genexus

Genexus 18 .net read exceldocument from blobfile

I need to read an Excel spreadsheet to input the data into another process. The Excel file is already in the database in blobfile format. When I try to open it, it appears blank. An example I tried:

&ExcelDocument.Open(ExcelBlobfile.FileURI)

It seems like I'm not reading the binaries correctly. Any suggestions?

Solution

  • You could try adding a variable &File data type File and do:

    &File.Source = ExcelBlobfile.FileURI
&ExcelDocument.Open(&File.GetURI())