Connecting Tech Pros Worldwide Forums | Help | Site Map

How to Export data from textfile to Excel sheet in VB.NET

Mamatha
Guest
 
Posts: n/a
#1: Nov 21 '05
Hi

I want to export data from textfile to Excel sheet in
VB.NET application.When i copy the text file into Excel
sheet the data of text file are copied to only one cell of
the Sheet.
Now i want like this: Each item of the textfile will be
displayed into different cell of the sheet(one item
corresponds to one cell horizontally).How can write code
for this in VB.NET.

Mamatha

Paul Clement
Guest
 
Posts: n/a
#2: Nov 21 '05

re: How to Export data from textfile to Excel sheet in VB.NET


On Sun, 21 Nov 2004 21:51:16 -0800, "Mamatha" <mail2mamathak@yahoo.com> wrote:

¤ Hi
¤
¤ I want to export data from textfile to Excel sheet in
¤ VB.NET application.When i copy the text file into Excel
¤ sheet the data of text file are copied to only one cell of
¤ the Sheet.
¤ Now i want like this: Each item of the textfile will be
¤ displayed into different cell of the sheet(one item
¤ corresponds to one cell horizontally).How can write code
¤ for this in VB.NET.

Could you post a few lines of your text file?


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
Closed Thread