Why not just read the file into a string, and then call the Split method
using the tab character as the delimiter? You will then have the headers
that you need to find the data for, and you can automate excel (or use an
OLEDB provider for Excel) to get the data you need.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"shantanu" <sh***********@gmail.comwrote in message
news:11**********************@a26g2000pre.googlegr oups.com...
Hi all
I have two coloumns in a excel worksheet where the first coloumn is a
header and the second coloumn is a corresponding value. Also i have a
text file That contains header and values in a tabdelimited format.
Now the requirement is like I have to compare the Headers in excel
with the headers in the text file and write the corresponding values
from the excel in the text file. Can somebody help.
Regards
Shantanu