I want to expor data like data in a msflexgrid or listview to a excel file, from a VB proyect

But i want to change the colums properties, and put formulas or totals.

I don't know and i can't find, for example, to change the backcolor of a cell.

Another thing, when i fill the cell with some text like this

xlsApp.Cells(15, 2) = "=SUM(B2,B10)",

when i open the file in excel, the cell appears with "#######".