Setting a cell's format using Excel 2007 Interop and C#
- by CVertex
I'm using the office 2007 interop assemblies to create some excel spreadsheets.
There are plenty of questions on here about getting started and MSDN contains heaps of articles, like this one.
The API is funky, and sometimes a bit confusing.
When I set a value of a cell, is there a way to set it's format?
I'd like to mark particular fields as Date's so my customer can run excel macros on them.
Also, numbers would be useful.
Thanks!