{"action":"created","issue":{"url":"https://api.github.com/repos/andreac/RSSheet/issues/2","repository_url":"https://api.github.com/repos/andreac/RSSheet","labels_url":"https://api.github.com/repos/andreac/RSSheet/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/andreac/RSSheet/issues/2/comments","events_url":"https://api.github.com/repos/andreac/RSSheet/issues/2/events","html_url":"https://github.com/andreac/RSSheet/issues/2","id":4317263,"number":2,"title":"excel sheet with xml data","user":{"login":"ourdex86","id":1684329,"avatar_url":"https://avatars.githubusercontent.com/u/1684329?v=3","gravatar_id":"","url":"https://api.github.com/users/ourdex86","html_url":"https://github.com/ourdex86","followers_url":"https://api.github.com/users/ourdex86/followers","following_url":"https://api.github.com/users/ourdex86/following{/other_user}","gists_url":"https://api.github.com/users/ourdex86/gists{/gist_id}","starred_url":"https://api.github.com/users/ourdex86/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ourdex86/subscriptions","organizations_url":"https://api.github.com/users/ourdex86/orgs","repos_url":"https://api.github.com/users/ourdex86/repos","events_url":"https://api.github.com/users/ourdex86/events{/privacy}","received_events_url":"https://api.github.com/users/ourdex86/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2012-04-27T06:58:56Z","updated_at":"2016-09-05T18:57:27Z","closed_at":null,"body":"Hi,\r\n\r\nThis is Bharath.\r\n\r\nWhen I use this RSSheet library into my application, it is saving in .xls format bu when I open it, Its showing complete xml string not .xls\r\n\r\nI have used the following code\r\n\r\nRSworkBook * folder = [ [RSworkBook alloc] init];\r\nfolder.author = @\"andrea cappellotto\";\r\nfolder.version = 1.2;\r\n\r\nRSworkSheet * sheet = [[RSworkSheet alloc] initWithName:@\"prova\"];\r\n\r\nRSworkSheetRow * row = [[RSworkSheetRow alloc] initWithHeight:20];\r\n[row addCellString:@\"prova\"];\r\n[row addCellString:@\"prova2\"];\r\n[sheet addWorkSheetRow:row];\r\n\r\nRSworkSheetRow * row2 = [[RSworkSheetRow alloc] initWithHeight:25];\r\n[row2 addCellNumber:100];\r\n[row2 addCellData:[NSDate date] ];\r\n[sheet addWorkSheetRow:row2];\r\n\r\n[folder addWorkSheet:sheet];\r\n\r\nNSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);\r\nNSString *documentsDir = [documentPaths objectAtIndex:0];\r\n[folder writeWithName:@\"prova\" toPath:documentsDir];\r\n\r\nCould you please tel me what should I do? I am not getting proper excel sheet\r\n"},"comment":{"url":"https://api.github.com/repos/andreac/RSSheet/issues/comments/244799355","html_url":"https://github.com/andreac/RSSheet/issues/2#issuecomment-244799355","issue_url":"https://api.github.com/repos/andreac/RSSheet/issues/2","id":244799355,"user":{"login":"timharter","id":8595665,"avatar_url":"https://avatars.githubusercontent.com/u/8595665?v=3","gravatar_id":"","url":"https://api.github.com/users/timharter","html_url":"https://github.com/timharter","followers_url":"https://api.github.com/users/timharter/followers","following_url":"https://api.github.com/users/timharter/following{/other_user}","gists_url":"https://api.github.com/users/timharter/gists{/gist_id}","starred_url":"https://api.github.com/users/timharter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timharter/subscriptions","organizations_url":"https://api.github.com/users/timharter/orgs","repos_url":"https://api.github.com/users/timharter/repos","events_url":"https://api.github.com/users/timharter/events{/privacy}","received_events_url":"https://api.github.com/users/timharter/received_events","type":"User","site_admin":false},"created_at":"2016-09-05T18:57:27Z","updated_at":"2016-09-05T18:57:27Z","body":"Some of the XML header data needs to be updated. I replaced line 60 os RSworkBook.m (in the writeWithName function) with the following:\r\n\r\n`    NSString * head = [[NSString alloc] initWithFormat:@\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\" ?>\\n<?mso-application progid=\\\"Excel.Sheet\\\"?>\\n<Workbook xmlns=\\\"urn:schemas-microsoft-com:office:spreadsheet\\\"\\n xmlns:xsi=\\\"http://www.w3.org/2001/XMLSchema-instance\\\"\\n xmlns:x=\\\"urn:schemas-microsoft-com:office:excel\\\"\\n xmlns:x2=\\\"http://schemas.microsoft.com/office/excel/2003/xml\\\"\\n xmlns:ss=\\\"urn:schemas-microsoft-com:office:spreadsheet\\\"\\n xmlns:o=\\\"urn:schemas-microsoft-com:office:office\\\"\\n xmlns:html=\\\"http://www.w3.org/TR/REC-html40\\\"\\n xmlns:c=\\\"urn:schemas-microsoft-com:office:component:spreadsheet\\\">\\n<DocumentProperties xmlns=\\\"urn:schemas-microsoft-com:office:office\\\"><Author>%@</Author>\\n<LastAuthor>%@</LastAuthor>\\n<Created>%@</Created>\\n<Version>%.2f</Version>\\n</DocumentProperties>\\n\", self.author, self.author, dateString, self.version];`\r\n\r\n\r\nI will try to create a pull request with the fixed code when i get a chance. Good luck!"}}
{"actor":{"display_login":"timharter"}}