从Excel表读取数据 [英] Read Data from Excel Sheet

问题描述

我正在创建一个Windows窗体应用程序，我想使用OpenFileDialog打开Excel工作表并将其内容显示到gridview / ListView。请帮助我...

I am creating a Windows Forms application and i want to open a Excel sheet using OpenFileDialog and display its contents to a gridview/ListView. Please Help Me...

推荐答案

请参阅此链接。它与您的需求完全相同。



将数据从Excel导入到C＃中的DataGridView [ ^ ]



问候..：）

Refer this link. It is exactly the same what you need.

Import Data from Excel to DataGridView in C#[^]

Regards..:)

Change your Excel sheet into CSV file and try this:

FileUpload1.SaveAs(Server.MapPath("~/tmpdir/") + FileUpload1.FileName);
System.IO.StreamReader myFile = new System.IO.StreamReader(Server.MapPath("~/tmpdir/")    + FileUpload1.FileName);
string myString = myFile.ReadToEnd();
myFile.Close();
string[] lines = myString.Split(new string[] { Environment.NewLine },      StringSplitOptions.None);
 
foreach (string line in lines)
 {
     if (line != "")
      {
          string[] columns = line.Split(',');
 
          //Upload to your DB with your indexes

      }
     else
      {
 
      }
}

首先在 CodeProject [ ^ ]这将提供许多有用的答案。另见..

将数据从Excel导入到C＃中的DataGridView [ ^ ]

从Excel工作表检索数据到Listview [ ^ ]

如何打开Excel电子表格并将其读入.NETView中的ListView [ ^ ]

First have a search with your query in CodeProject[^] which will provide a number of helpful answers. Also see..
Import Data from Excel to DataGridView in C#[^]
Retrieve datas from Excel Sheet to Listview[^]
How To Open and Read an Excel Spreadsheet into a ListView in .NET[^]

这篇关于从Excel表读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！