EasyXLS - View topic - Define a sheet background color

View unanswered posts | View active topics It is currently Tue Nov 26, 2024 2:16 pm

Define a sheet background color

Moderators: daniela, claudiu, oana

Page 1 of 1

[ 3 posts ]

Print view

Previous topic | Next topic

Define a sheet background color

Author

Message

mariodagot

Joined: Wed Oct 01, 2008 4:19 am
Posts: 10

Define a sheet background color

Hi,

Is there any way to set an entire sheet background color?
I've tried:


	Code: ExcelStyle xlsStyleData = new ExcelStyle(); xlsStyleData.setBackground(Color.WHITE); ExcelTable tbl = sheet.easy_getExcelTable(); tbl.easy_setRangeStyle(0, 0, 300, 255, xlsStyleData);

but this code takes too long and the excel is bigger (in MB) than it should (if I do the same thing but using excel directly).

Thanks in advance.
Regards.
Mário

Wed Oct 01, 2008 4:46 am

oana

Joined: Wed Nov 07, 2007 4:42 am
Posts: 67

Hi,

You can make the columns white only. See sample code below:


	Code: //Get the table of the first worksheet ExcelTable tbl = sheet.easy_getExcelTable(); //Create an empty cell tbl.easy_getCell(0, 255); ExcelStyle xlsStyleData = new ExcelStyle(); xlsStyleData.setBackground(Color.WHITE); for (int column=0; column<256; column++){ tbl.easy_getColumnAt(column).setStyle(xlsStyleData); }

Thu Oct 02, 2008 5:35 am

mariodagot

Joined: Wed Oct 01, 2008 4:19 am
Posts: 10

Thanks,
It works. <- src="{SMILIES_PATH}/icon_cool.gif" alt="8)" title="Cool" />

Tue Oct 07, 2008 4:08 am

Page 1 of 1

[ 3 posts ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum