-
Import script help.
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 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?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules