Dear All,
I am opening the excel file to create the object of that excel file using 'Microsoft.Office.Interop.Excel'. It is working fine with file system and local iis server on windows xp operating system. But when running the same code on windows 2003 operating sytem on local iis pagerequest time out error raise.
below is the code which i am using.
public Excel.Sheets m_objSheets = null;
public Excel._Worksheet m_objSheet = null;
public Excel.Range m_objRange = null;
public object m_objOpt = System.Reflection.Missing.Value;
string strFileName = "ICTC_Monthly_Reports123.xls";
string frmImpreg = Server.MapPath("ICTC_Monthly_Reports.xls");
string toImpreg = Server.MapPath("..\\Excel\\" + strFileName);
string filename = frmImpreg;
//code for open excel file
Excel.Application m_objExcel = new Excel.Application();
Excel.Workbook m_objBooks = m_objExcel.Workbooks.Open(filename, 0, true, 5, "", "", true,
Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
m_objSheets = (Excel.Sheets)m_objBooks.Worksheets;
//end code here
waiting for your response, It's urgent
Thanks
Deepak Sonee