NEW LISTINGS  HOT LISTINGS  TOP RATED  EDITOR PICK  ADD A LISTING  UPDATE A LISTING  GET RATED  UPGRADE A LISTING
  HOME     MY ACCOUNT     POWER SEARCH     REGISTER     MEMBER LIST     SUGGEST CATEGORY  
GLOBAL SEARCH

Browse a Listing

Subscribe to this category

Top > ASP > Tips and Tutorials > Excel and ASP

Popular Tags

Free Script links
Sort By :
1. Displaying Records From An Excel Database
Details

Visit

Refer

Review
Aim of this articles is to display records from an Microsoft Excel in an ASP. We could use general SQL command while retreving data from an excel sheet. All we need to know how to connect Excel file.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 6 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

2. Generate Excel files
Details

Visit

Refer

Review
Generating Excel files from web pages or other applications is a major subject in many articles. I'd like to present here some solutions, part of them, already presented and well known. Some of them require MS Excel to be installed on the server, and other not.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 5 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

3. Create Excel from Form Input
Details

Visit

Refer

Review
ASP form input can be transformed into most any type of format that you'd like to see it in. Typically, most form input either gets delivered to a database, like Access or SQL server or the output is sent to an email address or some other application. In a previous example we?ve even demonstrated how ASP form input can be used to write a permanent html document directly to the server. ASP Form Input to HTML. In this example we will take user input and create an excel file of that input on the server. The title that the user inputs will be used to name the document, so titles containing !@#$%^&*()+= are invalid. When utilizing this script on your site please keep in mind that the directory that you execute the .asp code from must have user write authority established on the server.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

4. Create Excel on the Server
Details

Visit

Refer

Review
This code example demonstrates how to create excel documents on your server. Using the US state info db, after reading the contents of the db instead of writing output to the browser, html text is written to the server with the .xls file extension. A link to the new document is created (in the browser) for easy navigation to the new document. The current time (server time) is also displayed to show that the excel document was created dynamically.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

5. Create an Employee Photo Directory with Excel and ASP
Details

Visit

Refer

Review
This article shows how to use an Excel *.xls file as the database for an employee photo directory. As part of this Active Server Pages application you'll see how to configure the spreadsheet for online use, create recordsets from the rows of data, and perform queries and navigate using a browser.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

6. Display an Excel DB
Details

Visit

Refer

Review
The author writes "For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale." This exmaple code demonstrates how to display data from Excel using sample data of Hank Greenberg's career statistics. Example code available for download.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 0 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

7. Creating Excel Spreadsheets with Office Web Components (OWC)
Details

Visit

Refer

Review
This article presents a class (ExcelGen) that generates an Excel spreadsheet based on the results of a Recordset. An enhanced version of this class is available at: Enhancing the ExcelGen Class (for Creating Excel Spreadsheets). However, make sure you've read this article completely before moving onto the next!
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 6 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

8. data to users in Excel format,
Details

Visit

Refer

Review
Sometimes it's useful to present data to users in Excel format, so they can easily manipulate the data themselves. In this article, a very simple technique for accomplishing this is demonstrated.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

9. Output To MSExcel
Details

Visit

Refer

Review
This is a short example showing how to bring data from Access to excel where further manipulation can take place.
Category:
ASP > Tips and Tutorials > Excel and ASP

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

Category Jump :