The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Perl - Appending/Modifying Excel files Perl - Appending/Modifying Excel files
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Adding columns to excel files using Perl dolo21taf Shell Programming and Scripting 1 02-20-2008 07:13 AM
modifying grep to get files only within last 2 hrs ragha81 Shell Programming and Scripting 3 01-11-2007 07:11 PM
appending to perl array vivekshankar UNIX for Dummies Questions & Answers 7 06-03-2006 10:33 PM
PERL - [B]Cloning[/B] an Excel file srinivay Shell Programming and Scripting 5 01-11-2005 09:51 AM
How can I ... (Modifying large ASCII files) hviktor UNIX for Dummies Questions & Answers 2 07-20-2001 10:28 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 01-10-2005
srinivay srinivay is offline
Registered User
  
 

Join Date: Nov 2004
Posts: 10
Thumbs up Perl - Appending/Modifying Excel files
Hi

I have been using Spreadsheet::ParseExcel and Spreadsheet::WriteExcel to read and write excel workbooks, respectively.

Spreadsheet::WriteExcel can only be used for creating new excel spreadsheets. I am looking for a module that would/should help me in appending to existing excel files. Adding new rows to the existing worksheets of an excel file is one such typical requirement of mine.

I tried searching in http://search.cpan.org and came across Spreadsheet::ParseExcel::SaveParser which is supposed to be an integration of ParseExcel and WriteExcel. But this does not help me either.

Could someone help me out here?

Thanks,
Yuga
  #2 (permalink)  
Old 01-10-2005
google's Avatar
google google is offline Forum Advisor  
Moderator
  
 

Join Date: Jul 2002
Location: Atlanta
Posts: 740
From the IBM site discussing Spreadsheet modules:
Quote:
The bad news is that Spreadsheet::WriteExcel can not be used to write to an existing Excel file. You have to import data from an existing Excel file yourself, using Spreadsheet::ParseExcel. The good news is that Spreadsheet::WriteExcel is compatible with Excel 5 up to Excel 2000.
Click Here for more information regarding these modules from IBM. There are some additional links at the bottom of this page that may provide additional information, tips, tricks etc.
  #3 (permalink)  
Old 01-10-2005
srinivay srinivay is offline
Registered User
  
 

Join Date: Nov 2004
Posts: 10
Hey google,

Thanks for the response!
Closed Thread

Bookmarks

« awk question | formatting output in human readable numbers »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 04:13 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0