Hi, my name is Masahiko Kawaguchi. I am a statistician located in Okayama, Japan.
I have just posted JSL to combine multiple excel files in JMP user community. I would like to share it here too.Combine multiple excel files
Sometimes I have to combine a lot of excel files. But "Import multiple files" menu would not work for excel files properly. So I wrote a JSL for it and I would like to share it here. It starts with select an excel file and open it using excel import wizard. Then the script gets import settings and files list in the directory. Finally, open all excel files (.xls, xlsx, xlsm) in the directory and combine them. Final dataset contains source files column at the right end of the table.
I attached JMP add-in as well as JSL. I hope that this script will help your work. Any feedback would be really appreciated!
Kawaguchi-san,
This is a nice contribution. It might be better served as a post in the Gore Library, however.
Here in Discussions will get pushed down over time and be more difficult to find. Let me know if you need help re-posting it in the Library.
