469,950 Members | 2,328 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

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

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
Nov 21 '05 #1
1 2685
On Sun, 21 Nov 2004 21:51:16 -0800, "Mamatha" <ma***********@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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Steven Stewart | last post: by
6 posts views Thread by Elena | last post: by
4 posts views Thread by Jiro Hidaka | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
7 posts views Thread by Vanessa | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.