To run the demo:
- choose a Sales Representative
- choose a Year
- set the number of decimal digits for numeric columns
- modify the order date by setting hour, minutes, etc.
- set styles for each sheet's part
- push an Export button to perform the export
|
Requirements to install this demo site and the Gridview to Excel Export Tool
- .Net Framework 3.5
- Microsoft SDK for Open Office XML Formats
- Microsoft SQL Server (any version)
- Microsoft AdventureWorks demo database
|
|
Sales Representative:
|
|
Zipping and mailing feature
By filling your email address you will enable the "export
mailing" feature of the Gridview to Excel Export Tool". By clicking
the below buttons you'll be sent the compressed export files via email.
|
|
Year:
|
|
|
Number of decimal digits:
|
|
|
|
Column Totals ?
|
|
|
Some percentage columns?
|
Check this option
to create two Excel Computed Percentages Columns.
|
|
|
|
Modify the order date:
|
|
hh
|
mm
|
ss
|
|
|
|
|
|
See coding
|
|
|
Date formatting string: |
|
Date formatting string are applied to Excel dates only. |
|
HTML Export |
|
|
|
|
Excel 2003 XML format
|
|
|
|
|
Excel 2007 XLSX format
|
|
|
|
|
|
|
|
|
09/09/2010 6.34 - Sales Report for:Abbas,Syed; Year:2003
|
| Sales Order ID | Order Date | Due Date | Ship Date | Sales Order Number | Customer ID | First Name | Last Name | Email address | Total Due | Freight | Sub Total | Tax Amount |
| 53485 | 2003-09-01 00.00.00 | 13/09/2003 | 08/09/2003 | SO53485 | 573 | Pilar | Ackerman |
pilar1@adventure-works.com
| 85.652,33 | 1.937,84 | 77.513,42 | 6.201,07 |
| 53492 | 2003-09-01 00.00.00 | 13/09/2003 | 08/09/2003 | SO53492 | 640 | Jenny | Lysaker |
jenny0@adventure-works.com
| 25.139,98 | 568,78 | 22.751,11 | 1.820,09 |
| 53502 | 2003-09-01 00.00.00 | 13/09/2003 | 08/09/2003 | SO53502 | 682 | Jeff | Hay |
jeff1@adventure-works.com
| 45.338,76 | 1.025,76 | 41.030,55 | 3.282,44 |
| 53554 | 2003-09-01 00.00.00 | 13/09/2003 | 08/09/2003 | SO53554 | 195 | Neil | Charney |
neil0@adventure-works.com
| 4.544,18 | 102,81 | 4.112,38 | 328,99 |
| 53588 | 2003-09-01 00.00.00 | 13/09/2003 | 08/09/2003 | SO53588 | 69 | Barbara | Decker |
barbara3@adventure-works.com
| 74,88 | 1,69 | 67,76 | 5,42 |
| 53594 | 2003-09-01 00.00.00 | 13/09/2003 | 08/09/2003 | SO53594 | 555 | Sandra | Altamirano |
sandra1@adventure-works.com
| 1.465,51 | 33,16 | 1.326,26 | 106,10 |
| 57059 | 2003-11-01 00.00.00 | 13/11/2003 | 08/11/2003 | SO57059 | 159 | Scot | Bent |
scot0@adventure-works.com
| 3.793,53 | 85,83 | 3.433,06 | 274,64 |
| 58915 | 2003-12-01 00.00.00 | 13/12/2003 | 08/12/2003 | SO58915 | 688 | Neal | Hasty |
neal0@adventure-works.com
| 36.317,54 | 821,66 | 32.866,56 | 2.629,32 |
| 59045 | 2003-12-01 00.00.00 | 13/12/2003 | 08/12/2003 | SO59045 | 555 | Sandra | Altamirano |
sandra1@adventure-works.com
| 4.760,07 | 107,69 | 4.307,75 | 344,62 |
|
|
|
|