fods | FoDS – Failover DataSource | Database library

I have several excel worksheets in unix environment. My goal is to merge them into one single workbook in unix environment itself.

I found a found solution using xsltproc which sort of works, but doesnt do the job completely. (merge mutliple excel files into one excel workbook but different worksheets using bash scripting)

Here's my current workflow as per the answer provided in the above link :

1. Convert each *.xlsx sheet to *.fods files

soffice --headless --convert-to fods file*.xlsx

1. Use xsltproc to merge *.fods sheets one by one, to get a workbook which will contain all sheets.
2. Convert the *.fods workbook back to *.xlsx using below command :

soffice --headless --convert-to xslx outputfile*.fods

The place I'm stuck is at #2. The original answer in the link provides a xsltproc based solution which can merge two sheets. I am trying to extend it incrementally by below method :

xsltproc --stringparam secondfile file2.fods tablemerge.xsl file1.fods > int_2.fods

xsltproc --stringparam secondfile file3.fods tablemerge.xsl int_2.fods > final.fods

It works perfectly as long as only 2 sheets are to be combined, but behaves unexpectedly the moment I try to add file3.fods to the intermediate file int_2.fods.

The problem I see is the final.fods contains two copies of the worksheet in file3.fods .

I suspect its a problem with the tablemerge.xsl file, which contains contains some xml syntax (below) towards the end. The issue is I dont have any clue how xml works, but the syntax seems not very complicated. Any help to suggest what modification is required in below code will be very helpful. Thanks in advance.

tablemerge.xsl: