Hi,
I am currently evaluating Aspose.Excel.
I need to import data from a secure database, and so I have to use impersonation in webconfig file.
I have created a simple file to import data from one datatable of this database, and I output the data in excel file. But, I get the following server error
==================================
Access is denied: ‘Aspose.Excel’.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.IO.FileLoadException: Access is denied: ‘Aspose.Excel’.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Could you please tell me where does the Excel file (.xls) file generated by the code get stored on the server.
My code is as follows:
=======================================
private void Btn_Click(object sender, System.EventArgs e)
{
Excel Ex = new Excel();
Worksheet sheet = Ex.Worksheets[0];
this.daZR100.Fill(this.dsZR100);
MaxRow = this.dsZR100.Tables[0].Rows.Count;
MaxCol = this.dsZR100.Tables[0].Columns.Count;
tb1 = this.dsZR100.Tables[0];
sheet.Cells.ImportDataTable(this.tb1,true,1,1,MaxRow,MaxCol,false);
Ex.Save(“Zr100.xls”,SaveType.OpenInExcel,FileFormatType.ExcelXP,this.Response);
}
==========================================thanks,
kamini