0

I am trying to edit my existing .xls Excel file. But i can't find the proper way to edit existing .xls excel file.

I had used PHPEXCEL for reading the .xls file and then writing the .xls file. But in that I lost some excel functionality like 'macro', 'vb form' from existing .xls file.

In my case, I need to update my Excel file day by day. So currently I am using PHPEXCEL, first I need to read Excel then write it with a new record.

So I am finding the way to edit existing .xls file with my new record.

Please share your idea if you find.

Steve Fallows
  • 6,274
  • 5
  • 47
  • 67
Vijay Hirapara
  • 21
  • 6

1 Answers1

0

If you need support for macros and forms, then you're pretty limited in your choices. There's only 3 options available:

  • Ilia Alshanetsky's Excel extension now on github (requires commercial libXL component)
  • PHP's COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)
  • The Open Office alternative to COM (PUNO) (requires Open/Libre Office installed on the server with Java support enabled)
Mark Baker
  • 209,507
  • 32
  • 346
  • 385