4.2 Merge by column - same name and number of rows

 

We often need to merge some Excel files with the same number and name of rows by the column. For example:

Before merging:

Fruits.xlsx
imagepng

and

FruitStock.xlsx
imagepng

After merging:
imagepng

Script:

A
1 =file(“Fruits.xlsx”).xlsimport@t()
2 =file(“FruitStock.xlsx”).xlsimport@t()
3 =A1.new(Name,UnitPrice,A2(#).Stock,A2(#).MaximumStock)
4 =file(“FruitsPriceStock.xlsx”).xlsexport@t(A3)