Cell format after Excel export

[isi_catch]

hi

had a couple of issues and was wondering if someone could help me.

1) i cannot get the cell background color to change in the exported excell file

2)how do i supress the heading band(or delete it) for the export.... i need to do this because the export creates a row after the title. and i dont need that to happen

thanks in advance.... 

[kchaudhry]

For the background color of the cell are you using a style? If so, then do you have the mode set to "Opaque"? I have it set this way and it works for me in excel/pdf/html. For the second question simply right click on the band you want to supress and change the hieght to 0.

Hope this helps.

[isi_catch]

thanks... it helped quite a bit

should have read the user manual i guess...

i now realize how silly these questions actually were...