Hi, I have data.csv file. But in the sheet data is not columns. Just text across columns. Read CSV is failing because it is not in proper columns format. How do I read this data? I need to read from multiple files like this and append data and write into an Excel sheet.

Hi, The latter may be easier. Can you check the following post? [image] Unable to read CSV file Studio Hi, Can you try as the following? First, read csv file as string using ReadTextFile activity. Next remove the first line of the string using the following expression…

Excel CSV sheet question

Help Activities

Yoichi (Yoichi) June 11, 2024, 2:15am 6

Hi,

The latter may be easier. Can you check the following post?

Regards,

1 Like

Topic		Replies	Views
Csv to datatable problem Studio studio , question , activities_panel	6	94	February 21, 2025
CSV File to DataTable problem Studio uiautomation	8	1212	April 13, 2022
Any other activity package to read csv except excel package? Help	6	915	July 30, 2019
Help in Reading CSV by using Excel Application Scope activity Activities excel , uiautomation	8	1493	July 24, 2023
Extracting data from csv file Activities excel , activities , question	3	621	September 4, 2023

Excel CSV sheet question

Related topics