I have an excel file with some template. I am given a requirement that the template can change.
So what I want to know is there any way I can read the template of that Excel file as it is and display that excel file excel sheet exactly to a GridView control in my webpage.
I want to read all the styles format basically. so that I can display it as it is in my GridView and ask my user to update in that gridview. So that later point I can save that GridView data in my database.
Thank you in advance.
Loading
Raja KrishnamurthyPosted Mar 8, 2011, 7:42 AM
Please check out the link given below.
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/b6e8a28c-6760-4e86-a1aa-e2ce9ec36380/
The answer given there could be a good start.
HTH.
Happy Programming!!!
Regards,
Raja
Suthish NairPosted Mar 8, 2011, 5:57 AM
shashi reddyPosted Mar 8, 2011, 5:39 AM
XmlDataDocument xmlDatadoc = new XmlDataDocument();
xmlDatadoc.DataSet.ReadXml("C:\\books.xml");