{"action":"created","issue":{"url":"https://api.github.com/repos/awalker89/openxlsx/issues/22","labels_url":"https://api.github.com/repos/awalker89/openxlsx/issues/22/labels{/name}","comments_url":"https://api.github.com/repos/awalker89/openxlsx/issues/22/comments","events_url":"https://api.github.com/repos/awalker89/openxlsx/issues/22/events","html_url":"https://github.com/awalker89/openxlsx/issues/22","id":40592312,"number":22,"title":"Corrupt file","user":{"login":"ARParis","id":8490095,"avatar_url":"https://avatars.githubusercontent.com/u/8490095?v=3","gravatar_id":"","url":"https://api.github.com/users/ARParis","html_url":"https://github.com/ARParis","followers_url":"https://api.github.com/users/ARParis/followers","following_url":"https://api.github.com/users/ARParis/following{/other_user}","gists_url":"https://api.github.com/users/ARParis/gists{/gist_id}","starred_url":"https://api.github.com/users/ARParis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ARParis/subscriptions","organizations_url":"https://api.github.com/users/ARParis/orgs","repos_url":"https://api.github.com/users/ARParis/repos","events_url":"https://api.github.com/users/ARParis/events{/privacy}","received_events_url":"https://api.github.com/users/ARParis/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2014-08-19T13:44:59Z","updated_at":"2015-07-09T18:55:58Z","closed_at":null,"body":"Thanks for the package.\r\n\r\nOn my system, I can read a file, write it. But it is corrupted for excel. Even a simple file such as:\r\nwrite.xlsx(iris, file = \"writeXLSX1.xlsx\", colNames = TRUE, borders = \"rows\")\r\n\r\nI am sending by email the corresponding saved file\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/awalker89/openxlsx/issues/comments/120107583","html_url":"https://github.com/awalker89/openxlsx/issues/22#issuecomment-120107583","issue_url":"https://api.github.com/repos/awalker89/openxlsx/issues/22","id":120107583,"user":{"login":"vathymut","id":7067228,"avatar_url":"https://avatars.githubusercontent.com/u/7067228?v=3","gravatar_id":"","url":"https://api.github.com/users/vathymut","html_url":"https://github.com/vathymut","followers_url":"https://api.github.com/users/vathymut/followers","following_url":"https://api.github.com/users/vathymut/following{/other_user}","gists_url":"https://api.github.com/users/vathymut/gists{/gist_id}","starred_url":"https://api.github.com/users/vathymut/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vathymut/subscriptions","organizations_url":"https://api.github.com/users/vathymut/orgs","repos_url":"https://api.github.com/users/vathymut/repos","events_url":"https://api.github.com/users/vathymut/events{/privacy}","received_events_url":"https://api.github.com/users/vathymut/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T18:55:58Z","updated_at":"2015-07-09T18:55:58Z","body":"Hi Alex,\r\nI'm having the same issue. Installing the most recent version of `openxlsx` did not do it. \r\n\r\nI am doing something very similar to @tgwhite.\r\n\r\n    # Load, add data and save worksheet\r\n    wb <- loadWorkbook( file =  xlsx_path )\r\n    addWorksheet( wb, sheetName = \"a_name\" )\r\n    writeData( wb, sheet = \"a_name\", x = a_data_frame, withFilter = TRUE, headerStyle = someStyle ) \r\n    saveWorkbook( wb, file =  xlsx_path, overwrite = TRUE )\r\n \r\nIt exhibits this behavior on some excel workbooks but not others. When it does work -- aka the resulting `.xlsx` file is not corrupt -- it still warns that:\r\n\r\n    Warning messages:\r\n    1: In rm(dXML) : object 'dXML' not found\r\n    2: Overwriting existing cell data. \r\n\r\nAny workaround for this?\r\n\r\nBest,\r\nV."}}