Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Change the cell background in excel sheet using Perl Post 302213123 by gujrathinr on Wednesday 9th of July 2008 09:01:16 AM
Old 07-09-2008
Change the cell background in excel sheet using Perl

I need to change a cell in an excel sheet to different background color using perl.
Please help regarding this.
Thanks and Regards,
Neelam G
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to change cell background in excel sheet using perl

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

PERL: Modify Excel cell formatting

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

Export into a single cell of excel sheet...

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

Excel sheet modification using perl module

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

Excel sheet modification using perl module

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

Excel sheet modification using perl module

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

Perl : not capturing all the data from excel sheet

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

Perl Reading Excel sheet isssue

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

Perl - Append data to existing excel cell

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
Color::Calc::WWW(3pm)					User Contributed Perl Documentation				     Color::Calc::WWW(3pm)

NAME
Color::Calc::WWW - Simple calculations with colors for the WWW. SYNOPSIS
use Color::Calc::WWW; my $background = 'green'; print 'background: ', color($background),';'; print 'border-top: solid 1px ', color_light($background),';'; print 'border-bottom: solid 1px ', color_dark($background),';'; print 'color: ', color_contrast_bw($background),';'; DESCRIPTION
The "Color::Calc::WWW" module implements simple calculations with RGB colors for the World Wide Web. This can be used to create a full color scheme from a few colors. This module is nearly identical to using the following: use Color::Calc('ColorScheme' => 'WWW', 'OutputFormat' => 'html'); However, this module also makes the functions available when not imported: use Color::Calc::WWW(); # don't import Color::Calc::WWW::color('F00'); USAGE
By default, all functions are imported. All functions recognize all HTML color keywords (through Graphics::ColorNames::WWW) and output the results in WWW-compatible formats, i.e. as one of the 16 basic HTML keywords (see Graphics::ColorNames::WWW) or as #RRGGBB. color, color_mix, ... See L<Color::Calc> for a list of available calculation functions. NOTE
AUTHOR
Claus Faerber <CFAERBER@cpan.org> LICENSE
Copyright 2004-2010 Claus Faerber. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-06-30 Color::Calc::WWW(3pm)
All times are GMT -4. The time now is 06:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy