C#第三次作业--c#读取Excel文件

来源：互联网发布：购物软件有哪些编辑：程序博客网时间：2024/05/17 06:36

作业要求

目标1：C#读取Excel文件
目标2：C#读取Excel文件，并保存成HTML格式

这里我完成了目标1

实现代码：

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.OleDb;namespace ReadExcel{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        public DataSet ExcelToDS(string path)        {            string strConn = "Provider=Microsoft.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$]";            myCommand = new OleDbDataAdapter(strExcel, strConn);            DataTable table1 = new DataTable();            ds = new DataSet();            myCommand.Fill(table1);            dataGridView1.DataSource = table1;            return ds;        }        private void button1_Click(object sender, EventArgs e)        {            if(openFileDialog1.ShowDialog()==DialogResult.OK)            {                string filename = openFileDialog1.FileName;                ExcelToDS(filename);            }        }    }}

参考文献点击打开链接

附截图：

0 0