Not able to load Excel file from serve to Spreadsheet

[Fnu Monisha]

Hello,

I am unable to fetch a file from the server and load it into a spreadsheet using the open function.

My API returns a blob and I have followed the steps listed at https://www.syncfusion.com/forums/152140/open-remote-excel-file - used my own API to fetch the FileStream instead of a direct fetch call.

It seems like the open function is making another "fetch" which is failing (as observed in the network log).

Please help.

Thanks and regards,

Monisha

[Madhan Venkateshan]

Hi Fnu Monisha, 

 

Good day to you 

 

We have prepared a sample to directly read stream using XlsIO and use the ‘openFromJson’ method in client side to open the excel file from stream with single fetch. Please refer the below code snippets and sample link. 

 

openFromServer(){ 

       fetch("http://localhost:55367/Home/OpenFromServer").then((response) => { 

            response.json().then((data) => { 

                this.spreadsheetObj.openFromJson({ file: data }); 

            }); 

        }); 

    } 

 

public string OpenFromServer() 

        { 

            ExcelEngine excelEngine = new ExcelEngine(); 

            IWorkbook workbook; 

            FileStream fs = System.IO.File.Open("./wwwroot/Sample1.xlsx", FileMode.Open); // converting excel file to stream 

            workbook = excelEngine.Excel.Workbooks.Open(fs, ExcelOpenType.Automatic); // coverting stream to XlsIO workbook 

            MemoryStream outputStream = new MemoryStream(); 

            workbook.SaveAs(outputStream); 

            IFormFile formFile = new FormFile(outputStream, 0, outputStream.Length, "", "Sample1.xlsx"); // converting MemoryStream to IFormFile 

            OpenRequest open = new OpenRequest(); 

            open.File = formFile; 

            fs.Close(); 

            return Workbook.Open(open); // Return Spreadsheet readable data 

        } 

 

Sample link: https://stackblitz.com/edit/angular-cbgzml-71y4mr?file=app.component.ts 

 

Service link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SSLoadFromServerAngular2827343808 

 

Regards, 

Madhan V 

[Fnu Monisha]

Hello,

Thank you for your response.

The provided code is not working for .xlsm files. We need to load macro-enabled worksheets and save them as .xlsm files as well.

Please confirm if this feature is available.

Regards,

Monisha

[Madhan Venkateshan]

Hi Fnu Monisha, 

 

Good day to you. 

 

We would let you know that we do not have support to load macro enabled worksheet. 

 

Regards, 

Madhan V