How to merge multiple excel forms into a new one？

[FrimanDub]

There are several excel files and each of them have more than one work sheet. I am trying to merge all of them into one excel file. Here's the problem：I didn't find the right single function. Instead, I read every cell to store the value and its format, then writing in a new excel file. But, the format seems doesn't work. So, how shoud I do to accomplish this task? Thank you in advance for your help!

[LiuLikeQian]

it don't work maybe your format is very diffcult. u can try to merge it and reset the format and don't use it which was set by the other pepole

[j2doll]

Dear @FrimanDub

QXlsx does not have that feature. However, it seems that it is possible to create a corresponding function by combining sub-functions.