Tutorial search

All categories3DS MaxAccessAdobe PremiereAfter EffectsASPASP.NETAutoCADBlender 3DBodyPaintBryce 3DC++Cinema 4DColdfusionCorel DrawCSSDelphiDreamweaverExcelFireworksFlashFreehandFrontpageFruity LoopsGimpGoLiveHTMLIllustratorImage ReadyInDesignJavaJavaScriptLightwave 3DLinuxMac OS XMaya 3DMySQLOutlookPagemakerPaint ShopPainterPhotoshopPHPPoserPowerPointPythonRuby on RailsSEOSwift 3DSwish MaxTerragenValve EditorVisual BasicWeb DesignWindowsWordXML

ASP Tutorials

• ASP tutorials

Tutorials

• 3DS Max tutorials
• Access tutorials
• Adobe Premiere tutorials
• After Effects tutorials
• ASP tutorials
• ASP.NET tutorials
• AutoCAD tutorials
• Blender 3D tutorials
• BodyPaint tutorials
• Bryce 3D tutorials
• C++ tutorials
• Cinema 4D tutorials
• Coldfusion tutorials
• Corel Draw tutorials
• CSS tutorials
• Delphi tutorials
• Dreamweaver tutorials
• Excel tutorials
• Fireworks tutorials
• Flash tutorials
• Freehand tutorials
• Frontpage tutorials
• Fruity Loops tutorials
• Gimp tutorials
• GoLive tutorials
• HTML tutorials
• Illustrator tutorials
• Image Ready tutorials
• InDesign tutorials
• Java tutorials
• JavaScript tutorials
• Lightwave 3D tutorials
• Linux tutorials
• Mac OS X tutorials
• Maya 3D tutorials
• MySQL tutorials
• Outlook tutorials
• Pagemaker tutorials
• Paint Shop tutorials
• Painter tutorials
• Photography tutorials
• Photoshop tutorials
• PHP tutorials
• Poser tutorials
• PowerPoint tutorials
• Python tutorials
• Ruby on Rails tutorials
• SEO tutorials
• Swift 3D tutorials
• Swish Max tutorials
• Terragen tutorials
• Valve Editor tutorials
• Visual Basic tutorials
• Web Design tutorials
• Windows tutorials
• Word tutorials
• XML tutorials

Stuff

• Most Popular Tutorials
• Best Rated Tutorials
• Random Tutorial

• Tutorial submission tool
• Photoshop Templates
• Flash Templates
• Forum signatures
• Free Video Tutorials
• Best Scripts

• Contact

Total Tutorials: 45844

Affiliates

This tutorial focuses on extracting data from a Microsoft Excel Spreadsheet. This tutorial will walk you through step-by-step to setup the spreadsheet and how to write the code in ASP to get the required data.

You will find here a script that will show you how to create a real Excel file (spreadsheet in biff8 format) from asp without having MS Excel. The script is using the free version of the component : DypsXSL.

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. This example will show you how to 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. 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.

This article describes using the Office Web Components (OWC) to create an Excel spreadsheet via ASP code based on the results from a database query. All of this complexity is encapsulated in a (rather basic) class.

This article shows how to use an Excel file as the database for an employee photo directory. As part of the Active Server Pages application it explains how to configure the spreadsheet for online use, create recordsets from the rows of data, and perform queries and navigate using a browser.

This is a short example showing how to bring data from Access to excel where further manipulation can take place.

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.

This tutorial shows a quick and easy way to generate Excel reports using just ASP. It allows the server to dynamically create Excel reports without taking up any space on the server, and also allows multiple concurrent users to receive these reports simultaneously. The generated reports can be complete with Excel formulas, which allows intensive calculations to be moved to the client side. This method only works with Excel 97 or later.

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.

Aim of this articles is to display records from an Microsoft Excel in an ASP. We could use general SQL command while retrieving data from an excel sheet. All we need to know how to connect Excel file.