Last post Dec 06, 2011 03:49 AM by Decker Dong - MSFT
Dec 05, 2011 02:58 AM|deepakaitr|LINK
In my project we have requirement, that needs to fill the entries into the xls file and on this xls file we are providing one button ,after clicking on this button all the data which has filled to excel sheet should genrate one XML file.and the very important
thing is drop down for the state,city etc. will be genrated dynamically.and it should support openoffice also.
I have been using following componant for the development
asp .net 3.5,sql server 2008 R2,openoffice for xls file(can use office 2003-07),
Please suggest.how to achive this task.
Dec 06, 2011 03:49 AM|Decker Dong - MSFT|LINK
As far as I see，you can first load all the xls data contents into DataTable or DataSet，and then use WriteToXml to generate a file that is of xml contents。
If this cannot solve you，I think you can ask your question at Office forum at：http://social.msdn.microsoft.com/Forums/en-US/category/officedev