Query excel sheet in c#

by

The Select-command should look like this if you want to read A1 to D1:

SELECT * FROM [SHEETNAME_HERE$A1:D1]

Whole Code:

OleDbConnection con = new OleDbConnection(
    "provider=Microsoft.Jet.OLEDB.4.0;data source="
    + XLS_FILE_NAME_AND_PATH_HERE
    + ";Extended Properties=Excel 8.0;");

StringBuilder stbQuery = new StringBuilder();
stbQuery.Append("SELECT * FROM [" + SHEETNAME_HERE + "$A1:D1]");
OleDbDataAdapter adp = new OleDbDataAdapter(stbQuery.ToString(), con);

DataSet dsXLS = new DataSet();
adp.Fill(dsXLS);

DataView dvEmp = new DataView(dsXLS.Tables[0]);

dataGridView1.DataSource = dvEmp;

More Related Contents:

  1. Reading Excel files from C#
  2. How to detect installed version of MS-Office?
  3. Cell color changing in Excel using C#
  4. How to read data from excel file using c# [duplicate]
  5. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  6. Accessing an open Excel Workbook in C#
  7. Export DataTable to Excel with EPPlus
  8. Excel Interop – Efficiency and performance
  9. Fastest way to interface between live (unsaved) Excel data and C# objects
  10. How to read file using NPOI
  11. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  12. How to create CSV Excel file C#? [closed]
  13. How to open an Excel file in C#?
  14. C# create/modify/read .xlsx files
  15. How to read single Excel cell value
  16. Programmatically getting the last filled excel row using C#
  17. OpenFileDialog can’t load CSV files but can load xls/xlsx Excel files [duplicate]
  18. Resources for learning c# Excel interop [closed]
  19. Read excel file from a stream
  20. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  21. Reading from Excel (Range into multidimensional Array) C#
  22. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  23. How to read more than 256 columns from an excel file (2007 format) using OLEDB
  24. How do I get an Excel range using row and column numbers in VSTO / C#?
  25. openxml spreadsheat save-as
  26. Printing Excel using Interop
  27. How to import all the Excel sheets to DataSet in C#
  28. Scientific notation when importing from Excel in .Net
  29. Import Excel to Datagridview
  30. How to create Excel file using OpenXML without creating a local file?

Leave a Comment