|
Test flexibility!
|
This tool enables any Visual Studio 2005/2008 developer to export gridview data into both real XML format for Excel 2003 and XLSX format for Excel 2007 by adding a few
lines of code to a web page. No need to install Office on
your Server.
|
|
Try multi sheets Excel workbooks!
|
|
This web page's Gridview is databound to an objectdatasource and uses the GEETEasyResponse and GEETEasyMail Classes
|
|
Sales Representative:
|
|
Zipping and mailing feature
By filling your email address you can test 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 ?
|
Check this
option to create SUM Excel Formulas at the bottom of valued columns.
|
|
Some percentage columns?
|
Check this option
to create two Excel Computed Percentages Columns.
|
|
Modify the order date:
|
|
hh
|
mm
|
ss
|
|
|
|
|
|
See coding
|
|
|
Excel 2003 XML format
|
|
|
|
|
Excel 2007 XLSX format
|
|
|
|
|
|
|
|
|
09/09/2010 6.47 - 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 |
|
|