Hello, not only the excel file’s format, but also since the information is the csv seems like only 1 column, actually it should seperated into a few columns. How to do it the easiest way?
Hello, not only the excel file’s format, but also since the information is the csv seems like only 1 column, actually it should seperated into a few columns. How to do it the easiest way?
Hello, not only the excel file’s format, but also since the information is the csv seems like only 1 column, actually it should seperated into a few columns. How to do it the easiest way?
Hi
Can you try below steps,
Hi @Semith 3318,
You can use the CSV/Text & Excel packages for this. Put the data from CSV to a Data Table variable and using that, write it’s data to an already created xlsx file.
Hope this clarifies your query.
Hello, not only the excel file’s format, but also since the information is the csv seems like only 1 column, actually it should seperated into a few columns. How to do it the easiest way?
Hi
Can you try below steps,
Hello thank you for replying.
But how will it understand where is the column 2 and column3 starts.
I am asking, because the csv file is like only one column(A1). But actually it should be filled till L1 column. So i guess it will need some extra work for data seperation
Hi @Semith 3318,
You can use the CSV/Text & Excel packages for this. Put the data from CSV to a Data Table variable and using that, write it’s data to an already created xlsx file.
Hope this clarifies your query.
Hello, thank you for the reply.
I think i will need to do some extra work. Because the csv file is not clean. I mean normally the columns between A1-L1 should be filled, but in the csv file all the columns got into A1 column… so its hard to seperate.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.