{"action":"created","issue":{"url":"https://api.github.com/repos/agershun/alasql/issues/945","repository_url":"https://api.github.com/repos/agershun/alasql","labels_url":"https://api.github.com/repos/agershun/alasql/issues/945/labels{/name}","comments_url":"https://api.github.com/repos/agershun/alasql/issues/945/comments","events_url":"https://api.github.com/repos/agershun/alasql/issues/945/events","html_url":"https://github.com/agershun/alasql/issues/945","id":261525538,"number":945,"title":"Export to Excel using AlaSql 0.4.2 throws error when exporting large data.","user":{"login":"sarveshascbe","id":8067654,"avatar_url":"https://avatars0.githubusercontent.com/u/8067654?v=4","gravatar_id":"","url":"https://api.github.com/users/sarveshascbe","html_url":"https://github.com/sarveshascbe","followers_url":"https://api.github.com/users/sarveshascbe/followers","following_url":"https://api.github.com/users/sarveshascbe/following{/other_user}","gists_url":"https://api.github.com/users/sarveshascbe/gists{/gist_id}","starred_url":"https://api.github.com/users/sarveshascbe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sarveshascbe/subscriptions","organizations_url":"https://api.github.com/users/sarveshascbe/orgs","repos_url":"https://api.github.com/users/sarveshascbe/repos","events_url":"https://api.github.com/users/sarveshascbe/events{/privacy}","received_events_url":"https://api.github.com/users/sarveshascbe/received_events","type":"User","site_admin":false},"labels":[{"id":141773718,"url":"https://api.github.com/repos/agershun/alasql/labels/!%20Feature%20request","name":"! Feature request","color":"fbca04","default":false},{"id":141773719,"url":"https://api.github.com/repos/agershun/alasql/labels/Please%20help%20out!","name":"Please help out!","color":"5319e7","default":false},{"id":216913195,"url":"https://api.github.com/repos/agershun/alasql/labels/Related%20to:%20Code%20quality","name":"Related to: Code quality","color":"fef2c0","default":false},{"id":219472551,"url":"https://api.github.com/repos/agershun/alasql/labels/Related%20to:%20Performance","name":"Related to: Performance","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2017-09-29T03:57:52Z","updated_at":"2017-10-06T05:13:02Z","closed_at":null,"author_association":"NONE","body":"I am using AlaSQL v0.4.2, majorly for export JavaScript array data to Excel (XLS) format.\r\n\r\nIn a JavaScript code object there are approximately 10,000 + records and 88 columns.\r\n\r\nI am using export to excel (XLS) option. \r\n\r\nvar excelObj = alasql('SELECT * INTO XLS(\"CounterCorrection.xls\",?) FROM ?', [mystyle, data]);\r\n\r\nFirst 1 or 2 times excel data is exported successfully, subsequent attempts to export for same or less volume of data I get errors \"Not enough memory\" or \"Not enough storage available to complete this operation\".\r\n\r\nThis happens in IE9, IE10, IE11 and all other browsers too.\r\n\r\nAttached is a sample file generated from alasql, the javascript object contains exactly the same columns and rows as depicted in excel. Headers are columns, and others are rows.\r\n[CounterCorrectionRevised.zip](https://github.com/agershun/alasql/files/1343045/CounterCorrectionRevised.zip)\r\n"},"comment":{"url":"https://api.github.com/repos/agershun/alasql/issues/comments/334660108","html_url":"https://github.com/agershun/alasql/issues/945#issuecomment-334660108","issue_url":"https://api.github.com/repos/agershun/alasql/issues/945","id":334660108,"user":{"login":"sarveshascbe","id":8067654,"avatar_url":"https://avatars0.githubusercontent.com/u/8067654?v=4","gravatar_id":"","url":"https://api.github.com/users/sarveshascbe","html_url":"https://github.com/sarveshascbe","followers_url":"https://api.github.com/users/sarveshascbe/followers","following_url":"https://api.github.com/users/sarveshascbe/following{/other_user}","gists_url":"https://api.github.com/users/sarveshascbe/gists{/gist_id}","starred_url":"https://api.github.com/users/sarveshascbe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sarveshascbe/subscriptions","organizations_url":"https://api.github.com/users/sarveshascbe/orgs","repos_url":"https://api.github.com/users/sarveshascbe/repos","events_url":"https://api.github.com/users/sarveshascbe/events{/privacy}","received_events_url":"https://api.github.com/users/sarveshascbe/received_events","type":"User","site_admin":false},"created_at":"2017-10-06T05:13:02Z","updated_at":"2017-10-06T05:13:02Z","author_association":"NONE","body":"var mystyle = {\r\n                    headers: true,\r\n                    sheetid: 'Counter Correction',\r\n                };\r\n\r\n                //Create XLS format using alasql.js file.\r\n                var excelObj = alasql('SELECT * INTO XLS(\"CounterCorrection.xls\",?) FROM ?', [mystyle, data]);\r\n                console.log(\"Counter Correction Data Export Success\");\r\n\r\ndata - JavaScript array object contains 8881 rows and about 88 columns. In UI on a button click above code is executed.\r\n\r\nThe exported excel is attached in the zip file \"CounterCorrectionAlaSql.zip\"\r\n\r\nIn Firefox and Chrome i don't have any issues, even if i try to export multiple time on click of a button. Whereas in all IE versions i face an issue of either \"Not enough storage available for this operation\" or \"Not enough memory\" exception. Once i get this exception even for smaller volume of data, say for example if the data Javascript object contains only 1000 rows, even then it fails. Only way to recover is to restart the browser.\r\n[CounterCorrectionAlaSql.zip](https://github.com/agershun/alasql/files/1361570/CounterCorrectionAlaSql.zip)\r\n"}}
{"actor":{"display_login":"sarveshascbe"}}