C# connection with Excel

lankapala
lankapala used Ask the Experts™
on
Hi, I need to write C# programme to connect with excel not ODBC. See attached screnshot
after write C# programme ability create connection.
connections.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
David Johnson, CD
Top Expert 2016

Commented:
That is connecting excel to a database, not connecting to excel.
Software Team Lead
Commented:
it would be probably easy to connect to excel using an OLEDB Data Object Library.

you can refer to this article for more info.

Read Excel file using OLEDB Data Provider in C# .Net
https://www.aspsnippets.com/Articles/Read-Excel-file-using-OLEDB-Data-Provider-in-C-Net.aspx

so, treat your Excel as a data source.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial