Create sheet in excel attachment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2024 12:32 AM - edited ‎01-15-2024 12:33 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2024 01:13 AM
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]
****************************************************************************************************************