|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Change the cell background in excel sheet using Perl
Post 302213135 by spufi on Wednesday 9th of July 2008 09:37:25 AM
07-09-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to change a cell in an excel sheet to different background color using perl.I tried SaveParse, but was unable to get it
Please help regarding this.
Thanks and Regards,
Neelam G
https://www.unix.com/images/misc/progress.gif (0 Replies)
Discussion started by: gujrathinr
0 Replies
2. Shell Programming and Scripting
Hi,
I would like to modify an existing excel cell format to a custom format.
Is there a way to do it with out writing into a new excel file.
In-place editing?
Thanks (0 Replies)
Discussion started by: sandeep78
0 Replies
3. Shell Programming and Scripting
The awk is giving below output:
SELECT
divrel.child_org_idn org_main_idn
NULL ( VARCHAR(200)) div_nam_2
NULL ( VARCHAR(200)) div_nam_3
NULL ( VARCHAR(200)) div_nam_4
NULL ( VARCHAR(200)) div_nam_5
NULL ( VARCHAR(200)) div_nam_6
NULL ( VARCHAR(200)) div_nam_7
... (2 Replies)
Discussion started by: goutam_igate
2 Replies
4. 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
5. 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
6. 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
7. 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
8. 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
9. Shell Programming and Scripting
Hello All,
I have the following code in PERL to write data to excel sheet.
Can someone please help me about how to append data to an exisitng cell?
For ex in the below given case,Cell 1,1 has Active State PERL
Now I want to add a new line like "prorgamming" without overwritting the... (3 Replies)
Discussion started by: prasperl
3 Replies
10. 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
LEARN ABOUT MOJAVE
cpanplus::shell::default::plugins::remote5.18
CPANPLUS::Shell::Default::Plugins::Remote(3pm) Perl Programmers Reference Guide CPANPLUS::Shell::Default::Plugins::Remote(3pm) NAME
CPANPLUS::Shell::Default::Plugins::Remote - connect to a remote CPANPLUS SYNOPSIS
CPAN Terminal> /connect localhost 1337 --user=foo --pass=bar ... CPAN Terminal@localhost> /disconnect DESCRIPTION
This is a "CPANPLUS::Shell::Default" plugin that allows you to connect to a machine running an instance of "CPANPLUS::Daemon", allowing remote usage of the "CPANPLUS Shell". A sample session, updating all modules on a remote machine, might look like this: CPAN Terminal> /connect --user=my_user --pass=secret localhost 1337 Connection accepted Successfully connected to 'localhost' on port '11337' Note that no output will appear until a command has completed -- this may take a while CPAN Terminal@localhost> o; i * [....] CPAN Terminal@localhost> /disconnect CPAN Terminal> BUG REPORTS
Please report bugs or other issues to <bug-cpanplus@rt.cpan.org<gt>. AUTHOR
This module by Jos Boumans <kane@cpan.org>. COPYRIGHT
The CPAN++ interface (of which this module is a part of) is copyright (c) 2001 - 2007, Jos Boumans <kane@cpan.org>. All rights reserved. This library is free software; you may redistribute and/or modify it under the same terms as Perl itself. SEE ALSO
CPANPLUS::Shell::Default, CPANPLUS::Shell, cpanp perl v5.18.2 2014-01-06 CPANPLUS::Shell::Default::Plugins::Remote(3pm)