{"action":"created","issue":{"url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/issues/68","labels_url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/issues/68/labels{/name}","comments_url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/issues/68/comments","events_url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/issues/68/events","html_url":"https://github.com/cfsimplicity/lucee-spreadsheet/issues/68","id":121995859,"number":68,"title":"Writing a file with password protection doesn't work","user":{"login":"cfsimplicity","id":456718,"avatar_url":"https://avatars.githubusercontent.com/u/456718?v=3","gravatar_id":"","url":"https://api.github.com/users/cfsimplicity","html_url":"https://github.com/cfsimplicity","followers_url":"https://api.github.com/users/cfsimplicity/followers","following_url":"https://api.github.com/users/cfsimplicity/following{/other_user}","gists_url":"https://api.github.com/users/cfsimplicity/gists{/gist_id}","starred_url":"https://api.github.com/users/cfsimplicity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cfsimplicity/subscriptions","organizations_url":"https://api.github.com/users/cfsimplicity/orgs","repos_url":"https://api.github.com/users/cfsimplicity/repos","events_url":"https://api.github.com/users/cfsimplicity/events{/privacy}","received_events_url":"https://api.github.com/users/cfsimplicity/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"cfsimplicity","id":456718,"avatar_url":"https://avatars.githubusercontent.com/u/456718?v=3","gravatar_id":"","url":"https://api.github.com/users/cfsimplicity","html_url":"https://github.com/cfsimplicity","followers_url":"https://api.github.com/users/cfsimplicity/followers","following_url":"https://api.github.com/users/cfsimplicity/following{/other_user}","gists_url":"https://api.github.com/users/cfsimplicity/gists{/gist_id}","starred_url":"https://api.github.com/users/cfsimplicity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cfsimplicity/subscriptions","organizations_url":"https://api.github.com/users/cfsimplicity/orgs","repos_url":"https://api.github.com/users/cfsimplicity/repos","events_url":"https://api.github.com/users/cfsimplicity/events{/privacy}","received_events_url":"https://api.github.com/users/cfsimplicity/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-12-14T08:27:02Z","updated_at":"2015-12-17T01:37:45Z","closed_at":"2015-12-15T10:44:01Z","body":"Inherited from Railo Extension. Supplying a password to the `write()` method only makes the file \"read-only\". Doesn't prevent opening."},"comment":{"url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/issues/comments/165310048","html_url":"https://github.com/cfsimplicity/lucee-spreadsheet/issues/68#issuecomment-165310048","issue_url":"https://api.github.com/repos/cfsimplicity/lucee-spreadsheet/issues/68","id":165310048,"user":{"login":"lmah","id":1515695,"avatar_url":"https://avatars.githubusercontent.com/u/1515695?v=3","gravatar_id":"","url":"https://api.github.com/users/lmah","html_url":"https://github.com/lmah","followers_url":"https://api.github.com/users/lmah/followers","following_url":"https://api.github.com/users/lmah/following{/other_user}","gists_url":"https://api.github.com/users/lmah/gists{/gist_id}","starred_url":"https://api.github.com/users/lmah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lmah/subscriptions","organizations_url":"https://api.github.com/users/lmah/orgs","repos_url":"https://api.github.com/users/lmah/repos","events_url":"https://api.github.com/users/lmah/events{/privacy}","received_events_url":"https://api.github.com/users/lmah/received_events","type":"User","site_admin":false},"created_at":"2015-12-17T01:37:45Z","updated_at":"2015-12-17T01:37:45Z","body":"Hi Julian,\r\n\r\nI followed your example you had, for write() to test out XML spreadsheet creation,\r\nspreadsheet = service(\"spreadsheet\");\r\ndata = QueryNew( \"First,Last\",\"VarChar,VarChar\",[ [ \"Susi\",\"Sorglos\" ],[ \"Julian\",\"Halliwell\" ] ] );\r\nworkbook = spreadsheet.workbookFromQuery( data );\r\npath = \"C:/temp/test.xlsx\";\r\nspreadsheet.write( workbook=workbook, filepath=path, password=\"testpassword\");\r\n\r\nBut, that still throws an error (not sure if I was doing something wrong there?): \r\nMessage\tWhole file password protection is not supported for binary workbooks\r\nDetail\tPassword protection only works with XML ('xlsx') workbooks.\r\n\r\nI did come across some post regarding password proctection, I.e. \r\nhttp://sachinnikam.blogspot.com.au/2014/04/apache-poi-password-protected-excel.html\r\n\r\nusing Biff8EncryptionKey,\r\n\r\nhowever, with my limited Java skills, not sure if this would work for binary (xls) workbook?\r\n\r\n\r\nRegards,\r\nLeroy\r\n"}}