Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

PERL: Modify Excel cell formatting

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting PERL: Modify Excel cell formatting
# 1  
Old 10-03-2008
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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parse excel file with html on each cell

<DIV><P>Pré-condição aceder ao ecrã Home do MRS.</P></DIV><DIV><P>OK.</P></DIV><DIV><P>Seleccionar Pesquisa de Recepção Directa.</P></DIV><DIV><P>Confirmar que abriu ecrã de Recepção Directa.</P></DIV><DIV> (6 Replies)
Discussion started by: oliveiraum
6 Replies

2. UNIX for Advanced & Expert Users

awk - If then else rule like Excel cell

Hi, I need extract / transpose where "Y" in the input file My input file is Item,EB,SB,SD,TP,GR LP,Y,N,N,N,Y GC,Y,N,N,N,N CO,N,Y,Y,Y,Y PS,Y,N,N,Y,Y Expecting output is EB-/'LP/',/'GC/',/'PS/' SB-/'CO/' SD-/'CO/' TP-/'CO/',/'PS/' GR-LP,CO,PS I appreciate for your help Regards (4 Replies)
Discussion started by: myrole
4 Replies

3. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

4. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies

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

6. Shell Programming and Scripting

Help to modify in Excel format

Hi I ran some query in solaris machine and the result of the query is as below. Result: dn: uid=xxx,dc=example,dc=com id: xxx firstname: sam lastname: nam But my question is , how to get result in excel format in solaris and result attributes dn,id,firstname,lastname values ... (1 Reply)
Discussion started by: buzzme
1 Replies

7. Shell Programming and Scripting

modify Existing MS excel workbook in perl

Hi I need to modify an excel file in perl and for which I installed perl in Linux 1. Open a existing excel file 2. delete an unwanted Sheet called "summary" 3. and i want to insert some data into range of cells ( B1:B11) 4. Remove unwanted value called "Sum" repeated in the... (1 Reply)
Discussion started by: luke_devon
1 Replies

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 ... (2 Replies)
Discussion started by: goutam_igate
2 Replies

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

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 (1 Reply)
Discussion started by: gujrathinr
1 Replies
Login or Register to Ask a Question

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)