{"action":"created","issue":{"url":"https://api.github.com/repos/aviks/Taro.jl/issues/17","labels_url":"https://api.github.com/repos/aviks/Taro.jl/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/aviks/Taro.jl/issues/17/comments","events_url":"https://api.github.com/repos/aviks/Taro.jl/issues/17/events","html_url":"https://github.com/aviks/Taro.jl/issues/17","id":68718260,"number":17,"title":"Memory problems when calling Taro.readxl a second time ","user":{"login":"mbeltagy","id":4301151,"avatar_url":"https://avatars.githubusercontent.com/u/4301151?v=3","gravatar_id":"","url":"https://api.github.com/users/mbeltagy","html_url":"https://github.com/mbeltagy","followers_url":"https://api.github.com/users/mbeltagy/followers","following_url":"https://api.github.com/users/mbeltagy/following{/other_user}","gists_url":"https://api.github.com/users/mbeltagy/gists{/gist_id}","starred_url":"https://api.github.com/users/mbeltagy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbeltagy/subscriptions","organizations_url":"https://api.github.com/users/mbeltagy/orgs","repos_url":"https://api.github.com/users/mbeltagy/repos","events_url":"https://api.github.com/users/mbeltagy/events{/privacy}","received_events_url":"https://api.github.com/users/mbeltagy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-04-15T15:50:06Z","updated_at":"2015-04-30T20:29:24Z","closed_at":null,"body":"I ran into this issue when I tried to using Taro for reading a pretty large sheet. It reads well the first time around. On the second reading of the same excel file, but a different sheet I get the error below. If I start a fresh julia session and switching the reading order, it works fine on the first read and crashed on the second. The sheets I am reading are in order of 12500x10, with the first two columns being large strings, and the rest integers. \r\n\r\nMy version information is \r\n```\r\nJulia Version 0.3.7\r\nCommit cb9bcae* (2015-03-23 21:36 UTC)\r\nPlatform Info:\r\n  System: Linux (x86_64-linux-gnu)\r\n  CPU: Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz\r\n  WORD_SIZE: 64\r\n  BLAS: libopenblas (DYNAMIC_ARCH NO_AFFINITY Sandybridge)\r\n  LAPACK: libopenblas\r\n  LIBM: libopenlibm\r\n  LLVM: libLLVM-3.3\r\n```\r\n\r\n```julia\r\nException in thread \"main\" java.lang.OutOfMemoryError: GC overhead limit exceeded\r\n        at java.lang.String.substring(String.java:1913)\r\n        at org.apache.poi.ss.util.CellReference.separateRefParts(CellReference.java:364)\r\n        at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:92)\r\n        at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:106)\r\n        at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:70)\r\n        at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:179)\r\n        at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:143)\r\n        at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:130)\r\n        at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:286)\r\n        at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:159)\r\n        at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:186)\r\n        at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:91)\r\nERROR: Error calling Java: java.lang.OutOfMemoryError: GC overhead limit exceeded\r\n in error at error.jl:21\r\n in geterror at /home/user/.julia/JavaCall/src/JavaCall.jl:221\r\n in _jcall at /home/user/.julia/JavaCall/src/JavaCall.jl:285\r\n in jcall at /home/user/.julia/JavaCall/src/JavaCall.jl:235\r\n in readxl at /home/user/.julia/Taro/src/Taro.jl:128\r\n in readxl at /home/user/.julia/Taro/src/Taro.jl:103\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/aviks/Taro.jl/issues/comments/97956440","html_url":"https://github.com/aviks/Taro.jl/issues/17#issuecomment-97956440","issue_url":"https://api.github.com/repos/aviks/Taro.jl/issues/17","id":97956440,"user":{"login":"JonWel","id":11057909,"avatar_url":"https://avatars.githubusercontent.com/u/11057909?v=3","gravatar_id":"","url":"https://api.github.com/users/JonWel","html_url":"https://github.com/JonWel","followers_url":"https://api.github.com/users/JonWel/followers","following_url":"https://api.github.com/users/JonWel/following{/other_user}","gists_url":"https://api.github.com/users/JonWel/gists{/gist_id}","starred_url":"https://api.github.com/users/JonWel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonWel/subscriptions","organizations_url":"https://api.github.com/users/JonWel/orgs","repos_url":"https://api.github.com/users/JonWel/repos","events_url":"https://api.github.com/users/JonWel/events{/privacy}","received_events_url":"https://api.github.com/users/JonWel/received_events","type":"User","site_admin":false},"created_at":"2015-04-30T20:29:24Z","updated_at":"2015-04-30T20:29:24Z","body":"I think I'm already using the JDK 7:\r\nopenjdk-7-jre 7u79-2.5.5-0ubuntu1\r\n\r\n```bash\r\njohndoe@Computer:~$ java -version\r\njava version \"1.7.0_79\"\r\nOpenJDK Runtime Environment (IcedTea 2.5.5) (7u79-2.5.5-0ubuntu1)\r\nOpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode)\r\n```\r\n\r\nThe files are generated from:\r\nhttp://www.elia.be/en/grid-data/power-generation/Solar-power-generation-data/Graph\r\nWith data for a month (`BeginDate:01-01-2014` `EndDate:31-01-2014` then `refresh` and finally `export`)\r\n\r\nI use the following code to load them:\r\n```Julia\r\nTaro.readxl(filePath, \"A4:F2980\")\r\n```"}}