{"id":2469,"date":"2024-05-27T17:33:34","date_gmt":"2024-05-27T17:33:34","guid":{"rendered":"\/agile\/?post_type=ht_kb&#038;p=2469"},"modified":"2024-08-08T20:42:38","modified_gmt":"2024-08-08T20:42:38","slug":"export-schedules-to-excel","status":"publish","type":"ht_kb","link":"\/agile\/knowledge-base\/export-schedules-to-excel\/","title":{"rendered":"Export Schedules to excel"},"content":{"rendered":"\n<p>This feature allows user to download the excel-format schedule for the selected employees and date range.<\/p>\n\n\n\n<p><strong>How to export the schedules to excel:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the&nbsp;<strong>Schedules<\/strong>&nbsp;from the side menu.<\/li>\n\n\n\n<li>Select&nbsp;<strong>employees<\/strong>, user wish to generate the schedule excel report, from the employee selector.<\/li>\n\n\n\n<li>Click on the&nbsp;<strong>Actions<\/strong>&nbsp;button appearing on top-right corner.<\/li>\n\n\n\n<li>Click on&nbsp;<strong>Export Schedules to Excel<\/strong><\/li>\n\n\n\n<li>Once user clicks on it, it will download the excel sheet with schedule info.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1919\" height=\"924\" src=\"\/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16.png\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-2470\" srcset=\"\/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16.png 1919w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-300x144.png 300w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-1024x493.png 1024w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-768x370.png 768w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-50x24.png 50w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-1536x740.png 1536w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-60x29.png 60w, \/agile\/wp-content\/uploads\/sites\/2\/2024\/05\/a-screenshot-of-a-computer-description-automatica-16-100x48.png 100w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><\/figure>\n\n\n\n<p>Excel sheet shows the<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Schedule grid of selected date range.<\/li>\n\n\n\n<li>Employee Total, Date Total, and Grand Total.<\/li>\n\n\n\n<li>The excel should reflect the schedule grid (with schedule, partial absence with hours &amp; time category name, full shift absence, and stat holiday (if any)).<\/li>\n\n\n\n<li>export all the 3 columns (Employee name, Department, and Seniority) irrespective of the columns chosen on the grid.<\/li>\n<\/ul>\n\n\n\n<p>Excel sheet will not show the<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>job\/ dept schedule info (SSLA)<\/li>\n\n\n\n<li>Notes<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This feature allows user to download the excel-format schedule for the selected employees and date range. How to export the schedules to excel: Excel sheet shows the Excel sheet will not show the<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"ht-kb-category":[106],"ht-kb-tag":[],"class_list":["post-2469","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-bolt-scheduler"],"_links":{"self":[{"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/ht-kb\/2469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/comments?post=2469"}],"version-history":[{"count":2,"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/ht-kb\/2469\/revisions"}],"predecessor-version":[{"id":2487,"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/ht-kb\/2469\/revisions\/2487"}],"wp:attachment":[{"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/media?parent=2469"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/ht-kb-category?post=2469"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.synerion.com\/agile\/wp-json\/wp\/v2\/ht-kb-tag?post=2469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}