在c＃中导入excel表 [英] importing excel sheet in c#

问题描述

hi


i需要导入excel表



excel表包含假设3工作表



例如：Sheet1，sheet 2，sheet3，



导入作为节点附加的工作表到treecontol



当我加倍点击该节点时，该工作表的内容显示在数据网格视图中



每张纸张1200行和5列命名为a，b，c，d，e



并且每列都包含一些数据..



请帮帮我..

in c＃winform ..

hi
i need to import excel sheet

that excel sheet contains suppose 3 worksheet

eg:Sheet1,sheet 2,sheet3,

after importing that work sheet attached as a node to treecontol

and when i doubbled click on that node the content of that work sheet display in datagrid view

each sheet contaion 1200 row and 5 column named as a,b,c,d,e

and each column contaion some data ..

please help me out..
in c# winform..

推荐答案

看看这里：

如何使用ADO.NET在Visual Basic .NET的Excel工作簿中检索和修改记录 [< a href =http://support.microsoft.com/kb/316934target =_ blanktitle =新窗口> ^ ]

使用MS Excel和ADO.NET [ ^ ]

使用ADO.Net和C＃读取和导入Excel工作表 [ ^ ]

Have a look here:
How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^]
Work with MS Excel and ADO.NET[^]
Read and Import Excel Sheet using ADO.Net and C#[^]

这篇关于在c＃中导入excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！