C# Programming
12-09-2009, 01:50 PM
hi all
i am currently using C# vs.net 2005 window form to program an application which would make use of data from a database to write on an excel sheet with (Microsoft.Office.Interop.Excel) it worked fine till i notice some disadvantages of it:
1. when the data is being writen into the excel and user click it always bugs out with an error Error: Exception from Hresult: 0x800AC472 line: mscorlib
2.the excel file must always be open to write the data
as such i was wondering if there is other better way of doing writing data into the excel file which offers the same functions and more. e.g writing without opening the file and etc.
i understand that the ms office 2007 is using xml languash and should be able to do this but how exactly should i start?
please advice
i am currently using C# vs.net 2005 window form to program an application which would make use of data from a database to write on an excel sheet with (Microsoft.Office.Interop.Excel) it worked fine till i notice some disadvantages of it:
1. when the data is being writen into the excel and user click it always bugs out with an error Error: Exception from Hresult: 0x800AC472 line: mscorlib
2.the excel file must always be open to write the data
as such i was wondering if there is other better way of doing writing data into the excel file which offers the same functions and more. e.g writing without opening the file and etc.
i understand that the ms office 2007 is using xml languash and should be able to do this but how exactly should i start?
please advice