I am trying to connect Excel document to my web page, but don't know how to do it. Is it possible to state the structure of excel table exactly using Gridview or any other tools or control in web page? These excel document contains class routine of our department.
Any suggestion will be very helpful to me.
I have uploaded two sample routines here, so that it may helps you to see what kind of structure I am talking about.
In above sample I have exported Data Table in Excel with Some formatting, you can play little bit with that to generate formats which you require. Your formats mostly use simple Borders and in above sample it is described that how to set borders.
Let me know if you have any further issues in implementation.
Thanks,
Zeeshan Umar ~Please Mark As Answer, one or multiple posts, which helped you. So that it might be useful for others~
Member
43 Points
106 Posts
Connect Excel With ASP.NET Page
Sep 29, 2010 12:44 PM|Tapas Bose|LINK
Hello everybody.
I am trying to connect Excel document to my web page, but don't know how to do it. Is it possible to state the structure of excel table exactly using Gridview or any other tools or control in web page? These excel document contains class routine of our department. Any suggestion will be very helpful to me.
I have uploaded two sample routines here, so that it may helps you to see what kind of structure I am talking about.
Here is the link :
1. Routine pattern - 1 : download
2. Routine pattern - 2 : download
Star
10444 Points
2463 Posts
Re: Connect Excel With ASP.NET Page
Oct 01, 2010 06:05 AM|sirdneo|LINK
Go throu this URL:-
http://zeeshanumardotnet.blogspot.com/2010/08/creating-advanced-excel-2007-reports-on.html
In above sample I have exported Data Table in Excel with Some formatting, you can play little bit with that to generate formats which you require. Your formats mostly use simple Borders and in above sample it is described that how to set borders.
Let me know if you have any further issues in implementation.
Zeeshan Umar
~Please Mark As Answer, one or multiple posts, which helped you. So that it might be useful for others~