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


namespace?ExcelCreate
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????newtest?ne?=?new?newtest（）;
????????????ne.simpleButton1_Click（sendere）;
????????}????????
????}
????public?partial?class?newtest
????{
????????public?newtest（）
????????{
????????????
????????}

????????public?void?simpleButton1_Click（object?sender?EventArgs?e）
????????{
????????????KillProcess（“Excel“）;//首先殺死進程
????????????Microsoft.Office.Interop.Excel.Application?xlApp?=?new?Microsoft.Office.Interop.Excel.Application（）;
????????????Microsoft.Office.Interop.Excel.Workbooks?workbooks?=?xlApp.Workbooks;
????????????Microsoft.Office.Interop.Excel.Workbook?workbook?=?workbooks.Add（Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet）;
????????????Microsoft.Office.Interop.Excel.Worksheet?worksheet?=?（Microsoft.Office.Interop.Excel.Worksheet）workbook.Worksheets[1];
????????????Microsoft.Office.Interop.Excel.Range?range?=?worksheet.Cells;
??????????????????????
????????????//Excel.Range?ran?=?range.get_Range（“A5“?“A5“）;
????????????//ran.AddComment（“批注“）;
????????????Excel.Range?ran1?=?worksheet.Columns.get_Range（“H:H“?Type.Missing）;//或者.get_Range（“D1“?“D1“）.get_Resize（501）;//獲取一整列D，行數為50???
????????????ran1.Validation.Delete（）;//有無都可以
????????????ran1.Validation.Add（Excel.XlDVType.xlValidateList?Excel.XlDVAlertstyle.xlValidAlertStop?Type.Missing?“123“?Type.Missing）;?
????????????//填充值
????????????worksheet.Cells[1?1]?=?“用戶代碼“;
????????????worksheet.Cells[1?2]?=?“用戶名稱“;
????????????worksheet.Cells[1?3]?=?“績效積分項“;
????????????worksheet.Cells[1?4]?=?“績效積分時間“;
????????????worksheet.Cells[1?5]?=?“描述“;
????????????//先把下拉框值賦值在Z列上
????????????worksheet.Cells[1?26]?=?“a“;
????????????worksheet.Cells[2?26]?=?“b“;
????????????worksheet.Cells[3?26]?=?“c“;
????????????//在把Z列值賦值到下拉框列上
????????????worksheet.get_Range（worksheet.Cells[1?3]?worksheet.Cells[10000?3]）.Validation.Add（Excel.XlDVType.xlValidateList?Excel.XlDVAlertstyle.xlValidAlertStop?Type.Missing?“=$Z$1:$Z$5“?Type.Missing）;
????????????
????????????//最后隱藏Z列
????????????Excel.Range?ranger?=?（Excel.Range）worksheet.Columns[“Z:Z“?System.Type.Missing];
????????????ranger.Hidden?=?true;
????????????//將文件保存到E:\\tt.xls
????????????workbook.SaveCopyAs（“E:\\tt.xls“）;
????????????workbook.Saved?=?true;
????????????xlApp.Visible?=?true;//打開Excel文件
????????????//?ran1.Validation.Modify（Excel.XlDVType.xlValidateList?Excel.XlDVAlertstyle.xlValidAlertStop?Type.Missing?“432“?Type.Missing）;//用此法方（Modify）可以對前面的下拉框進行修改，
????????}

????????//殺死進程
?????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????9728??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\bin\Debug\ExcelCreate.exe

?????文件??????26112??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\bin\Debug\ExcelCreate.pdb

?????文件??????14328??2009-12-18?17:25??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\bin\Debug\ExcelCreate.vshost.exe

?????文件????????490??2007-07-21?01:33??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\bin\Debug\ExcelCreate.vshost.exe.manifest

?????文件???????5287??2009-12-18?10:29??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\ExcelCreate.csproj

?????文件????????592??2009-12-18?10:29??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\ExcelCreate.csproj.user

?????文件???????3913??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Form1.cs

?????文件???????2029??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Form1.Designer.cs

?????文件???????5814??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Form1.resx

?????文件????????704??2009-12-18?17:25??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ExcelCreate.csproj.FileListAbsolute.txt

?????文件????????847??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ExcelCreate.csproj.GenerateResource.Cache

?????文件???????9728??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ExcelCreate.exe

?????文件????????180??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ExcelCreate.Form1.resources

?????文件??????26112??2009-12-18?17:24??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ExcelCreate.pdb

?????文件????????180??2009-12-18?10:29??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ExcelCreate.Properties.Resources.resources

?????文件???????8724??2009-12-18?10:29??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\ResolveAssemblyReference.cache

?????文件????????472??2009-12-18?10:16??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Program.cs

?????文件???????1400??2009-12-18?10:16??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Properties\AssemblyInfo.cs

?????文件???????2872??2009-12-18?10:16??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Properties\Resources.Designer.cs

?????文件???????5612??2009-12-18?10:16??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Properties\Resources.resx

?????文件???????1096??2009-12-18?10:16??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Properties\Settings.Designer.cs

?????文件????????249??2009-12-18?10:16??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Properties\Settings.settings

?????文件????????923??2009-12-18?10:29??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\WinformForExcel.sln

????..A..H.?????14336??2009-12-18?17:25??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\WinformForExcel.suo

?????目錄??????????0??2009-12-18?17:26??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug\TempPE

?????目錄??????????0??2009-12-18?17:26??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\bin\Debug

?????目錄??????????0??2009-12-18?17:26??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj\Debug

?????目錄??????????0??2009-12-18?17:26??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\bin

?????目錄??????????0??2009-12-18?17:26??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\obj

?????目錄??????????0??2009-12-18?17:26??用C#創建Excel，添加下拉框列，并動態給下拉框賦值\WinformForExcel\ExcelCreate\Properties

............此處省略6個文件信息