in reply to Re: Appending data into an Excel Sheet
in thread Appending data into an Excel Sheet

Thank you Martin.
Ya I am new to Monastery. At a glance I saw PerlMonks FAQ.

I read that article already, in that article we are creating new Excel sheets(books). But I need data to be append on the some of excel sheet in the work book. I can preserve the name of work book by giving same name to the destination file name, but I am loosing all the graphs available on the remaining sheets of work book.

Thanks

Sudhakara
  • Comment on Re^2: Appending data into an Excel Sheet

Replies are listed 'Best First'.
Re^3: Appending data into an Excel Sheet
by marto (Cardinal) on Feb 28, 2008 at 10:51 UTC
    Had you read rather than glanced at the PerlMonks FAQ and How do I post a question effectively? you may realised that you could do a lot to help us help you. You have not given us a lot of information. For example you fail to mention which operating system you are using? If it is Microsoft Windows you should be able to use Win32::OLE to control Excel (see Re: Excel VB Controls for some useful links on this topic).

    Again, a super search would have shown this method of manipulating Excel.

    Martin
[reply]

In Section Seekers of Perl Wisdom