Reading Excel files from C#
var fileName = string.Format("{0}\fileNameHere", Directory.GetCurrentDirectory());
var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", fileName);
var adapter = new OleDbDataAdapter("SELECT * FROM [workSheetNameHere$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "anyNameHere");
DataTable data = ds.Tables["anyNameHere"];how to get all excel files from a folder in c#
using System;
using System.IO;
namespace FileOperationsSample
{
class Program
{
static void Main(string[] args)
{
// Change this path to the directory you want to read
string path = "C:\Junk";
DirectoryInfo dir = new DirectoryInfo(path);
Console.WriteLine("File Name Size Creation Date and Time");
Console.WriteLine("=================================================================");
foreach (FileInfo flInfo in dir.GetFiles())
{
String name = flInfo.Name;
long size = flInfo.Length;
DateTime creationTime = flInfo.CreationTime;
Console.WriteLine("{0, -30:g} {1,-12:N0} {2} ", name, size, creationTime);
}
Console.ReadLine();
}
}
}Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
