Create sheet in excel attachment

Rj27
Mega Guru

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.

 




1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

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?

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************