{"id":231,"date":"2019-04-02T11:19:46","date_gmt":"2019-04-02T11:19:46","guid":{"rendered":"http:\/\/info.ffteixeira.net\/2019\/04\/02\/unprotect-remove-excel-password\/"},"modified":"2019-04-02T11:19:46","modified_gmt":"2019-04-02T11:19:46","slug":"unprotect-remove-excel-password","status":"publish","type":"post","link":"https:\/\/blog.ffteixeira.net\/?p=231","title":{"rendered":"Unprotect\/Remove Excel Password"},"content":{"rendered":"
    \n
  1. Change the extension of you Excel file from .xlsx to .zip<\/li>\n
  2. Extract these XML files outside the folder,they represent the worksheets in the Excel file.\n
      \n
    1. Location: xl -> worksheets -> *.xml<\/li>\n<\/ol>\n<\/li>\n
    2. Modified codes using simple “Notepad”.\n
        \n
      1. Open XML File & Delete  Excel v. 2007-10 “sheetProtection password=… \/>” v. 2013 – “sheetProtection algorithmName=…\/>”<\/strong><\/li>\n<\/ol>\n<\/li>\n
      2. Save & Close Xml File<\/li>\n
      3. The modified XML file should be put again in the zipped file to replace the old XML files.<\/li>\n
      4. Run File<\/li>\n<\/ol>\n
         <\/div>\n
        Credits<\/a><\/div>\n
         <\/div>\n
         <\/div>\n","protected":false},"excerpt":{"rendered":"

        Change the extension of you Excel file from .xlsx to .zip Extract these XML files outside the folder,they represent the worksheets in the Excel file. Location: xl -> worksheets -> *.xml Modified codes using simple “Notepad”. Open XML File & … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-231","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=\/wp\/v2\/posts\/231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=231"}],"version-history":[{"count":0,"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ffteixeira.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}