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
Reading unstructured data in csv file Help excel , csv , activities , question	4	1745	November 11, 2019
Any other activity package to read csv except excel package? Help	6	889	July 30, 2019
Converting a csv file to text to columns Activities excel , uiautomation , csv , activities , studio , text-to-datatable , text-to-column	9	1206	January 23, 2024
Import csv/text file to excel Studio excel , csv , studio , question , custom_activity , activities_panel	21	845	January 23, 2024
How read csv and append without using "read csv" activity Help excel , csv , activities , question	4	893	December 22, 2020

Most Active Users - Yesterday
ashokkarale
mkankatala
hrkppp
takehiro.ichikura
RPANovice1
adi.mehare
manasrlenka25
Frederik_Krogh
Ankit_Chauhan
ruchirmahajan
More details...

Excel CSV sheet question

Related topics