Click here to Skip to main content
15,891,777 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi. Having a grid with with, let's say, the A column and 1 line filled with headers and an excel sheet with the same headers but with values in all other cells is it possibly to match two values from the grid with the same two values from the excel sheet and retrieve the corresponding value from the excel to the grid? Let's say the pair line 3 column E of the grid match Excel sheet's Line 1 column B, can we copy excel's B1 cell value to the grids E3 cell?

Hope it's not too confusing.

Thank you!
Posted

1 solution

The best way to do this would be to load the Excel data into a .NET Dataset and work with it from there. See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] for more information.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900