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

Posted on 2007-10-18
Last Modified: 2013-12-05
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
Question by:steelspy
    LVL 10

    Expert Comment


    Author Comment

    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...
    LVL 10

    Accepted Solution

    Reading and writing Excel files with Perl

    WriteExcel - Writing into existing file

    This time I found only the above referencies
    wbr Janos

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    FreeBSD on EC2 FreeBSD ( is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now