perl problem in processing excel file Post: 302622543

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

PERL - [B]Cloning[/B] an Excel file

Hi I plan to read an excel file (using Spreadsheet::ParseExcel) and create a clone of it with some other name (using Spreadsheet::WriteExcel). I am able to get the skeleton by reading cells in every pair of every worksheet. But I am not able to get the format string of these cells. I want the...

2. Shell Programming and Scripting

File processing on perl

Hey everyone ... I wanted to process the contents of a file, as in modify its contents. whats the best way to do it on perl? In more detail I hav to go through the contents of the file, match patterns n then modify the contents of the same file depending on the matching results. Any help is...

3. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create...

4. Shell Programming and Scripting

Problem sending excel attachments with MIME::Lite in perl

I am running a perl script that generates an excel doc and then emails it as an attachment. I can generate the excel file fine. I can scp it from the box and open it with no problems. When I send it over email, the file does open properly. The file in email is only 288 B, but on the server it is...

5. Shell Programming and Scripting

Processing a file in perl

Qspace ABC Queue doCol: true Queue order: fifo Queue setCol: red Queue order: fifo Qspace XYZ Queue getCol: true Queue order: fifo I need to append every line in this file with Qspace & Queue, so that final o/p shall look like this, Qspace: ABC Queue: doCol Qspace: ABC Queue: doCol...

6. Shell Programming and Scripting

Perl file processing

I have an input array like : "SVR1" GRP="EVT_BOX06B" SRID=100 MIN=2 "SVR1" GRP="EVT_BOX06B" SRID=200 MIN=1 "SVR2" GRP="ADM_BOX06B" SRID=100 MIN=1 "SVR1" GRP="EVT_BOX88B" SRID=100 MIN=2 "SVR1" GRP="EVT_BOX88B" SRID=200 MIN=1...

7. Shell Programming and Scripting

Perl script to sort an Excel file

Hello! I need to sort a file that is partly in English partly in Bulgarian. The original file is an Excel file but I converted it to a tab-delimited text file. The encoding of the tab delimited file is UTF-8. To sort the text, the script should test every line of the text file to see if...

8. Shell Programming and Scripting

creating excel file using perl

Hi , I am writing a simple excel file and want to create the file under say 'D:\Documents and Settings'. The problem with my code is it is writing in the same directory instead of the specified. Here is a sample code use Spreadsheet::WriteExcel; my $workbook =...

9. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please...

10. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a...

LEARN ABOUT DEBIAN

derivations

DERIVATIONS(7)						Derivations of Applied Mathematics					    DERIVATIONS(7)

NAME

       derivations - book: Derivations of Applied Mathematics

DESCRIPTION

       Understandably,	program sources rarely derive the mathematical formulas they use.  Not wishing to take the formulas on faith, a user might
       nevertheless reasonably wish to see such formulas somewhere derived.

       Derivations of Applied Mathematics is a book which documents and derives many of the mathematical formulas and methods implemented in  free
       software  or used in science and engineering generally.	It documents and derives the Taylor series (used to calculate trigonometrics), the
       Newton-Raphson method (used to calculate square roots), the Pythagorean theorem (used to calculate distances) and many others.

READING THE BOOK

       Among other ways, you can read the book on your computer screen by opening the file /usr/share/doc/derivations/derivations.ps.gz  with  the
       gv(1) program under X(7).  To print the book on a standard postscript printer, just zcat(1) then lpr(1) the same file.

FILES

       /usr/share/doc/derivations/derivations.ps.gz
	      the book in postscript format
       /usr/share/doc/derivations/derivations.pdf.gz
	      the book in PDF

BUGS

       The book is a work in progress.

AUTHOR

       The  book  and  this manpage are written by Thaddeus H. Black, who also maintains the Debian package derivations in which they are distrib-
       uted.  Users who need to contact the author in his role as Debian package maintainer can reach him at <thb@debian.org>.	However,  most	e-
       mail will naturally be about the book itself: this should be sent to <thb@derivations.org>.

COPYLEFT

       Copyright (C) 1983-2010 Thaddeus H. Black.

       The  book,  this manpage and the entire derivations distribution are free software.  You can redistribute them and/or modify them under the
       terms of the GNU General Public License, version 2.

SEE ALSO

       gv(1) [gv], zcat(1) [gzip], psselect(1) [psutils], lpr(1) [lpr], octave(1) [octave]

Thaddeus H. Black						   10 March 2010						    DERIVATIONS(7)