Couldn't Open workbook , Excel Error (inside JSReport only)
-
Hi, im using the JSReport on the server , and i've noticed that some of the
excel
files are not working in the JSReport. For example i havedemo Excel
file . Which has some calculations and other chart stuff.
If i upload this demo excel inside theJSReport
and hitrun
i'll get the error thatCouldn't Open workbook We're sorry, we couldn't open your workbook. It's possibly corrupt or using a file format that's not supported.
But the same excel file is running fine in the
Excel Online
also . Even the file is stored withxlsx
extension inside jsreport server.So wanted to know whats causing this
Excel online inside JSReport
to stop loading the excel or stop opening the Excel fileAny ideas !
-
Could you please upload here or somewhere the mentioned excel template file?
-
@jan_blaha
Hi , here it is
https://playground.jsreport.net/w/A-Pradeep/P7YQXJmzThe template linked is the general excel template from the office , even this also not working.
-
This issue solved in the update of
npm i jsreport-xlsx@2.0.6 --save --save-exact
thanks to @jan_blaha