07-30-2009
1. I think you might want to read some perl documentation or a perl book - most especially if this is something you are doing for your work.
2. my $var = sprintf("%.3f", 12.123456);
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear friends,
please help me to solve following problem.
I'm running a frontend application from which i'll be invoking the shell script with arguments as given below
-driver -w -p "ABC XYZ" -S -ds con -dn "abc xyz"
i am getting
$1=-driver
$2=-w
$3=-p
$4="ABC
$5=XYZ"
$6=-S
$7=-ds... (3 Replies)
Discussion started by: swamymns
3 Replies
2. Shell Programming and Scripting
In a shell script - How do I round a decimal number (contained in a variable) to the nearest whole number? (2 Replies)
Discussion started by: achieve
2 Replies
3. Shell Programming and Scripting
Hi Friends,
I am new to this forum as well as new to shell scripting.
I have a problem here and i need someone to solve this.
Let us consider there are two processes(abc & def).There is a script which kills these two processes(i.e killtheprocess abc). Here abc is the argument .
There... (0 Replies)
Discussion started by: Prince89
0 Replies
4. Shell Programming and Scripting
Hi All,
Can anybody help me to write the umbrella script for the following?
I have three steps to do.
STEP 1: CONVERT XML files to PS files
STEP 2: CONVERT ALL PS FILES TO PDF FILES
STEP 3: FTPING ALL PDF FILES TO THE SERVER.
I have the codes for the above three steps.
Now I... (6 Replies)
Discussion started by: sunitachoudhury
6 Replies
5. Shell Programming and Scripting
Hello All,
Can someone help me to set a user's password from the script using korn shell. The password change is a one time password after user account creation.
I tried providing the input file as the value for password field but password change requires tty so my password from an input file... (3 Replies)
Discussion started by: solaix14
3 Replies
6. Shell Programming and Scripting
Hey everyone, I was wondering if i am able to write a sed command to round a number to two decimal places. So for example:
1.58674
would be
1.58
I just want to chop off the numbers to the right of the second digit after the period. I know this is probably trivial but the closest i got was... (8 Replies)
Discussion started by: GmGeubt
8 Replies
7. Shell Programming and Scripting
From the attached file I to need pick all rows that have AVG2 column value larger than 0.050, and write those values in to a separate file. Help me on how I pick the approp value & output them onto a file.
Very Thanks in advance. :b: (5 Replies)
Discussion started by: tonystark
5 Replies
8. Shell Programming and Scripting
Hi Guys,
i am having a csv file where i need to round off numerical column to 2 decimal precision in specific columns. i need to ignore the first two line i.e the header columns and manipulate rest of the lines of the csv file. My columns are specific i.e i need to round off only 2nd,4th and... (13 Replies)
Discussion started by: rohit_shinez
13 Replies
LEARN ABOUT DEBIAN
spreadsheet::parseexcel::simple
Spreadsheet::ParseExcel::Simple(3pm) User Contributed Perl Documentation Spreadsheet::ParseExcel::Simple(3pm)
NAME
Spreadsheet::ParseExcel::Simple - A simple interface to Excel data
SYNOPSIS
my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');
foreach my $sheet ($xls->sheets) {
while ($sheet->has_data) {
my @data = $sheet->next_row;
}
}
DESCRIPTION
This provides an abstraction to the Spreadsheet::ParseExcel module for simple reading of values.
You simply loop over the sheets, and fetch rows to arrays.
For anything more complex, you probably want to use Spreadsheet::ParseExcel directly.
BOOK METHODS
read
my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');
This opens the spreadsheet specified for you. Returns undef if we cannot read the book.
sheets
@sheets = $xls->sheets;
Each spreadsheet can contain one or more worksheets. This fetches them all back. You can then iterate over them, or jump straight to the
one you wish to play with.
book
my $book = $xls->book;
The Spreadsheet::ParseExcel object we are working with. You can use this if you need to manipulate it in ways that this interface doesn't
allow.
SHEET METHODS
These methods can be called on each sheet returned from $xls->sheets:
has_data
if ($sheet->has_data) { ... }
This lets us know if there are more rows in this sheet that we haven't read yet. This allows us to differentiate between an empty row, and
the end of the sheet.
next_row
my @data = $sheet->next_row;
Fetch the next row of data back.
sheet
my $obj = $sheet->sheet;
The underlying Spreadsheet::ParseExcel object for the worksheet. You can use this if you need to manipulate it in ways that this interface
doesn't allow (e.g. asking it for the sheet's name).
AUTHOR
Tony Bowden
BUGS and QUERIES
Please direct all correspondence regarding this module to:
bug-Spreadsheet-ParseExcel-Simple@rt.cpan.org
COPYRIGHT AND LICENSE
Copyright (C) 2001-2005 Tony Bowden.
This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License; either version 2 of the License,
or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE.
SEE ALSO
Spreadsheet::ParseExcel.
perl v5.8.8 2008-03-12 Spreadsheet::ParseExcel::Simple(3pm)