{"action":"created","issue":{"url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/63","repository_url":"https://api.github.com/repos/ClosedXML/ClosedXML","labels_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/63/labels{/name}","comments_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/63/comments","events_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/63/events","html_url":"https://github.com/ClosedXML/ClosedXML/issues/63","id":182031527,"number":63,"title":"Excel found unreadable content - strip invalid XML characters?","user":{"login":"gailshighsmith","id":22746944,"avatar_url":"https://avatars.githubusercontent.com/u/22746944?v=3","gravatar_id":"","url":"https://api.github.com/users/gailshighsmith","html_url":"https://github.com/gailshighsmith","followers_url":"https://api.github.com/users/gailshighsmith/followers","following_url":"https://api.github.com/users/gailshighsmith/following{/other_user}","gists_url":"https://api.github.com/users/gailshighsmith/gists{/gist_id}","starred_url":"https://api.github.com/users/gailshighsmith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gailshighsmith/subscriptions","organizations_url":"https://api.github.com/users/gailshighsmith/orgs","repos_url":"https://api.github.com/users/gailshighsmith/repos","events_url":"https://api.github.com/users/gailshighsmith/events{/privacy}","received_events_url":"https://api.github.com/users/gailshighsmith/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ClosedXML/ClosedXML/labels/Hacktoberfest","name":"Hacktoberfest","color":"b0581d"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-10-10T14:38:11Z","updated_at":"2016-10-17T14:31:05Z","closed_at":"2016-10-14T22:13:05Z","body":"Using a DataTable to build XLWorkbook and SaveAs MemoryStream.  \r\nCode works fine on small data sets but receiving following error on large data sets.\r\n\r\n\"Excel found unreadable content in Filename.xlsx\" Do you want to recover the contents of this workbook?\r\n\r\nAm already stripping and replacing with \"\" space the following characters:\r\nstring r = \"[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F\\x26]\";\r\n\r\nAre there additional invalid XML characters I should be looking for and removing?\r\nThanks!\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/comments/254224141","html_url":"https://github.com/ClosedXML/ClosedXML/issues/63#issuecomment-254224141","issue_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/63","id":254224141,"user":{"login":"gailshighsmith","id":22746944,"avatar_url":"https://avatars.githubusercontent.com/u/22746944?v=3","gravatar_id":"","url":"https://api.github.com/users/gailshighsmith","html_url":"https://github.com/gailshighsmith","followers_url":"https://api.github.com/users/gailshighsmith/followers","following_url":"https://api.github.com/users/gailshighsmith/following{/other_user}","gists_url":"https://api.github.com/users/gailshighsmith/gists{/gist_id}","starred_url":"https://api.github.com/users/gailshighsmith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gailshighsmith/subscriptions","organizations_url":"https://api.github.com/users/gailshighsmith/orgs","repos_url":"https://api.github.com/users/gailshighsmith/repos","events_url":"https://api.github.com/users/gailshighsmith/events{/privacy}","received_events_url":"https://api.github.com/users/gailshighsmith/received_events","type":"User","site_admin":false},"created_at":"2016-10-17T14:31:05Z","updated_at":"2016-10-17T14:31:05Z","body":"igitur, I will pull the latest code soon.\r\nFirst, the issue appears to be with negative numbers.  A call is made to a T-sql stored procedure that returns a \"money\" column value.  A C# SqlCommand executes the stored procedure and loads a \"DataTable\".  The \"DataTable\" is passed into the ClosedXML Export function which uses the oWorkBook.SaveAs(oMemoryStream) function to output the Excel file.  It does not seem to matter if I use the \"wbSheet1.Column(21).Style.NumberFormat.NumberFormatId = 2;\" format or not. \r\nIf the result set contains a NEGATIVE number the Error occurs as previously described.\r\nIs there a specific 'money' format I should be using? Thanks!"}}
{"actor":{"display_login":"gailshighsmith"}}