Create sheet in excel attachment

[Rj27]

Hello,

Can we create multiple sheet in one excel attachment ?

Eg: For any user list..my sheet has following columns : Name, Employee id, Email id, location

For each user, some value can be missing. Currently in my attachemnt that sheet1 has all the records.
i want to segregate data as such in sheet 1 all the records,

in sheet 2 user records for which employee id is missing

in sheet 3 user records for which email id is missing 
in sheet 4 user records for which location is missing

I can directly give filter in excel to filter records but i want to create different sheets in one excel. Is this doable ?

This excel is generated from import.

 

[Dr Atul G- LNG]

Hi @Rj27 

Can we create multiple sheet in one excel attachment ?

Atul: If you speaking only from excel side, then yes.

Eg: For any user list..my sheet has following columns : Name, Employee id, Email id, location

For each user, some value can be missing. Currently in my attachemnt that sheet1 has all the records.
i want to segregate data as such in sheet 1 all the records,

in sheet 2 user records for which employee id is missing

in sheet 3 user records for which email id is missing 
in sheet 4 user records for which location is missing

I can directly give filter in excel to filter records but i want to create different sheets in one excel. Is this doable ?

This excel is generated from import.

Atul: NOT a straight forward, bcz OOTB excel export contain one sheet and this is too much customization. Any specific business case for this?