Add row in a existing Excel document with styles.

Question

Hello!

I'm working with C# 2008 (FW 3.5), OpenXML SDK 2.0 and a Excel 2007 document's.

The program take's values from a Database and create a dynamic table, and the values are pasted in a Excel template.

All this work's fine, but i need something else:

I need create a specified number of new row's in the template, but with styles (border, font, backcolor, etc.) and I don't how to make it.

Someone can help me with a example code for make this?

Thanks a lot and excuse my english.

Answer 1

I had same situation and found nothing better, but use a vb macros in excel document which adds new row and invoke it from .net.