plz help export to excel & cell's back color

[homealone]

I can export data to ms_excel
but i can't fill the cell's back color
how to code to fill a cell's back color
someone help
thx

 

[vis781]

I'm assuming you are fairly familiar with automating excel? Here's how you would change the interior of a cell in Excel

[COLOR=seagreen]Your Excel Object[/COLOR].Range([COLOR=seagreen]Start Cell Address[/COLOR],[COLOR=seagreen] End Cell[/COLOR] [COLOR=seagreen]Address[/COLOR]).Interior.ColorIndex = [COLOR=seagreen]YourColorIndex[/COLOR]