hi,
i am trying to create an .xls file from a data table and saving it in application local folder. all this i am doing for a web application. everything is fine until i end with an error. so please look into below error and help me out with a solution
Error :
Microsoft Excel cannot access the file 'E:\Syed Project\E-Comply_Project\E-Comply Source Code\COC_Export\'. There are several possible reasons:
. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.
Code :
public void DTToExcel(System.Data.DataTable dt, string filePath)
{
try
{
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
string data = string.Empty;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
for (int j = 0; j <= dt.Columns.Count - 1; j++)
{
data = dt.Rows[i].ItemArray[j].ToString();
xlWorkSheet.Cells[i + 1, j + 1] = data;
}
}
xlWorkBook.SaveAs(filePath + "\\" + "BOM_Matched_ExcelReport.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
}catch(Exception Ex)
{ throw Ex; }
}
Thanks & Regards,
Sateesh kumar Singupuram
sateesh kumar singupuram