f******g 发帖数: 423 | 1 I need to copy the 1st, 11st, 21st.... 10001th line from an excel spread
sheet to another, I guess using VB will be the best solution. any body can
help me? I will spend sometime to learn it later, but currently this task is
killing me. | t**m 发帖数: 263 | 2 find some api to read and write spread sheet data.
is
【在 f******g 的大作中提到】 : I need to copy the 1st, 11st, 21st.... 10001th line from an excel spread : sheet to another, I guess using VB will be the best solution. any body can : help me? I will spend sometime to learn it later, but currently this task is : killing me.
| h***s 发帖数: 19 | 3 MACRO?
is
【在 f******g 的大作中提到】 : I need to copy the 1st, 11st, 21st.... 10001th line from an excel spread : sheet to another, I guess using VB will be the best solution. any body can : help me? I will spend sometime to learn it later, but currently this task is : killing me.
| r****y 发帖数: 26819 | 4 VBscript is easiest way.
is
【在 f******g 的大作中提到】 : I need to copy the 1st, 11st, 21st.... 10001th line from an excel spread : sheet to another, I guess using VB will be the best solution. any body can : help me? I will spend sometime to learn it later, but currently this task is : killing me.
| f******g 发帖数: 423 | 5 I am using macro for the copy and paste line action. but I don't know how to
automatically find next line. | t*********s 发帖数: 5 | 6 under *nux, this is only one-line stuff
awk '!((NR-1)%10)' in.csv > out.csv
is
【在 f******g 的大作中提到】 : I need to copy the 1st, 11st, 21st.... 10001th line from an excel spread : sheet to another, I guess using VB will be the best solution. any body can : help me? I will spend sometime to learn it later, but currently this task is : killing me.
|
|