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.
Thanks
The observer cannot be left out of the description of the observation.
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。
deepakaitr
Member
85 Points
41 Posts
Genrating XML file after Fill the Data in xls file
Dec 05, 2011 06:58 AM|LINK
Hi Friends,
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.
Thanks
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Genrating XML file after Fill the Data in xls file
Dec 06, 2011 07:49 AM|LINK
Hello：）
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
Best reguards！