I have a multisheet workbook that I want to update on a daily basis.
There are several sheets with pivottables that refer to the sheet I want to update.
We generate the data on a UNIX server.
I have PERL installed on the server, and we've tried parse excel and write excel.
Neither have produced the results we want.
It appears WriteExcel works when writing to a new workbook, but doesn't want to write to an existing workbook.
Parse Excel trounces my pivot tables that I have set up on other sheets of the existing workbook.
My goal, is to update the workbook, and be able to email it to a group of users, who can then opn the workbook and see the results of the updated data.
I'm not the programmer who has been handling this. So I have to take the programmers word on the failings of writeexcel and parseexcel.
Any suggestions would be great.