I´m building a function that opens a workbook in Excel 2007 from a template. Then I want to copy the formatting from two rows, create new rows with the copied formats and insert data on those rows. This is what I´ve come up with so far:
The exSheet->Range("A1","B2"); part doesnt seem to work. I can only find C# examples and there they always use the get_Range function which doesnt work i C++/CLI. (Why?)
I think that I might be able to use the Worksheet::Copy() and Worksheet::PasteSpecial() functions, or is there a way to use the Format Painter by code?
Anyway, I cant get it right from here.
Please help would be appreciated.
.NET 3.5, VS 2008 Express, SQL Server 2008 Express