how to connect to excel sheet?

  • 15 years ago

    Please help me...


    I can't find a way to connect to a Excel file...


    How to do it?


    thank you

  • 15 years ago

    oh and by the way, also how to get the content of specific row and set the content of a row

  • 15 years ago

    You can use automation to control an instance of Excel directly or you can use ADO.NET to access Excel just like any other database.  Go to MSDN on-line and search for "Excel automation .NET" or "Excel ADO.NET" (both without the quotes).

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There's no test like production” - Anon