"Export to Excel" Server Behavior
for Dreamweaver MX -Dreamweaver 8

This product is fully compatible with Adobe Dreamweaver CS3!

See what users have to say about this extension: THANK YOU.. that totally solved my problem and it's working like magic!!  Great product! I'm definitely recommending you to the DW users I know!! Erick Cardoza Randomtype I have purchased two extensions from you website and I would like to thank you for these wonderful tools. They are awesome! Thank you. Michael Kusejko BE52 Media Publishing

Export your recordset to Microsoft Excel with a click of a button!
Compatible with ASP (VBScript), PHP (MySQL) and ColdFusion server models.
^New Since version 2.0.5 also compatible with ASP.NET (VB)

This Server Behavior will generate a Comma-delimited (.csv) file out of a Recordset without writing it to the hosting server. Your web site user will be prompted to save the file to the hard drive to be open with Microsoft Excel.
^New You can now set the file to open directly in the browser (Internet Explorer only).
In addition you can include Recordset column names in the first row of the exported file.

"Comma-delimited" format uses comma (obviously) and line break as field and row delimiters. If a field already contains a comma or a line break an undesirable shift of data may occur. To get around this problem the Behavior will replace all commas and line breaks in exported file (not in the database!!!) with Cedilla ("¸" a rare character somewhat resembling comma) and a character space respectively. If desired Cedilla (Alt+ 0184) can be quickly restored to comma in Excel in all the fields at once by using "Replace" command.

Please Note: This server behavior will export the Recordset data only, not the entire page. If you need to export the page as is to either Microsoft Word or Excel (while controlling what gets and what doesn't get to be displayed in the exported document) you can download the Save to Word or Excel Server Behavior which does just that.

Here you can find a Flash tutorial on how to use the extension (created by Aron Kansal of DMXtutorials.com).

Browser Compatibility:

• Internet Explorer 5.0 and higher
• Opera 7
• Netscape 7
• Mozilla 1.6 and higher on both Windows and Linux
• Firefox 0.9 and higher on both Windows and Linux
• Konqueror (tested with KSpread)

"Export to Excel" Example

If you need to you can apply this Server Behavior to more than one Recordset (you have to do this for each Recordset separately).
The Behavior will use the "First check if variable is set" set of parameters to identify which Recordset you wish to export.

To give you an idea on how the Behavior can be used in a real life application the example below demonstrates the use of the Behavior with multiple Recordsets. A table with company employees contains data for employees working in two Departments. The value of the dropdown menu is used by the Departments_rs recordset to extract the data for the selected Department only. When the form is submitted (by either selecting an item from the dropdown or clicking "Export") the Behavior is using the value of a hidden field in this form to determine that this time it will use this recordset for the export.

The page also contains Employees_Names_rs Recordset which grabs only First Name and Last Name parameters for ALL the employees regardless of the Department. Another form titled "Export Employees list (Names only)" has been added to the page. It contains its own hidden field and submit button. If this form is submitted the Behavior will catch the hidden field value and  export the Employees_Names_rs Recordset.

Export to Excel functions

Export by Department Department 22 Department 44 Export

Export Employees list (Names only) Export

Questions? Suggestion? Contact us here

Transactions are processed through PayPal. YOU DON'T need to have PayPal account in order to buy. After payment you will automatically be redirected to the download section. USD$ 24.00

Copyright 2004 Alex July, Linecraft Studio