elmnas
03-16-2015, 09:23 AM
Hi People,
I have made a script Export xldata:
that does following things:
I do recieve following files from clients,
there are loads sheets. also loads columns.
I have made a script that export
first all sheet to seperate files, give them following names: filename_sheetName.xls
I have a script that split each column in all seperated sheetfiles to a seperate file and give it the name from the first cell in the first row and same column in the end of the filename:
Filename_SheetName_Test.xls
Now I need to do the inverted thing
I need to import all Data
I need a script that
1. Merge columns on the same place in the sheets they are, then put them back in the orginalfile.
Could someone help me with a script.
Thank you in advance
I have made a script Export xldata:
that does following things:
I do recieve following files from clients,
there are loads sheets. also loads columns.
I have made a script that export
first all sheet to seperate files, give them following names: filename_sheetName.xls
I have a script that split each column in all seperated sheetfiles to a seperate file and give it the name from the first cell in the first row and same column in the end of the filename:
Filename_SheetName_Test.xls
Now I need to do the inverted thing
I need to import all Data
I need a script that
1. Merge columns on the same place in the sheets they are, then put them back in the orginalfile.
Could someone help me with a script.
Thank you in advance