Need some work done? Post a Project Today
about 1600 excel files in a folder.
and about 50200 rows in a xls file.
i want to make it a csv file.
i think it needs poi library.
that is to say in specific folder named like 110112, there are lots of excel files about 1600 ea. but it could be variable.
and i want to make it a csv file.
the file name is like LowData_20110112_000005_PM108.xls .
but let it keep order following file name. * the file names show each time.
LowData_20110112_000005_PM108.xls -> LowData_20110112_000030_PM108.xls -> LowData_20110112_000055_PM108.xls -> LowData_20110112_000121_PM108.xls -> ...
and the output file would be LowData_20110112.csv
So load all the excel files in a folder like 110112 or some other name or same folder with this java excution file.
And unify all datum in order <-- important.
And the output file type is csv.
And the name of output file is LowData_xxxxxx.csv (xxxxxx is following the files)
the attached file is some of the excel files. because the all excel files' size is over 4.5G.