search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

Issue in PHPExcel #1286

Open CharuSaklecha opened 6 years ago

CharuSaklecha commented 6 years ago

aexplusdd Trying to access an excel workbook through a web page. Basically, I have a .xlsx excel workbook (converted from a .xlsm file which has no macros, as PHPExcel doesn't support .xlsm files) which has many sheets all connected to each other through VLOOKUPS. There are two steps I am performing-

  1. I am trying to insert certain values which then perform calculations by using pre-fed formulas in the sheets, then save the file to reflect the changes.
  2. Again I loaded the excel workbook, then tried to fetch the relevant output (depending on all the sheets). Up to step 1, everything works fine, it is saving the file with new values and it works. But don't know why it is not loading the file back and echoing the results on the web page. Really appreciate the help. Thank you.