Runtime memory exception while loading an excel file
Hi, I am trying to create a Job with excel file as an Input source. However, since the file size is huge (around 18 MB), I am getting a runtime exception while creating an excel file. Attached is the screenshot for the same. Kindly suggest how to handle large files.
If you're reading an xlsx file, you'll want to tick that box below the file name. That will enable the Generation mode dropdown, which will let you select Event Mode. This reduces memory usage and should avoid the heap space issue.