Unable to load large data

Archive
1

Hi All,

I have a test case where I need to import the data into my application. In the data file, I have 500 columns and 2,00,000 rows of data. When I try to add the excel file into katalon. It says only 100 columns are recommended.

I cannot split the columns and load.

How to achieve this in Katalon?

Please, someone, help me on how to proceed.

2

hello,
1. use external tools to do job for you
2. there is library that will allow you to work with excel https://poi.apache.org/

1 Like
3

Thanks Andrej. This answer helps me.