技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 238
|
本帖最后由 faunus 于 2014-2-28 16:42 編輯
這是剛擼的代碼,新鮮熱辣。作用嘛就是為了將"數(shù)據(jù)表"中A列的單位名稱去重后放到碗里去(combobox控件)。閑話不講,直接上代碼:
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using System.Xml.Linq;
- using Microsoft.Office.Tools.Excel;
- using Microsoft.VisualStudio.Tools.Applications.Runtime;
- using Excel = Microsoft.Office.Interop.Excel;
- using Office = Microsoft.Office.Core;
- namespace Test
- {
- public partial class Sheet1
- {
- private void Sheet1_Startup(object sender, System.EventArgs e)
- {
- Excel.Worksheet shD = Application.ActiveWorkbook.Worksheets["數(shù)據(jù)表"];
- Excel.Range rnAll = shD.Range["A2:A" + Convert.ToString(shD.Range["A1"].End[Excel.XlDirection.xlDown].Row)];
- Dictionary<String,Int32> dicName1 = new Dictionary<string,Int32>();
- String valStr;
- foreach (Excel.Range rn in rnAll)
- {
- valStr = Convert.ToString(rn.Value);
- dicName1[valStr] = rn.Row;
- }
- Dictionary<string, Int32>.KeyCollection keyColl = dicName1.Keys;
- foreach (string s in keyColl)
- {
- comboBox1.Items.Add(s);
- }
- }
- private void Sheet1_Shutdown(object sender, System.EventArgs e)
- {
- }
- #region VSTO 設(shè)計(jì)器生成的代碼
- /// <summary>
- /// 設(shè)計(jì)器支持所需的方法 - 不要
- /// 使用代碼編輯器修改此方法的內(nèi)容。
- /// </summary>
- private void InternalStartup()
- {
- this.Startup += new System.EventHandler(this.Sheet1_Startup);
- this.Shutdown += new System.EventHandler(this.Sheet1_Shutdown);
- }
- #endregion
- public EventHandler comboBox1_SelectedIndexChanged { get; set; }
- public MouseEventHandler comboBox1_MouseClick { get; set; }
- public Excel.DocEvents_ActivateEventHandler Sheet1_ActivateEvent { get; set; }
- public Excel.DocEvents_ChangeEventHandler Sheet1_Change { get; set; }
- }
- }
復(fù)制代碼 下面是附件,有興趣的盆友可下載了試一試。
能想到的運(yùn)行環(huán)境(office2010-vs2010),在此謝謝(佛爺、汪老師、西西)
|
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒(méi)有帳號(hào)?注冊(cè)
x
評(píng)分
-
查看全部評(píng)分
|