Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  Read data from HTML page and show in Excel
Previous Previous
 
Next Next
New Post 6/26/2008 11:52 PM
Unresolved
User is offline Biju Sam
1 posts
10th Ranked


Read data from HTML page and show in Excel 
I have a requirement in ASP.Net, where is there is a HTML page which will be around 1200 pages with records fetched from a Database using some reports. The records shown in HTML is in a Listed View some thing like Name : BS Age : 66 Work : Personal : xyz : Buisines : xyz Name : AA Age : 66 Work : Offial : abc : Buisines : abc I need this format replicated to an excel sheet in the following way(column wise) Name Age Work.Personal Work.Buisiness Work.Official BS 66 xyz xyz NULL AA 66 NULL abc abc Remember the HTML page has around 1200 pages ie may be around 50,000 rows. And some times the column heirarchy for eg: work can be more like work-official-buisiness-abc-abc----. So taking data from each td is making the task that much difficult. How can i meet this requirement? And also since it is HTML page there is no runat = server for table. in this case how can i get the TD,TR,TABLE etc inside my server side code if i want to loop thorugh each TD and TR. Please give me a solution which can meet this requirement. Or with any other languages this can be met? i mean by Javascript or Java or etc??? Please help. Thanks in advance. Biju Sam
 
New Post 6/27/2008 2:00 AM
User is offline Pete
125 posts
9th Ranked


Re: Read data from HTML page and show in Excel 

I am really not sure what it is exactly so forgive me if i am wrong. From i read you want the contents of the page to be dupilcated to excel ?, if so then you may be better to do this from excel with a import data setting, this can then be set to your page to import the data from the site and will allow for you to set the columns etc.

If you need to do this all of the time it may be best to write a macro to go into your page from excel, import the data and sort if needed and then name and save the data to a saved data file.
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Read data from HTML page and show in Excel
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


BataviaSoft DotNetNuke Solutions
BataviaSoft offers custom DotNetNuke solutions especially for the European and the South East Asian market.
www.bataviasoft.com 		Viva Portals, L.L.C.
Expert module development and graphic design.
www.continure.com 		DNN Photo Gallery
DNN Photo Gallery is a truly unique photo management module released January 1st 2006. With DNN Photo Gallery you can REALLY integrate images into your existing portal and make them look like they were designed for your site.
DNN Photo Gallery

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP