Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 22nd, 2008, 04:44 PM
Registered User
 
Join Date: Aug 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ashfaqshariff2007
Default How to convert an excel sheet into a web page

Hi experts,
  I need some sample codes and websites links to convert an excel sheet into a web page.please help me.I have tried many websites but not able to get the information what m looking for.

Mohammed Ashfaq Shariff.A
 
Old August 22nd, 2008, 05:00 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

You can just connect to Excel *AS IF* the ".xls" file is a database and then read the contents of any sheet (or even any range of cells, etc.) as if it were a DB table.

So then you can just use all of ASP.NET's DB-related controls. Such as DataGrid and the like.

For how to make the connection look here:
http://www.carlprothman.net/Default....anagedProvider
and here:
http://www.carlprothman.net/Default....orMicrosoftJet
(scroll down to "You can also open an Excel Spreadsheet using the JET OLE DB Provider")





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to save user input in Excel from web page onlyshails Javascript 6 March 25th, 2015 11:02 AM
write multi-sheet Excel w/o Excel.Application manmoth Classic ASP Components 2 November 22nd, 2005 10:56 AM
Printing excel sheet siddique Excel VBA 3 February 15th, 2005 12:49 AM
excel sheet used in javascript ayppa Excel VBA 1 August 19th, 2004 01:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.