Text file Data into Excel

Help Forum
1

Hi,

I have 2.4 crore lines of data in text file with 100 columns separated by |. I need to have this data into Excel files . Is der any way to split the data and paste the data into Excel? And what is the maximum number of rows in Excel which is feasible to automate. Please help

Thanks in Advance

2

You can use Text to Column activity or Generate Datatable activity. Please watch the below video.

3

Yeah, Ok. Thank you. Your answer only gives the solution for the first part of my question. Can you please help with the next part of my question?

4

Plz see the below.

Large Data and DataTable to DataSet - RPA Component | UiPath Marketplace.

5

Hi @Konda_Sai_Charan_Goud ,

Handling Two Crores of Data with 100 Columns would not work/would be too in-efficient to store in Excel files/in the Form of Datatables.

Most probably you would require to adopt Database to work on this Large Data for better efficiency.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.