Excel Download problem

[anandbpatil]

I get an exception while saving a excel into the location..

Source code :

private void CreateExcelWorkbook(string strsql) {
string strCurrentDir = Server.MapPath(".") + "\\";
RemoveFiles(strCurrentDir);
Excel.Application oXL;
Excel._Workbook oWB;
Excel._Worksheet oSheet;
Excel.Range oRng;

try {
GC.Collect();// clean up any other excel guys hangin' around...
oXL = new Excel.Application();
oXL.Visible = false;
//Get a new workbook.
oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
//get our Data
string strConnect = System.Configuration.ConfigurationManager.ConnectionStrings["SG"].ToString();
SPGen sg = new SPGen(strConnect, strsql);
SqlDataReader myReader = sg.RunReader();
// Create Header and sheet...
int iRow = 2;
for (int j = 0; j < myReader.FieldCount; j++) {
oSheet.Cells[1, j + 1] = myReader.GetName(j).ToString();
}
// build the sheet contents
while (myReader.Read()) {
for (int k = 0; k < myReader.FieldCount; k++) {
oSheet.Cells[iRow, k + 1] = myReader.GetValue(k).ToString();
}
iRow++;
}// end while
myReader.Close();
myReader = null;
//Format A1:Z1 as bold, vertical alignment = center.
oSheet.get_Range("A1", "Z1").Font.Bold = true;
oSheet.get_Range("A1", "Z1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
//AutoFit columns A:Z.
oRng = oSheet.get_Range("A1", "Z1");
oRng.EntireColumn.AutoFit();
oRng = oSheet.get_Range("A1", "A1");
oRng.EntireColumn.Delete(Excel.XlDeleteShiftDirection.xlShiftToLeft);
oSheet.get_Range("A2", "A2").Select();
oXL.ActiveWindow.FreezePanes = true;
oXL.Visible = false;
oXL.UserControl = false;
//string strFile = "report" + System.DateTime.Now.Ticks.ToString() + ".xls";
string strFile = Utilities.CurrentUser.EIN.ToString().Replace(" ","_").ToString() + ".xls";
oWB.SaveAs(strCurrentDir + strFile, Excel.XlFileFormat.xlWorkbookNormal,
null, null, false, false, Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null);
// Need all following code to clean up and extingush all references!!!
oWB.Close(null, null, null);
oXL.Workbooks.Close();
oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(oRng);
System.Runtime.InteropServices.Marshal.ReleaseComObject(oXL);
System.Runtime.InteropServices.Marshal.ReleaseComObject(oSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(oWB);
oSheet = null;
oWB = null;
oXL = null;
GC.Collect(); // force final cleanup!
string strMachineName = Request.ServerVariables["SERVER_NAME"];
errLabel.Text = "<A href=http://" + strMachineName + ":8080/Inventory/DM/" + strFile + ">Download Report</a>";
}
catch (System.Exception ex) {
String errorMessage;
errorMessage = "Error: ";
errorMessage = String.Concat(errorMessage, ex.Message);
errorMessage = String.Concat(errorMessage, " Line: ");
errorMessage = String.Concat(errorMessage, ex.Source);
errLabel.Text = errorMessage;
}
}

Can someone suggest whats the error..let me know if u need further info

 

[PlausiblyDamp]

What was the error? Does your application have permission to write to the location you are saving to?