Document size for loading into s3 or reading from S3

Question

Hi All, 
 
 I have a requirement; we need to store the document in S3, or at times we need to read the document (.xlsx) and present it in a grid format. 
 Sometimes, it contains 1 million rows. Is it possible to fetch the data in batches while reading the document from S3, or is there any other alternative approach to achieve this? without impact any performance.

Shubham Aware · Answer

1 -> Depends on plugin or connected system. 2 -> Cannot fetch Excel file in batches from S3. Must download complete file, then parse in batches.

Harsha Sharma · Answer

To fulfill this you need to download the document from S3 to Appian. Use some plugin to read/import the excel data (in batches, depending on plugin) then show on grid. As mentioned by others already, research on the file size restrictions as well as plugins to read about million rows from excel , and show in grid.