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

M

Mamatha

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
 
P

Paul Clement

¤ 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Read Data from text using OLEDB in VB.NET 2005 1
fill a text file data to datagridview 0
how to include external to VB.NET 1
Excel, assign cells in multiple worksheets from one sheet 1
datagridview problem 1
write special chars to textfile 1
Emulating keyboard strokes in vb.net 3

Top