Hi ,
I am writing a console application (VB.NET). That application generates an Excel file. I would like to format cell(1,1) and cell(1,2) to have a background color of orange and the font color to Blue and the font size to 10 . It could be easily accomplished by importing microsoft.office.interop.excel but not officeOpenXML. Currently I am rstricted to use officeOpenXML only . Is there any sample code on how to do this?
Regards!
I am writing a console application (VB.NET). That application generates an Excel file. I would like to format cell(1,1) and cell(1,2) to have a background color of orange and the font color to Blue and the font size to 10 . It could be easily accomplished by importing microsoft.office.interop.excel but not officeOpenXML. Currently I am rstricted to use officeOpenXML only . Is there any sample code on how to do this?
Regards!