Excel is not working on IIS server but without IIS is workin

Question

hi... Excel is not working on IIS server but without IIS is working.

Manj N · Answer

protected void Expgo_Click(object sender EventArgs e) { /************************************* * On export click select date range * Generate weekley TimeSheet Report ************************************/ QueryRet Value = new QueryRet(); String StartCalDate; String EndCalDate; StartCalDate = ExpCalStart.SelectedDate.ToString(); EndCalDate = ExpCalEnd.SelectedDate.ToString(); if (StartCalDate == EndCalDate) { Weekview.SetActiveView(Blank); lblerr.Text = Please Select Range of Dates.; lblerr.Visible = true; } else { ExcelApp = new Excel.Application(); ExcelApp.Visible = false; ExcelWork = (Excel._Workbook)(ExcelApp.Workbooks.Add(Missing.Value)); string strCurrentDir = Server.MapPath(~/TimeSheets/); RemoveFiles(strCurrentDir);//removes all .xls files in directory DateTime Daylist; String Query; /******************************************************** * Select all WeekStartDates in the given range of dates ********************************************************/ Query = SELECT DISTINCT WeekStartDate FROM TimeSheetBreakDown; Query +=  Where Date >= ' + StartCalDate + ' AND Date ArrayList DistinctStart = Value.ExecuteQry(Query); if (ExcelWork.Worksheets.Count { ExcelWork.Worksheets.Add(Missing.Value Missing.Value DistinctStart.Count - ExcelWork.Worksheets.Count + 1 Missing.Value); } for (int s = 0; s { /****************************************************** * For each of the week which come under date selected * Generate One Excel Work Sheet ******************************************************/ try { Query = SELECT distinct Date FROM TimeSheetBreakDown WHERE (WeekStartDate = ' + DistinctStart[s] + ' AND Day='1') order by date; Daylist = DateTime.Parse(Value.SelectQry(Query)); /****************************************************************** * From the Distinct StartDate Get (Date of) Monday of that week * From Monday Calculate other Days From TimeSpan * ****************************************************************/ mon = Daylist; tue = Daylist + new TimeSpan(1 0 0 0); wed = Daylist + new TimeSpan(2 0 0 0); thu = Daylist + new TimeSpan(3 0 0 0); fri = Daylist + new TimeSpan(4 0 0 0); sat = Daylist + new TimeSpan(5 0 0 0); sun = Daylist + new TimeSpan(6 0 0 0); } catch (Exception X) { lblerr.Text = X.Message +  Looks like you are Exporting Blank TimeSheet; lblerr.Visible = true; } finally { GC.Collect(); /************************************************************** * Generates one Excel WorkSheet (Gives TimeSheet of that Week) **************************************************************/ GenerateExcel(s + 1); } } DistinctStartCount = DistinctStart.Count + 1; SummarySheet(); ExcelApp.Visible = true; ExcelApp.UserControl = true; String FileName =  + User.Identity.Name + .xlsx; ExcelWork.SaveCopyAs(strCurrentDir + FileName); /* getting error at this line */ String TimeSheetPath = (String)System.Configuration.ConfigurationManager.AppSettings[TimeSheetPath].ToString(); string strMachineName = Request.ServerVariables[SERVER_NAME]; Expgo.Text =  Download TimeSheet ; //TODO: CLean Up... ExcelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelRange); System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApp); System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelSheet); System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelWork); ExcelSheet = null; ExcelWork = null; ExcelApp = null; GC.Collect(); } }

Anurag Sarkar · Answer

What are you exactly trying to do ? R u using ASP.NET ? What code have you used ? Paste you code here so we can sort out the code ?

Manj N · Answer

a reference to 'Microsoft office Web components 9.0' could not be added. converting type library to a .NET assembly failed. a dependent type library 'MSDATASRC' could not be converted to a .NET assembly. No process is associated with this object.

Manj N · Answer

from last few days you are not responding... so this is my last question.. please help me...