Multiple sheet in single excel file

[backspaceachus]

How to generate single excel(.xls) file with multiple sheets (different no of columns in each sheet) using spring mvc application?

sheet1 - Invoice 

Sheet2 - Customers 

 

[shreekrishna.shankhwar]

 

 

Set above properties as above .

1. ignore pagination must be set

2. Page break will be  required 

3. Each Page will above mentioned names

For Second Screen changes for you as below 

#Invoice/Customers

Try above changes I have mentioned all the changes required but didn't provide step by step guidence but this is working method  .