How to Export an Excel (xls) document that's compatible to all office versions - C#
-
Hi everyone. I have created an application that exports a new xls document, I did that using the com component "Microsoft Excel 9.0 object library" but of course that made my application dependant to this library. That shouldn't work on another client machine that don't have this version of Excel installed. How can i make an application independent from my office. I mean it should be compatible with 'ALL' excel versions any idea how to do this. and forget about the 'csv' format. thanks
-
Hi everyone. I have created an application that exports a new xls document, I did that using the com component "Microsoft Excel 9.0 object library" but of course that made my application dependant to this library. That shouldn't work on another client machine that don't have this version of Excel installed. How can i make an application independent from my office. I mean it should be compatible with 'ALL' excel versions any idea how to do this. and forget about the 'csv' format. thanks
-
Hi everyone. I have created an application that exports a new xls document, I did that using the com component "Microsoft Excel 9.0 object library" but of course that made my application dependant to this library. That shouldn't work on another client machine that don't have this version of Excel installed. How can i make an application independent from my office. I mean it should be compatible with 'ALL' excel versions any idea how to do this. and forget about the 'csv' format. thanks
Hi, Im convinced i did this many years ago, but I cant find the code. I did find this on Google Groups tho' You can use the Microsoft OLE BD provider for Jet to dynamically create an Excel workbook. Specifying a non-existent but valid path, workbook name and Excel 'table' in a SELECT..INTO query results in it being created. Hope this helps David
-
Hi, Im convinced i did this many years ago, but I cant find the code. I did find this on Google Groups tho' You can use the Microsoft OLE BD provider for Jet to dynamically create an Excel workbook. Specifying a non-existent but valid path, workbook name and Excel 'table' in a SELECT..INTO query results in it being created. Hope this helps David
thank you guys, I think both of your suggests might work, but the first one looks like used in a web app, and the second one is cool. Though i haven't tried any. Coz I think i found what i wanted, http://support.microsoft.com/kb/302902/[^] go to 'late binding', it's working for now, there's the test stuff later.but so far it worked on two workstations with MSoffice 2003 and the other 2000. Thanks a lot for your help though, and i might use one of these methods if the current one fails, if not it's still good knowledge for me and ppl who might face such problems. thanks