JOIN DEVPPL

It looks like you are new here. If you want to get involved, click on Join below!



how to copy specific data from a file to excel in vb 2010


G

keyboard_arrow_up
0
keyboard_arrow_down


First Post Mark as Spam gvgbabu
Posts: 2 - Registered: 2013-09-22 06:30:08

hi

i am very new to vb 2010 programming

i am learning it and improving

i am able to open a text file and copy the entire file to excel sheet

but i want to copy some part of the text file to excel file only how to do please guide me

for example

i have a text file with a lot of data

some data
........
........
.......
......

JOINT COORDINATES
-----------------
COORDINATES ARE METE UNIT

JOINT X Y Z


1 0.000 0.000 5.203
2 0.000 0.000 9.015
3 0.000 0.000 12.933
4 0.000 0.000 14.363
5 0.000 0.000 19.740
6 0.000 0.000 25.120
..................
........................................
.....................
960 21.966 12.400 5.203
961 17.505 12.400 5.203
962 34.107 12.400 14.360
963 28.735 12.400 14.360
964 21.966 12.400 14.360
965 17.505 12.400 14.360
966 12.132 12.400 14.360


************ END OF DATA FROM INTERNAL STORAGE ************
..................
.....................
some data
..................
................
...................

i want to extract data only the rows starting from 1 to 966 and paste in a excel sheet at a particular cells.

please guide me

gvg




G

keyboard_arrow_up
0
keyboard_arrow_down


Reply #1 Mark as Spam gvgbabu
Posts: 2 - Registered: 2013-09-22 06:30:08

HI
its more than 1100 views in one day

but there is no reply from any one

please guide me

gvg






JOIN DEVPPL

It looks like you are new here. If you want to get involved, click on Join below!




MENU
Advertising