Import CSV to Excel Worbook

[NarendraMundwad]

I'm trying to import .csv to Excel workbook so that I can save it in .xls format. When I use Import csv action it throws an error mentioned below: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))   Can anyone please suggest on what needs to be done?  

[BenKirimlidis]

​I had them defined yes.  Shouldn't have to, but that is what I had.

And having over 100k+ lines in a .csv will cause that memory issue.  You should break it into smaller files.

------------------------------
Ben Kirimlidis
RPA Developer and Data Analyst
PTSB
Europe/London
------------------------------

[sahana.mohan]

Thanks Gopal. It worked.

------------------------------
Sahana Mohan
Solution Designer
Blueprism
------------------------------