Hi Brendan I assume you're running your script on a Windows machine? Have you considered connecting to the spreadsheet(s) via an ADO database driver and simply editing the data via recordsets?
Todd. > Good morning, > > I am working on a project that requires the following: > > 1. Open existing .xls Excel spreadsheet (which contains macros) > 2. Modify some basic cell data. > 3. Save / export the new file while containing the original macros. > > The macros are NOT modified, they just need to be maintained when > creating a new file. > > I have googled this and tried PHPExcel library, and have managed to > open the file, modify with basic cell data, and then export, however > the macros are lost. > > Wonder if anyone has found a solution out there (paid / free) that can > help me. > > Much Appreciated > Brendan. > -- *Passion* is no substitute for *reason* -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
