using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Reflection;
using?System.Runtime.InteropServices;
using?Excel?=?Microsoft.Office.Interop.Excel;

namespace?報表示例
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????///?

????????///?生成圖表
????????///?

????????///?
????????///?
????????private?void?btnCreateChart_Click（object?sender?EventArgs?e）
????????{
????????????Excel.Application?xlApp;
????????????Excel.Workbook?xlBook;
????????????Excel.Workbooks?xlBooks;
????????????Excel.Range?xlRange;
????????????Excel.Sheets?xlsheets;
????????????Excel.Worksheet?xlSheet;
????????????try
????????????{
????????????????xlApp?=?new?Excel.Application（）;
????????????????xlBooks?=?xlApp.Workbooks;
????????????????xlBook?=?xlBooks.Add（Missing.Value）;
????????????????xlsheets?=?xlBook.Worksheets;
????????????????xlSheet?=?（Excel.Worksheet）xlsheets.get_Item（1）;
????????????????//?xlApp.DisplayAlerts?=?false;
????????????????//?create?cell?header
????????????????object[]?objHeaders?=?{?“數量“?“數據1“?“數據2“?“數據3“?“數據4““數據5“?};
????????????????//?set?header?text
????????????????xlRange?=?xlSheet.get_Range（“A1“?“F1“）;
????????????????xlRange.set_Value（Missing.Value?objHeaders）;
????????????????xlRange.Font.Bold?=?true;
????????????????xlRange.Font.Name?=?“宋體“;
????????????????xlRange.Font.Size?=?10;
????????????????xlRange.HorizontalAlignment?=?Excel.XlHAlign.xlHAlignCenter;
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????xlSheet.Cells[2?+?i?1]?=?i;
????????????????????xlSheet.Cells[2?+?i?2]?=?i?+?1;
????????????????????xlSheet.Cells[2?+?i?3]?=?i?+?2;
????????????????????xlSheet.Cells[2?+?i?4]?=?i?+?3;
????????????????????xlSheet.Cells[2?+?i?5]?=?i?+?4;
????????????????????xlSheet.Cells[2?+?i?6]?=?i?+?5;
????????????????}

????????????????Excel.Chart?xlChart?=?（Excel.Chart）xlBook.Charts.Add（
????????????????????Missing.Value?Missing.Value?Missing.Value?Missing.Value）;

????????????????Excel.Range?chartRage?=?xlSheet.get_Range（“A1:A14“?“B1:F14“）;

????????????????xlChart.ChartWizard（chartRage?Excel.XlChartType.xl3DColumn
????????????????????Missing.Value?Excel.XlRowCol.xlColumns?1?1?true
????????????????????“實驗室效率分析“?“上機時間“?“上機次數“?Missing.Value）;

????????????????////保存圖表
????????????????//xlBook.SaveAs（Application.StartupPath?+?“\\圖表.xls“?Missing.Value
????????????????//????Missing.Value?Missing.Value?Missing.Value?Missing.Value
????????????????//????Excel.XlSaveAsAccessMode.xlNoChange?Missing.Value?Missing.Value
????????????????//????Missing.Value?Missing.Value?Missing.Value）;
????????????????
????????????????//顯示圖表
????????????????xlApp.Visible?=?tr

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-03-26?00:32??報表示例\_UpgradeReport_Files\
?????文件????????3348??2010-10-04?21:43??報表示例\_UpgradeReport_Files\UpgradeReport.css
?????文件???????12505??2008-01-11?01:25??報表示例\_UpgradeReport_Files\UpgradeReport.xslt
?????文件??????????69??2010-10-04?21:43??報表示例\_UpgradeReport_Files\UpgradeReport_Minus.gif
?????文件??????????71??2010-10-04?21:43??報表示例\_UpgradeReport_Files\UpgradeReport_Plus.gif
?????目錄???????????0??2019-03-26?00:32??報表示例\Backup\
?????目錄???????????0??2019-03-26?00:32??報表示例\Backup\報表示例\
?????文件????????4993??2007-10-17?15:36??報表示例\Backup\報表示例\Form1.cs
?????文件????????2406??2007-10-17?15:35??報表示例\Backup\報表示例\Form1.Designer.cs
?????文件????????5814??2007-10-17?15:35??報表示例\Backup\報表示例\Form1.resx
?????文件?????????471??2007-10-06?08:56??報表示例\Backup\報表示例\Program.cs
?????目錄???????????0??2019-03-26?00:32??報表示例\Backup\報表示例\Properties\
?????文件????????1196??2007-10-06?08:56??報表示例\Backup\報表示例\Properties\AssemblyInfo.cs
?????文件????????2879??2007-10-06?08:56??報表示例\Backup\報表示例\Properties\Resources.Designer.cs
?????文件????????5612??2007-10-06?08:56??報表示例\Backup\報表示例\Properties\Resources.resx
?????文件????????1732??2007-10-06?08:56??報表示例\Backup\報表示例\Properties\Settings.Designer.cs
?????文件????????1013??2007-10-06?08:56??報表示例\Backup\報表示例\Properties\Settings.settings
?????文件????????4620??2007-10-17?15:38??報表示例\Backup\報表示例\圖表示例.csproj
?????文件?????????264??2007-10-06?08:56??報表示例\Backup\報表示例\圖表示例.csproj.user
?????文件?????????925??2007-10-06?08:56??報表示例\Backup\圖表示例.sln
?????目錄???????????0??2019-03-26?00:32??報表示例\Backup1\
?????目錄???????????0??2019-03-26?00:32??報表示例\Backup1\報表示例\
?????文件????????4993??2007-10-17?15:36??報表示例\Backup1\報表示例\Form1.cs
?????文件????????2406??2007-10-17?15:35??報表示例\Backup1\報表示例\Form1.Designer.cs
?????文件????????5814??2007-10-17?15:35??報表示例\Backup1\報表示例\Form1.resx
?????文件?????????471??2007-10-06?08:56??報表示例\Backup1\報表示例\Program.cs
?????目錄???????????0??2019-03-26?00:32??報表示例\Backup1\報表示例\Properties\
?????文件????????1196??2007-10-06?08:56??報表示例\Backup1\報表示例\Properties\AssemblyInfo.cs
?????文件????????2879??2007-10-06?08:56??報表示例\Backup1\報表示例\Properties\Resources.Designer.cs
?????文件????????5612??2007-10-06?08:56??報表示例\Backup1\報表示例\Properties\Resources.resx
?????文件????????1732??2007-10-06?08:56??報表示例\Backup1\報表示例\Properties\Settings.Designer.cs
............此處省略54個文件信息