locked
Referencing an excel data table in C# RRS feed

  • Question

  • I'm trying to reference an excel data table in C# without much success.  I'm finding examples of creating a new data table, but I have an existing table that I'd like to read.

    I can process through each cell via row/col looping however, is there a way to access the column via the column names?


    ruth

    Friday, August 17, 2018 1:17 AM

All replies

  • If you mean reference tables see my code sample (it has VB.NET and C# while the C# has a class but does not show usage as well as the VB.NET but enough to get you going).

    https://code.msdn.microsoft.com/Working-with-Excel-cdd73a85?redir=0


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Friday, August 17, 2018 1:41 AM