Before you can use the GEET classes in your web pages you must reference the GEETMultisheet
dll which was installed into the Global Assembly Casche of your computer.
To set this reference, perform next steps:
- Inside Solution Explorer select the web.config file and double-click it. Web.config
file will open.
- Locate the compilation section and insert the reference to the GEETMultiSheet assembly
by adding the next line to the Assemblies section of the compilation section.
- Save and close the web.config file.
In order the GEET classes to Response the Excel Sheets you should override the VerifyRenderingInServerForm
Sub in your Web Page by adding next code into your web page:
We have verified that whenever tags are not properly closed, the rendering from GEET Classes cease
to work. In this case we reccommend you to:
- try setting the page attribute EnableEventValidation="false"
- test the Export to Excel again. If it works, your web page may have some tags closure
missing or misplaced.
- after tags correction please set the page attribute EnableEventValidation back to "true"
We have verified that setting a SqldataSource web control inside the TD tags of
a TABLE makes the rendering of the Export to Excel to stop working.