Re^2: Getting the background color of a cell in an existing Excel spreadsheet

in reply to Re: Getting the background color of a cell in an existing Excel spreadsheet
in thread Getting the background color of a cell in an existing Excel spreadsheet

Hello Thanos, Thanx for the answer.But I am not looking for setting the font color. I am looking for to read a background color of a cell and apply the same background color to the cell which is in new Spreadsheet.Background color of a cell can be set through set_bg_color() of Spreadsheet::WriteExcel.The thing is when I am reading the background color throuh $format->{Fill}2 method I am getting 65(if no bg color) or 64 irrespective of the background color.

Comment on Re^2: Getting the background color of a cell in an existing Excel spreadsheet

Replies are listed 'Best First'.
Re^3: Getting the background color of a cell in an existing Excel spreadsheet by thanos1983 (Parson) on Apr 19, 2017 at 09:52 UTC
Hello venky1937, Take a look on my updated answer it looks better now. It works for me, let me know if it also works for you. Hope this helps. Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom