Select Code to Download

 
#!/usr/bin/perl
use warnings; 
...
  Result produced\n
#######################################\n"; 
exit;

 The contents of cereal.xls are as follows:
Sheet1
No.    Name    Sugar (g/100g)
...
1    Wheat    10
2    Maize    7
3    Rice    2.6

 The contents of pulse.xls are as follows:
Sheet1 
No.    Name    Sugar (g/100g)
...
1    Pea        5
2    Chickpea    8.4
3    Pigeonpea    7.6

 The contents of fruit.xls are as follows:
Sheet1
No.    Name    Sugar (g/100g)
...
1    Apple    0.3
2    Pear    0.4
3    Pineapple    0.5

 The desired result.xls file should look like:
Sheet1
No.    Name    Sugar (g/100g)
...
1    Apple    10
2    Pear    10
3    Pineapple    10

Sheet2
No.    Name    Protein (g/100g)
...
1    Apple    0.3
2    Pear    0.4
3    Pineapple    0.5