| No. | Questions and Answers |
| 1 |
|
Q: |
It looks like your assembly uses WindowsBase.dll which is .NET 3.0 |
|
A: |
As described in in the http://www.gridviewtoexcel.com site, .Net Framework 3.0, is a requirement to install the tool. |
|
| 2 |
|
Q: |
May I export data directly from a sqlDataSource or do I absolutely need a Gridview in my web Page? |
|
A: |
Yes, you can export data directly from any SqlDatasource, Dataview, Objectdatasource without using any Gridview. |
|
| 3 |
|
Q: |
How can I change display settings of the exported Excel file? |
|
A: |
By applying proper changes to the Excel Templates files. |
|
| 4 |
|
Q: |
How can I export only some columns from my gridview? |
|
A: |
Export is performed only for visible Gridview columns. If you want to export only some columns you should consequently make columns visible or not visible before Excel Export Classes instantiation. |
|
| 5 |
|
Q: |
I set the dataformatstring of a Gridview column to {0:#,##0.0000} but when the Gridview renders it shows a wrong number of decimal digits. |
|
A: |
Set the HTMLencode feature of the column to "false". |
|
| 6 |
|
Q: |
May I obtain a multi-sheets Excel Workbook by means of the "Gridview to Excel Export Tool"? |
|
A: |
Yes, you can! By means of the new interface between the Gridview to Excel Export Tool dll, you can define as many sheets as you like (compatibly with Excel limits).
Each sheet can be fed by its own Sqldatasource or Dataview. You may also use one dataview and provide one different rowfilter for each Excel sheet. |
|
| 7 |
|
Q: |
How to submit a support request? |
|
A: |
Write to info@gridviewtoexcel.com describing the error, screenshots and whatever material maybe useful to resolve the issue. You will be contacted ASAP by our technicians. |
|
| 8 |
|
Q: |
When I run the Execute method of any GEET Class nothing happens. |
|
A: |
In order the Excel sheets to be rendered please verify that
1) you properly did override the VerifyRenderingInServerForm Sub
2) try setting the page attribute EnableEventValidation="false". In case your page starts working properly again, please verify very carefully that your page's tags are correctly closed.
For instance we have verified that putting a SqlDatasource inside a TD makes the rendering of the GEET classes to fail. |
|