How to change cell background in excel sheet using perl

10 More Discussions You Might Find Interesting

1. 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...

2. 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. 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...

4. 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...

5. 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...

6. 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:

7. 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..??

8. 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 ...

9. 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

10. UNIX for Dummies Questions & Answers

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

LEARN ABOUT DEBIAN

spreadsheet::xlsx

Spreadsheet::XLSX(3pm)					User Contributed Perl Documentation				    Spreadsheet::XLSX(3pm)

NAME

       Spreadsheet::XLSX - Perl extension for reading MS Excel 2007 files;

SYNOPSIS

	use Text::Iconv;
	my $converter = Text::Iconv -> new ("utf-8", "windows-1251");

	# Text::Iconv is not really required.
	# This can be any object with the convert method. Or nothing.

	use Spreadsheet::XLSX;

	my $excel = Spreadsheet::XLSX -> new ('test.xlsx', $converter);

	foreach my $sheet (@{$excel -> {Worksheet}}) {

	       printf("Sheet: %s
", $sheet->{Name});

	       $sheet -> {MaxRow} ||= $sheet -> {MinRow};

		foreach my $row ($sheet -> {MinRow} .. $sheet -> {MaxRow}) {

		       $sheet -> {MaxCol} ||= $sheet -> {MinCol};

		       foreach my $col ($sheet -> {MinCol} ..  $sheet -> {MaxCol}) {

			       my $cell = $sheet -> {Cells} [$row] [$col];

			       if ($cell) {
				   printf("( %s , %s ) => %s
", $row, $col, $cell -> {Val});
			       }

		       }

	       }

	}

DESCRIPTION

       This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format.  It supports styles and many of
       Excel's quirks, but not all.  It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet,
       and Cell.

SEE ALSO

       Text::CSV_XS, Text::CSV_PP
	 http://search.cpan.org/~hmbrand/

	 A pure perl version is available on http://search.cpan.org/~makamaka/

       Spreadsheet::ParseExcel
	 http://search.cpan.org/~kwitknr/

       Spreadsheet::ReadSXC
	 http://search.cpan.org/~terhechte/

       Spreadsheet::BasicRead
	 http://search.cpan.org/~gng/ for xlscat likewise functionality (Excel only)

       Spreadsheet::ConvertAA
	 http://search.cpan.org/~nkh/ for an alternative set of cell2cr () / cr2cell () pair

       Spreadsheet::Perl
	 http://search.cpan.org/~nkh/ offers a Pure Perl implementation of a spreadsheet engine. Users that want this format to be supported in
	 Spreadsheet::Read are hereby motivated to offer patches. It's not high on my todo-list.

       xls2csv
	 http://search.cpan.org/~ken/ offers an alternative for my "xlscat -c", in the xls2csv tool, but this tool focusses on character encoding
	 transparency, and requires some other modules.

       Spreadsheet::Read
	 http://search.cpan.org/~hmbrand/ read the data from a spreadsheet (interface module)

AUTHOR

       Dmitry Ovsyanko, <do@eludia.ru<gt>, http://eludia.ru/wiki/

       Patches by:

	       Steve Simms
	       Joerg Meltzer
	       Loreyna Yeung
	       Rob Polocz
	       Gregor Herrmann
	       H.Merijn Brand
	       endacoe
	       Pat Mariani
	       Sergey Pushkin

ACKNOWLEDGEMENTS

	       Thanks to TrackVia Inc. (http://www.trackvia.com) for paying for Rob Polocz working time.

COPYRIGHT AND LICENSE

       Copyright (C) 2008 by Dmitry Ovsyanko

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or,
       at your option, any later version of Perl 5 you may have available.

perl v5.10.1							    2010-05-16						    Spreadsheet::XLSX(3pm)

Shell Programming and Scripting