{"id":11512,"date":"2021-12-08T04:42:15","date_gmt":"2021-12-08T04:42:15","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=11512"},"modified":"2021-12-08T04:42:33","modified_gmt":"2021-12-08T04:42:33","slug":"solved-batch-file-to-delete-the-last-two-lines-of-an-excel-file","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/programming\/batch-file-to-delete-the-last-two-lines-of-an-excel-file\/29056.html","title":{"rendered":"Solved Batch File To Delete The Last Two Lines Of An Excel File"},"content":{"rendered":"<p>I need a Batch File to do two things to an Excel (xls) file, 1) Delete the last two lines, and 2) Select all cells and Un-Merge the cells.<\/p>\n<p>The XLS file is one file in a folder and I need the above two routines executed on the file. I have a macro that works but I want to automate the process using a batch file so those un-familiar with Excel can help with the project.<\/p>\n<p>The XLS file is downloaded data that is unique to a specific person. I routinely download the data, place it (the XLS file) in a unique folder, open the file and preform the above two functions. This needs to be automated to streamline work flow.<\/p>\n<p>Any help is appreciated. Thanks you. Gary<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":88},"question-category":[55],"question_tags":[],"class_list":["post-11512","question","type-question","status-publish","hentry","question-category-programming"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/11512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=11512"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=11512"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=11512"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=11512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}