I am interested in a way to merge/copy sheets from multiple Excel files into a single Excel file. Some tool or script (python/java?) that will work in Unix and Windows systems, with/without MS Excel installed. While preserving existing cell format/style.
Something equivalent to going over each sheet and copying all the data into a new sheet in a single(new) Excel file (and keeping the format/style - I've found some scripts that dont preserve styles, like pandas in python).