|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Writing xml from excel sheet .xls using perl script
Post 302935012 by omkar.jadhav on Thursday 12th of February 2015 10:58:09 AM
02-12-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is there any possibility to move the content from one cell to another cell (Excel sheet) using perl module? (3 Replies)
Discussion started by: kavi.mogu
3 Replies
2. Shell Programming and Scripting
I need to insert new column to already existing file ..can any one help me..?? (6 Replies)
Discussion started by: kavi.mogu
6 Replies
3. Shell Programming and Scripting
Hi , Is there any possibility to read excel sheet in column by column order ?...Thanks in advance,........ :confused: (1 Reply)
Discussion started by: kavi.mogu
1 Replies
4. Programming
Hi ,
can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ???
Example_pgm:
Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to... (0 Replies)
Discussion started by: kavi.mogu
0 Replies
5. Shell Programming and Scripting
Hi folks,
I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month.
If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies
6. Shell Programming and Scripting
I have a excel sheet with contains the records as below..
also uploaded the input excelsheet and the output excel sheet(expected output).
322mpls32.net.xyz.comBW: 44.0 M Hrly Avg (IN /... (1 Reply)
Discussion started by: giridhar276
1 Replies
7. Shell Programming and Scripting
There is a perl scriptwhich will read Excel sheet and create one file(.v) .
Excel sheet:::
A B C D
1 cpu_dailog 2 3 4
Perl will create the file(.v) like thsi :::
assert (cpu_dailog_iso ==2) ;
assert (cpu_dailog_reset ==3);
assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies
8. Shell Programming and Scripting
Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies
9. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
10. Shell Programming and Scripting
Hello,
I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas
Example:
Report Date,12/12/2014
Report By, Person
Issue, Job Failed
I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single... (6 Replies)
Discussion started by: annamalaikasi
6 Replies
LEARN ABOUT OSX
datetime::timezone::local::win32
DateTime::TimeZone::Local::Win32(3) User Contributed Perl Documentation DateTime::TimeZone::Local::Win32(3) NAME
DateTime::TimeZone::Local::Win32 - Determine the local system's time zone on Windows VERSION
version 1.51 SYNOPSIS
my $tz = DateTime::TimeZone->new( name => 'local' ); my $tz = DateTime::TimeZone::Local->TimeZone(); DESCRIPTION
This module provides methods for determining the local time zone on a Windows platform. HOW THE TIME ZONE IS DETERMINED
This class tries the following methods of determining the local time zone: o $ENV{TZ} It checks $ENV{TZ} for a valid time zone name. o Windows Registry When using the registry, we look for the Windows time zone and use a mapping to translate this to an Olson time zone name. o Windows Vista and 2008 We look in "SYSTEM/CurrentControlSet/Control/TimeZoneInformation/" for a node named "/TimeZoneKeyName". If this exists, we use this key to look up the Olson time zone name in our mapping. o Windows NT, Windows 2000, Windows XP, Windows 2003 Server We look in "SOFTWARE/Microsoft/Windows NT/CurrentVersion/Time Zones/" and loop through all of its sub keys. For each sub key, we compare the value of the key with "/Std" appended to the end to the value of "SYSTEM/CurrentControlSet/Control/TimeZoneInformation/StandardName". This gives us the English name of the Windows time zone, which we use to look up the Olson time zone name. o Windows 95, Windows 98, Windows Millenium Edition The algorithm is the same as for NT, but we loop through the sub keys of "SOFTWARE/Microsoft/Windows/CurrentVersion/Time Zones/" AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Dave Rolsky. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.16.2 2012-10-17 DateTime::TimeZone::Local::Win32(3)