c#利用Excel直接读取数据到DataGridView
时间:2023-02-22 13:39:07
在winform里拖入一个datagridview控件,跟一个openfiledialog控件
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Microsoft.Office.Core;
using Excel=Microsoft.Office.Interop.Excel;
using System.Windows.Forms;
using System.Reflection;
namespace Excelproject
{
public partial class ExcelForm : Form
{
private ExcelOperate eo;
private string excelpath;
private Excel.Application excel1;
private Excel.Workbooks wbs = null;
private Excel.Workbook wb = null;
private Excel.Sheets wss;
private Excel.Worksheet ws = null;
private Excel.Range range1 = null;
public ExcelForm()
{
InitializeComponent();
this.excel1 = new Excel.Application();
if (excel1 == null)
{
MessageBox.Show("error");
System.Windows.Forms.Application.Exit();
}
excel1.Visible = true;
}
#region excel文件打开关闭操作
private void 打开_Click(object sender, EventArgs e)
{
openFileDialog1 = new OpenFileDialog();
openFileDialog1.Title = "打开excel文件";
openFileDialog1.Filter = "excel03文件(*.xls)|*.xls|excel07文件(*.xlsx)|*.xlsx";
openFileDialog1.InitialDirectory = @"C:\Users\Administrator\Desktop";
openFileDialog1.RestoreDirectory = true;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
//打开文件对话框选择的文件
excelpath = openFileDialog1.FileName;
eo = new ExcelOperate();
readExcel(excelpath);
}
}
void readExcel(string path)
{
object miss = System.Reflection.Missing.Value;
excel1.UserControl = true;
excel1.DisplayAlerts = false;
excel1.Application.Workbooks.Open(excelpath, miss, miss, miss, miss,
miss, miss, miss, miss,
miss, miss, miss, miss,
miss, miss);
wbs = excel1.Workbooks;
wss = wbs[1].Worksheets;
ws = (Excel.Worksheet) wss.get_Item(1);
int rowNum = ws.UsedRange.Cells.Rows.Count;
int colNum = ws.UsedRange.Cells.Columns.Count;
string cellStr = null;
char ch = 'A';
for (int i = 0; i < colNum; i++)
{
dataGridView1.Columns.Add(i.ToString(), ch.ToString());
dataGridView1.Rows.Add(rowNum);
for (int j = 0; j <rowNum; j++)
{
cellStr = ch.ToString() + (j + 1).ToString();
dataGridView1[i, j].Value = ws.UsedRange.Cells.get_Range(cellStr, miss).Text.ToString();
}
ch++;
}
}
#endregion
}
}
标签:Excel,DataGridView,c#
0
投稿
猜你喜欢
利用枚举法求直方图中最大矩形面积的方法实例
2022-06-22 21:16:31
android开发之listView组件用法实例简析
2023-02-05 10:31:52
C#实现WPF项目复制和移动文件夹
2023-06-07 16:49:16
详解Spring Cloud Zuul中路由配置细节
2022-07-31 06:55:45
Java栈之链式栈存储结构的实现代码
2022-01-18 09:38:48
Android ListView滑动改变标题栏背景渐变效果
2022-07-01 04:00:59
JAVA实现心跳检测(长连接)
2022-12-16 04:26:30
SpringMvc接收参数方法总结(必看篇)
2022-10-02 12:28:54
TCP协议详解_动力节点Java学院整理
2022-09-22 07:55:14
Java中的ThreadLocal详解
2023-01-02 16:02:21
Android动态添加碎片代码实例
2023-10-19 23:35:13
MyBatis Plus插件机制与执行流程原理分析详解
2021-10-09 20:53:48
Android4.0平板开发之隐藏底部任务栏的方法
2023-11-29 15:11:44
C++实现的O(n)复杂度内查找第K大数算法示例
2023-06-30 15:51:13
解析Android获取系统cpu信息,内存,版本,电量等信息的方法详解
2023-11-20 10:50:15
Java 8中的18个常用日期处理(收藏)
2023-03-02 02:01:54
详解Android 全局弹出对话框SYSTEM_ALERT_WINDOW权限
2023-06-28 04:07:44
Java异常的处理机制
2023-12-03 15:33:19
opencv检测直线方法之投影法
2023-08-28 04:43:15
C#多线程之线程控制详解
2022-02-04 17:51:44