Thanks for your reply and suggestions.
when I run the script, I get:
and in dir which I run my scripts Ihave also:
- ActivePerl-5.16.1.1601-x86_64-linux-glibc-2.3.5-296175
- Spreadsheet-ParseExcel-0.2602
- Spreadsheet-WriteExcel-2.38
I dont know why still I get the Error.
Could you please help me out in n underestanding way?
Last edited by Scrutinizer; 12-20-2012 at 09:32 AM..
Reason: code tags
PROJECT: Extracting data from an employee timesheet. The timesheets are done in excel (for user ease) and then converted to .csv files that look like this (see color code key below):
,,,,,,,,,,,,,,,,,,,
9/14/2003,<-- Week Ending,,,,,,,,,,,,,,,,,,
Craig Brennan,,,,,,,,,,,,,,,,,,,... (3 Replies)
Folks,
I have a bit of an issue trying to obtain some data from a csv file using PERL. I can sort the file and remove any duplicates leaving only 4 or 5 rows containing data. My problem is that the data contained in the original file contains a lot more columns and when I try ro run this script... (13 Replies)
need to compare 2 csv files and report should containg number of matching lines,different lines ,missing lines in one file using perl.
I dont want to use read line by line and scan thru the second file for matching line ,as this logic was so time consuming .Any ideas.i need the soultion badly .... (2 Replies)
I need to compare 2 csv files and report should containg number of matching lines,different lines ,missing lines in one file using perl.
I dont want to use read line by line and scan thru the second file for matching line ,as this logic was so time consuming .Can other ideas .please respond asap... (2 Replies)
Hi
I have two csv files, with the following formats:
FileA.log:
Application, This occured blah
Application, That occured blah
Application, Also this
AnotherLog, Bob did this
AnotherLog, Dave did that
FileB.log:
Uk, London, Application, datetime, LaterDateTime, Today it had'nt... (8 Replies)
Hi Folks
Need some help with this and my Perl isnt the hottest I also have text::csv installed on my perl install
The large text with a few million entries is in a format below
example text file
Fig Leafs
Cake No: 0000001
Author: King s.
Record No: 995-34343-232-232... (5 Replies)
Hi All
How all are doing today. Just struck in an issue in Perl
I have a csv file which contain 32 column, I want to make sorting in that csv file with respect to 26th column.
Is it possible to do so without any module being added?
Regards
Aditya
---------- Post updated at 10:02 AM... (11 Replies)
I have a csv file like below.
john,r2,testdomain1,john.r2@hex.com,DOMAINADMIN,testdomain1.dom
maxwell,b2, testdomain1,maxwell.b2@hex.com,DOMAINADMIN,testdomain1.dom
I would need the perl script to read the above csv and create an xml like below.
<Users>
... (1 Reply)
Discussion started by: Tuxidow
1 Replies
LEARN ABOUT DEBIAN
excel::template::element::image
Excel::Template::Element::Image(3pm) User Contributed Perl Documentation Excel::Template::Element::Image(3pm)NAME
Excel::Template::Element::Image - Excel::Template::Element::Image
PURPOSE
To insert an image into the worksheet
NODE NAME
IMAGE
INHERITANCE
ELEMENT
EFFECTS
This will consume one column in the current row.
DEPENDENCIES
None
USAGE
<image path="/Some/Full/Path" />
<image path="/Some/Full/Path" offset="2,5" />
<image path="/Some/Full/Path" scale="2,0.4" />
<image path="/Some/Full/Path" offset="4,0" scale="0,2" />
Please see "" in Spreadsheet::WriteExcel for more information about the offset and scaling options as well as any other restrictions that
might be in place. This node does NOT perform any sort of validation upon your parameters. You are assumed to know what you are doing.
Note that the offset and scaling values are "X,Y". You must provide both values, even if the Y value is 0. If you provide a 0 value for
either scaling option, "" in Spreadsheet::WriteExcel will default that to 1.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
Nothing
perl v5.14.2 2010-06-17 Excel::Template::Element::Image(3pm)