用VBA遍历Excel中的数据
前段时间做一个数据导入的东西,数据源是excel,里面数据不太工整,需要对于所有行进行一定的操作。
请教了一下同事,写了一点vba代码处理excel,代码比较简单,就不作太多的说明了,看注释足以 :)
Const START_ROW = 1
Const END_ROW = 3000
'目标列
Const COL_TARGET = 1
'数据源列
Const COL_SOURCE = 2
These were the top 10 stories published by JIN Weijie in 2008. You can also dive into monthly archives for 2008 by using the calendar at the top of this page.