public void CreateAttributeReport() { try { Report.XL.Visible = false; Report.XL.UserControl = false; Microsoft.Office.Interop.Excel._Workbook oWB = Report.CreateWorkBook(); Microsoft.Office.Interop.Excel._Worksheet oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oWB.ActiveSheet; //I don't have aralogo.jpg... object oEndHeaderCell = Report.CreateHeader(".\\sha.png", oSheet, "A1", "Attribute View Report", "Network: " + m_strNetworkName, "Pavement attribute data for network - " + m_strNetworkName); int iEndHeaderRow = Report.GetNextRowNumber(oEndHeaderCell.ToString()); iEndHeaderRow++; // One row of white space between header and data. object oStartData = "A" + iEndHeaderRow.ToString(); //Report.PlaceReportGraphic(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\RoadCare Projects\\" + drPage["reportGraphicFile"].ToString(), "A1", oSheet); Report.WriteDGVToExcel(m_dgv, oSheet, oStartData, true); Report.XL.Visible = true; Report.XL.UserControl = true; } catch (Exception exc) { throw exc; } //oWB.SaveAs("test", XlFileFormat.xlHtml, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); //xlChart.ChartType = XlChartType.xlXYScatter; //xlChart.HasLegend = false; //xlChart.SetSourceData(oRng, Missing.Value); //oChart.ChartWizard(oRng, Microsoft.Office.Interop.Excel.XlChartType.xlXYScatter, Missing.Value, //Microsoft.Office.Interop.Excel.XlRowCol.xlColumns, Missing.Value, Missing.Value, Missing.Value, //Missing.Value, Missing.Value, Missing.Value, Missing.Value); //oChart.SetSourceData(oRng, Missing.Value); }