- 目标1:用C#读取Excle文件内容
- //代码实现
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Data.OleDb;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- namespace WRExc
- {
- public partial class form1 : Form
- {
- public form1()
- {
- InitializeComponent();
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- }
- private void button1_Click(object sender, EventArgs e)
- {
- OpenFileDialog openfile = new OpenFileDialog();
- openfile.Filter = "工作薄(*.xls)|*.xls|所有文件(*.*)|*.*"; //用Filter属性设置文件格式
- //点击“打开”窗体显示文件内容
- if (openfile.FilterIndex == 1 && openfile.ShowDialog() == DialogResult.OK)
- dataset1(openfile.FileName); //使用dataset组件
- }
- private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
- {
- }
- public DataSet dataset1(string path) //文件路径设置
- {
- string strConn = "ProviderMICROSOFT.Jet.OLEDB.4.0;" + "Data Source=" + @path + ";" + "Extended Properties=Excel 8.0;";
- OleDbConnection conn = new OleDbConnection(strConn);
- conn.Open();
- string strExcel = "";
- OleDbDataAdapter myCommand = null;
- DataSet ds = null;
- strExcel = "select * from [sheet1$]"; //SQL语句选择表内容
- myCommand = new OleDbDataAdapter(strExcel, strConn); //调用OleDbDataAdapter()方法复制给myCommand
- DataTable table1 = new DataTable();
- ds = new DataSet();
- myCommand.Fill(table1);
- dataGridView1.DataSource = table1;
- return ds;
- }
- }
- }
- 演示结果:
- 1窗体界面
- <img src="https://img-blog.csdn.net/20150508211622979?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvcHkxOTk0ODI5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="" />
- 2点击打开后续
- <img width="677" height="475" style="width: 549px; height: 290px;" src="https://img-blog.csdn.net/20150508211653929?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvcHkxOTk0ODI5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="" />
- 3选择事例文件后窗体显示结果
- <img src="https://img-blog.csdn.net/20150508211604630?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvcHkxOTk0ODI5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="" />
- 完成目标要求,这次程序主要难点在于怎么读取Excle