Six Stars

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.

error.jpg

1 REPLY
Ten Stars

Re: Runtime memory exception while loading an excel file

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.