Modify Cell formatting

CPAN::Forum

Thread

Spreadsheet-ParseExcel [search.cpan.org] [Kobes search] [View and report bugs] [Ratings 4.6

4.6

(8) ]

[AnnoCPAN] [CPAN Tests results] [CPANTS]

Posted on Fri Oct 3 15:38:32 2008 by sandeep78

Modify Cell formatting

Hi, I am trying to find a way to modify the cell formatting on an excel spreadsheet. I would like to do it without writing into a new file. More like in-place editing. Any ideas, please Thanks for your time.

Direct Responses: 8931 | Write a response

Posted on Fri Oct 3 16:50:29 2008 by mtpaper in response to 8929

Re: Modify Cell formatting

Please give a specific example of what you are trying to do. In Excel, you can change the formating of a cell or a range of cells simply by selecting the cell or range and choosing Format.Cells or rightclick Format Cells. What are you trying to modify? What is the cell now, and what would you like it to be? Marion in NY

Direct Responses: 8938 | Write a response

Posted on Fri Oct 3 20:17:20 2008 by sandeep78 in response to 8931

Re: Modify Cell formatting

Hi, I want to change a Range of cells (A8 thru T36)...they are numeric. They are formatted as Accounting with 2 Decimal points. I would like to change the format to a custom code. _(* #,##0.00_);_(* (#,##0.00);_(* -??_);_(@_) - This is the custom format. Thanks.

Direct Responses: 8941 | Write a response

Posted on Fri Oct 3 22:07:23 2008 by mtpaper in response to 8938

Re: Modify Cell formatting

Hello - I think you would be better off looking at an Excel forum.... you can set custom codes in Excel via: Format-Cells-Number-Custom. In fact, I think your code is one of the options to select there. HTH - Marion

Direct Responses: 8942 | Write a response

Posted on Fri Oct 3 22:26:01 2008 by sandeep78 in response to 8941

Re: Modify Cell formatting

Thanks, But I am automating the process. Perl is my best option. I have seen scripts where they are formatting on new spread sheets. So I wanted to see if can do it on an existing spread sheet. Regards

Write a response

Service launched on 2nd of February 2005.
Comments, and other submissions on CPAN Forum are Copyright 2005-2007, their respective owners.
Site maintainer is not responsible for content. Privacy Policy

Maintained and hosted by Gabor Szabo at Perl Training Israel

See also World Wide Perl Training