Create a text file with tab delimiters

  • Thread starter Thread starter shantanu
  • Start date Start date
S

shantanu

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
 
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.
 
Back
Top