05-25-2009
Quote:
Originally Posted by
Harikrishna
... What my problem is i have to read the unicode characters from a excelsheet. ...
Yeah but you did not mention anything about an Excel spreadsheet in your original post.
Use the Win32::OLE perl module to read the Excel spreadsheet.
Check its cpan page for usage details.
Thanks,
tyler_durden
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need help with a perl parsing script. I have some error logs on a windows machine that I need to parse from a text file, but I know nothing about perl. I usually run this bash script on my linux box and it does just what I need. How would I do the same thing with perl and port it to my windows... (2 Replies)
Discussion started by: cstovall
2 Replies
2. Shell Programming and Scripting
i have a HTML report file..its in attachment(a part of the whole report is attached..name "input html.doc").also its source is attached in "report source code.txt"
i just want to seperate the datas like in first line it should be..
NHTEST-3848498958-NHTEST-10.2-no-baloo a
and so on for whole... (3 Replies)
Discussion started by: avik1983
3 Replies
3. Shell Programming and Scripting
I have the following script:
#!/usr/bin/perl -w
@files = <*.csv>;
foreach $file (@files) {
open(FH, $file);
my @dt = split(/_|.csv/, $file);
while (<FH>) {
chomp;
print $dt . $dt . ",$_\n";
}
close(FH);
}
This script reads in all csv files in the current directory... (2 Replies)
Discussion started by: figaro
2 Replies
4. Shell Programming and Scripting
#! /usr/local/bin/perl -w
$ip = "$ARGV";
$rw = "$ARGV";
$snmpg = "/usr/local/bin/snmpbulkget -v2c -Cn1 -Cn2 -Os -c $rw";
$snmpw = "/usr/local/bin/snmpwalk -Os -c $rw";
$syst=`$snmpg $ip system sysName sysObjectID`;
sysDescr.0 = STRING: Cisco Internetwork Operating System Software... (1 Reply)
Discussion started by: popeye
1 Replies
5. Programming
I have an extractfile (with fields delimited by pipes '|') and I want to prepend a counter based on the below requirements:
- The counter starts at 3.
- The counter increments only if the date (67th field of the extractfile) is different.
Below is what I started off with:
$cnt=2;... (3 Replies)
Discussion started by: ChicagoBlues
3 Replies
6. Shell Programming and Scripting
Hi Guys,
I have a large text file that is has a bunch of records. Each record starts with a header line that starts with the ">" character. Then there are several lines under that line that contain sequences of letters.
For example, a file might look like:
>TEXT ID=2L TEXT... (2 Replies)
Discussion started by: maverick.usb
2 Replies
7. Shell Programming and Scripting
I want to write a script that performs this type of behavior:
Example:
./Myscript.pl -a ARGUMENTRun code 'a'
./Myscript.pl -b ARGUMENT
Run code 'b'
Do I use a case statement, functions? I am new to perl, just a code template on how to achieve this would be great. (1 Reply)
Discussion started by: streetfighter2
1 Replies
8. Shell Programming and Scripting
in bash:
LIST=`cat $1`
for i in $LIST
do
...
done
how will i do this in perl ?
$1 is my first arguement. I'm a newbie in perl and will appreciate much your help guys ... (4 Replies)
Discussion started by: linuxgeek
4 Replies
9. UNIX for Advanced & Expert Users
Hello, I got a file like this.
5201
5202
5203
5204
1234
2345
3456
4567
6210
6220
6230
6240
The required output should be
5201 1234 6210 (9 Replies)
Discussion started by: suverman
9 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I need some guidance with understanding this Perl script below. I am not the author of the script and the author has not leave any documentation. I supposed it is meant to be 'easy' if you're a Perl or regex guru. I am having problem understanding what regex to use :confused: The script does... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::package::xmlwritersimple
Excel::Writer::XLSX::Package::XMLwriterSimple(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Package::XMLwriterSimple(3pm)
NAME
XMLwriterSimple - Light weight re-implementation of XML::Writer.
This module is used internally by Excel::Writer::XLSX.
DESCRIPTION
This module is used by Excel::Writer::XLSX for writing XML documents. It is a light weight re-implementation of XML::Writer.
XMLwriterSimple is approximately twice as fast as XML::Writer. This speed is achieved at the expense of error and correctness checking. In
addition not all of the XML::Writer methods are implemented. As such, XMLwriterSimple is not recommended for use outside of
Excel::Writer::XLSX.
If required XMLwriterSimple can be overridden and XML::Writer can be used in its place by setting an "_EXCEL_WRITER_XLSX_USE_XML_WRITER"
environmental variable:
export _EXCEL_WRITER_XLSX_USE_XML_WRITER=1
perl example.pl
Or for one off programs:
_EXCEL_WRITER_XLSX_USE_XML_WRITER=1 perl example.pl
This technique is used for verifying the test suite with both XMLwriterSimple and XML::Writer:
_EXCEL_WRITER_XLSX_USE_XML_WRITER=1 prove -l -r t
SEE ALSO
XML::Writer.
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
X MM-MMXII, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
LICENSE
Either the Perl Artistic Licence <http://dev.perl.org/licenses/artistic.html> or the GPL
<http://www.opensource.org/licenses/gpl-license.php>.
DISCLAIMER OF WARRANTY
See the documentation for Excel::Writer::XLSX.
perl v5.10.1 2012-04-02 Excel::Writer::XLSX::Package::XMLwriterSimple(3pm)