C# 利用Excel直接读取方法读取Excel进DataGridView
在winform里拖入一个datagridview控件,跟一个openfiledialog控件,这个例子的功能只是读取excel文件,其他的功能本人还在研究当中
献上代码
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 | 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 } } |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)