Opening an excel document fails

[Omar]

Hello,

When I try to open the attached document it keeps loading forever and doesn't load the spreadsheet.

Please notice that I'm using the following snippet to open the spreadsheet:

        public ActionResult GetExcel(CustomParams param, int id)

        {

            HttpPostedFileBase formFile = new MemoryPostedFile(ConvertStreamToBytes(param.fileStream), param.FileName, "xlsx");

            OpenRequest openRequest = new OpenRequest();

            var postedFile = new HttpPostedFileBase[1] { formFile };

            openRequest.File = postedFile;

            

            return Content(Workbook.Open(openRequest)); // this line takes too long to open the spreadsheet

        }

The thing is other documents open but take a lot of time on the last line.
But for the attached document it just keeps loading forever.

Please help with this as soon as possible.

Thanks,

Attachment: Test_d5c386d8.rar

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported issue based on your provided excel file and we would let you know that, in this excel file used range contains larger number of cells (A:XFD) and you have applied the merge cells from E18 to XFD18 range. So, it takes some time to load this excel file, but the data available only in the A1:D42 range. if you don’t need this you can remove the merge and unused ranges in your end. Or else please share the details regarding, why you have used such larger empty range and mergecells in your end.  Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M