Solved

How to automatically add columns to an existing excel file?

Posted on 2009-03-31
5
525 Views
Last Modified: 2012-06-27
In my excel table, the rows are features or parameters of devices, for example, device type, physical address, IP address, ....... The columns are different devices. one columns is for one device.

I need to extract these device information from configuration files using a Perl script and write in one existing excel table.  when using
while()  {
# write in data
}

from row 1, row 2, ...is easy.  using +1
but how to go from  column A,  column B,  column C,...?

If anybody wanna help me out, it would be greatly appreciated!
0
Comment
Question by:howruaz9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 2

Assisted Solution

by:jbmraja
jbmraja earned 200 total points
ID: 24036646
0
 

Author Comment

by:howruaz9
ID: 24115923
Thanks very much jbmraja

I try to use Spreadsheet::WriteExce, but it failed as below.

Can't locate Spreadsheet/WriteExcel.pm in @INC (@INC contains: C:/Perl/site/lib
C:/Perl/lib .) at xls1.txt line 4.
BEGIN failed--compilation aborted at xls1.txt line 4.



The line 4:  use Spreadsheet::WriteExcel;



0
 
LVL 39

Accepted Solution

by:
Adam314 earned 300 total points
ID: 24133539
You need to install that module.  If you are using the ActiveState distro, you can do so by running this:
    ppm install Spreadsheet::WriteExcel

If you are using a diff distro... which one are you using?
0
 

Author Comment

by:howruaz9
ID: 24134139
I'm using ActivePerl-5.10.0.1004-MSWin32-x86-287188

ppm install Spreadsheet::WriteExcel
ppm install Spreadsheet::ParseExcel

Both work very well.  Thanks so much Adam314!


0
 

Author Closing Comment

by:howruaz9
ID: 31565142
Adam314 and Jbmraja, I really appreciate your time, patience and kind help!
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

740 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