I was getting memory heap error whenever i pull excel from input. I have resolved it somehow by changing the setting given in the attached JPG file. Now the performance is very slow. Please suggest the setting which i should have for a better performance. Is it everywhere the xmx and xmx should be in sync?
Solved! Go to Solution.
There are many utils/java routines that allow you to extract all columns/rows from a sheet in an Excel spreadsheet into a CSV
You'll probably be better off doing this and then consuming the resulting CSV - especially if the Excel sheet is very large.