Tell me how to read information from Excel in TextBox.

2 answers 2

Hello, you have at least a few options, for example

  1. Interop Opening and Navigating Excel
  2. OleDb Reading / Writing Excel using OLEDB

I would recommend you use the oleDb approach

    I threw a very unpretentious minimalistic implementation through Interop in a parallel question. It is rather slow, but quite working.

    Separate the table cells by a comma, reading them line by line from the Excel file.

    It is quite possible that for your tasks this implementation will be enough.

    UPD: Wrote faster libu. You will find her here:

    How easy it is to work with / open / edit / save Excel / CSV files

    • Add another code sample, how to accomplish the task with the help of your library - and the answer will be just great. (The library code does not need to be rewritten, just how to connect and use.) - Nick Volynkin ♦
    • In general, there is already an example of using the link. How to connect - copy the code and install the NuGet that it asks. Everything. - Andrew