How Import CSV file and load into CDT(without database)

The Excel Tools plug-in contains a function, "previewCSVForImport()", which should allow you to read CSV contents into local data and parse as you will.

Thanks Mike Schmitt, But this has limitation to parse only 1000 rows. I want to parse around 2500 records.

This sort of detail needs to be mentioned up-front then.

Hemant Borate said:

I want to parse around 2500 records.

The only alternative I can think to suggest is that you convert your CSV into an Excel file, and then use the "readExcelSheetPaging()" function, and read paged sets.

This sort of detail needs to be mentioned up-front then.

Hemant Borate said:

I want to parse around 2500 records.

The only alternative I can think to suggest is that you convert your CSV into an Excel file, and then use the "readExcelSheetPaging()" function, and read paged sets.