Excel CSV sheet question

Help Activities
, ,
1

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.

2

HI,

Can you share specific sample as file? it’s no problem if dummy data.

Regards,

3

image

First row is not columns.
Is there a way just to get the entire text from the sheet?

Thank you,

4

Hi,

Can you try either of the following?

  • Uncheck HasHeader property of ReadCSV, then set column name from 2nd row. next remove 1st and 2nd row.

  • Use ReadTextFile activity, then remove first row with string manipulation (e.g. regex) , next use GenerateDAataTableActivity.

Regards,

5

Thank you, in the first option, how do I remove first row?
How to read csv from column name?
Read CSV does not give any options.

Thank you,

6

Hi,

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

Regards,

1 Like
7

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