I need to create a C# windows application that will read and write and also creates Excel work books.
I like the COM interop method for its simplicity.
I am planning to create simple Excel sheets , but need some minor formatting to columns.
I am happy to create my files with xls extension as opposed to xlsx, so it can be opened in Excel 2007 etc.
But when I use COM interop , do I need to have the same version of MS Office as the end user ? such as office 2010 ?
Can I not use office 2010 on my development PC and then deploy the necessary dlls along with my application so that the app will work on any office version.