PDA

View Full Version : [SOLVED] Import script help.



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

apo
03-18-2015, 06:16 AM
I think your post will receive more help if you attach some sample files...


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

Without knowing much about your requirements.. that seems a bit excessive?