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’.
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;
MaxRow = this.dsZR100.Tables.Rows.Count;
MaxCol = this.dsZR100.Tables.Columns.Count;
tb1 = this.dsZR100.Tables;