Create excel file from stream or from disk C/AL on prem

gatsby0121

I need to load an excel template file from a folder on the computer (or from a blob), modify some cells, then send this to the client machine, without modifying the original file, and without prompting the user to upload the file.

Currently I have it all working, except for the last part.

Is there a report somewhere that does this that I can use as a reference? Or better yet, a tutorial? I haven't been able to find anything as of yet.

txeriff

Hi,

So you have all but "without prompting the file?"

it depends how you've done it, I will assume you've used excel buffer table and it's functions.

this is the function that opens the excel file:

ExcelBuffer.OpenBook(FileName,SheetName);


just pass the folder and the sheet and thats it.

reading the rows and columns:

ExcelBuffer.LOCKTABLE;
ExcelBuffer.OpenBook(FileName,SheetName);
ExcelBuffer.ReadSheetIncBlanks;


CLEAR(ItemsNotFound);
ExcelBuffer.FINDSET;
REPEAT
  IF ExcelBuffer."Row No." > 1 THEN BEGIN
    CASE ExcelBuffer.xlColID OF
      'A' : BEGIN
              ItemFound := TRUE;
              IF NOT Item.GET(ExcelBuffer."Cell Value as Text") THEN BEGIN
UNTIL ExcelBuffer.NEXT=0;