• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

How do I write data to an existing excel workbook on a UNIX server?

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.

Thank You
0
steelspy
Asked:
steelspy
  • 2
1 Solution
 
kacorretiredCommented:
0
 
steelspyAuthor Commented:
Well, it has been two weeks and no luck.

Best I could come up with is to have the pivot table workbook open the perl generated workbook.

Not the solution I was really looking for...
0
 
kacorretiredCommented:
Reading and writing Excel files with Perl
http://www.ibm.com/developerworks/library/l-pexcel/

WriteExcel - Writing into existing file
http://www.thescripts.com/forum/thread692005.html

This time I found only the above referencies
wbr Janos
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now