ExcelCSV

Help Studio
, ,
1

Hi,

could someone tell us about the correct way to convert SCV file to the excel file ?
i have used CSV To Excel activity and still no good result…

thank you,

2

Hello @Z_AL

When using read CSV Activity, use the same delimiter while reading CSV file. Other wise all data will come in one column. Than use Write Range Activity to write your data…

Let me know how it goes :slight_smile:

1 Like
3

idk What should i select from delimiter?

1 Like
4

@Z_AL

Open your CSV file with a text editor, like Note Pad… Than check what’s used to seperate the data…

1 Like
5

thank you Mohssine,

What does this error mean?

Error
Error946×370 16 KB

and still the format after the converted not so good ldk why

1 Like
6

@Z_AL

This means that your datatable is empt…

When your read your CSV, store it on a datatable variable than use the same datable variable on write range…

Let me know how it goes…

1 Like