File save location


#1

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


#2

Hi kamini,

The following is a related comment from MSDN.

ImpersonationLevelOption Enumeration [C#]


Note
For library (inproc) applications, the only valid settings are Default or none specified.