无需打开excel文件c＃.net即可读取数据 [英] Read data without opening excel file c# .net

问题描述

我有一个软件，其中数据存储在excel数据库列中的是Product_ID&描述。我已经包含了基于Product_ID显示结果的搜索功能。但问题是，当excel文件打开但我想在不打开excel文件的情况下读取数据时，它只检索/读取/搜索数据？有没有办法做到这一点????我的代码用于搜索 - ：

I've a software in which data is stored in excel database columns are Product_ID & Description. I've included searching feature which displays result based on Product_ID. But the problem is it only retrieves/read/search data when that excel file is open but i want to read data without opening excel file ? Is there any way to do this ???? My code is for searching -:

public Form3()
  {
      InitializeComponent();
  }

  private void button1_Click(object sender, EventArgs e)
  {
      srch();
  }

  private void srch()
  {
      DataTable sheetData = new DataTable();
      string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= 'c:\\Product Details.xlsx';Extended Properties='Excel 8.0;HDR=Yes;'";
      string query = "select * from [Sheet1$]" ;

      DataSet excelDataSet = new DataSet();
      OleDbDataAdapter da = new OleDbDataAdapter(query, strConn);
      da.Fill(excelDataSet);
      dataGridView1.DataSource = excelDataSet.Tables[0];
      DataView dv = ((DataTable)dataGridView1.DataSource).DefaultView;
      DataView dv_filter = new DataView();
      dv_filter.Table = excelDataSet.Tables[0];
      dv_filter.RowFilter = "Product_ID = '" + textBox1.Text + "'";
      dataGridView1.DataSource = dv_filter;

  }

推荐答案

;

DataSet excelDataSet = new DataSet（）;
OleDbDataAdapter da = new OleDbDataAdapter（query，strConn ）;
da.Fill（excelDataSet）;
dataGridView1.DataSource = excelDataSet.Tables [ 0 ];
DataView dv =（ （DataTable）dataGridView1.DataSource）.DefaultView;
DataView dv_filter = new DataView（）;
dv_filter.Table = excelDataSet.Tables [ 0 ];
dv_filter.RowFilter = Product_ID = ' + textBox1.Text + ';
dataGridView1.DataSource = dv_filter;

}

" ; DataSet excelDataSet = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(query, strConn); da.Fill(excelDataSet); dataGridView1.DataSource = excelDataSet.Tables[0]; DataView dv = ((DataTable)dataGridView1.DataSource).DefaultView; DataView dv_filter = new DataView(); dv_filter.Table = excelDataSet.Tables[0]; dv_filter.RowFilter = "Product_ID = '" + textBox1.Text + "'"; dataGridView1.DataSource = dv_filter; }

您好b $ b

查看此lin k



Excel c＃.net在不在后台打开Excel的情况下检索数据 [ ^ ]



希望你能得到想法

Hi
Check this link

Excel c#.net retrieving data without opening excel in the background[^]

hope u will get idea

这篇关于无需打开excel文件c＃.net即可读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！