WinForm读取Excel文件
来源:互联网 发布:lol遇到网络问题 编辑:程序博客网 时间:2024/05/16 19:49
- /// <summary>
- /// 导入Excel文件,并显示在列表
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void btnImport_Click(object sender, EventArgs e)
- {
- string worksheetname = string.Empty;
- importtpye = cmbTicketType.Text;
- supplier = cmbSupplier.SelectedValue.ToString();
- #region 导入本地Excel文件
- //导入本地文件
- OpenFileDialog file = new OpenFileDialog();
- file.Filter = "文档(*.xls)|*.xls";
- if (file.ShowDialog() == DialogResult.OK)
- btnImport.Tag = file.FileName;
- //判断有没有文件导入
- if (file.FileName.Length == 0)
- {
- MessageBox.Show("请选择要导入的文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- return;
- }
- #endregion
- #region 获取Excel的工作表名称
- //创建Excel实例,获取worksheet Name
- Microsoft.Office.Interop.Excel.Application oExcel = new Microsoft.Office.Interop.Excel.Application();
- object objMissing = System.Reflection.Missing.Value;
- Microsoft.Office.Interop.Excel.Workbook myBook = (Microsoft.Office.Interop.Excel.Workbook)oExcel.Workbooks.Open(file.FileName, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing);
- Microsoft.Office.Interop.Excel.Sheets sheets = myBook.Worksheets;
- Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
- worksheetname = worksheet.Name;//获取worksheet Name
- oExcel.Quit();
- #endregion
- dataTable.Rows.Clear();
- //将Excel表中的数据导入到Datatable中
- DataTable table = LoadExcelToDataTable(file.FileName, worksheetname);
- }
- /// <summary>
- /// 加载Excel表到DataTable,跟原始Excel表形式一样,需要筛选自己有用的数据
- /// </summary>
- /// <param name="filename">需要读取的Excel文件路径</param>
- /// <param name="sheetname">工作表名称</param>
- /// <returns>DataTable</returns>
- public static DataTable LoadExcelToDataTable(string filename, string worksheetname)
- {
- DataTable table;
- //连接字符串
- String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filename + ";" + "Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
- OleDbConnection myConn = new OleDbConnection(sConnectionString);
- string strCom = " SELECT * FROM [" + worksheetname + "$]";
- myConn.Open();
- OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
- table = new DataTable();
- myCommand.Fill(table);
- myConn.Close();
- return table;
- }
- //连接字符串
- String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" +
- filename + ";" + "Extended Properties=Excel 8.0;";
- //连接字符串
- String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filename + ";" + "Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
阅读全文
0 0
- WinForm读取Excel文件
- WinForm读取Excel文件
- WinForm读取Excel文件
- C# Winform读取Excel
- winform中 如何读取Excel文件,之后再把它写入一个新的Excel文件
- winform操作Excel文件
- winform 导出excel文件
- C# WinForm创建Excel文件
- C#Winform读取txt文件
- C#winform读取.txt文件
- 读取Excel文件
- 读取Excel文件
- 读取excel文件
- 读取Excel文件
- 读取excel文件
- java读取excel文件
- java读取excel 文件
- 读取excel文件 C#
- Educational Codeforces Round 25A-G题解
- Android 百度地图
- tensorflow实现AlexNet
- linux设备驱动中重要的3个数据结构 &&Linux设备驱动模型几个基本数据结构模型:kobject,kset,subsystem
- %type与%rowtype的区别
- WinForm读取Excel文件
- CryptoJS中AES256(CBC)加密算法简单使用
- c++调用lua时简单打印lua栈
- 偏离路 k小路模板 poj2449Remmarguts' Date
- NodeJs 新建项目
- Mybatis下划线处理
- 软件设计模式
- linux上搭建AvtiveMQ的过程以及503异常的解决
- 欢迎使用CSDN-markdown编辑器