Csv to xlsx conversion

Help
1

I am doing the csv to xlsx conversion. when I select the Comma in the Read CSV property then it thrown me an error.
image

when I select the Tab the it Read the csv file and write the data into the xlsx, but the format is diff in the xlsx.
Ex. csv format like… Name | CustomerCode | Destination
After converted into the xlsx it written like

Name
CustomerCode
Destibation

@Palaniyappan @Lahiru.Fernando

2 Likes
2

@balkishan try it with Delimiter Pipe as mentioned in your csv example.

2 Likes
3

same output I am getting
see how it’s written

This are my Columns Headers in the CSV and how it written in the xlsx file

1 Like
4

@balkishan can you upload a sample once we can give it a shot.

1 Like
5

no worries
here choose as pipe in the read csv file image

Cheers @balkishan

1 Like
6

If possible can i have a view on the csv a screenshot
Cheers @balkishan

2 Likes
7

csv format

This is the xlsx format after converted from csv
I selected Pipe in the Read CSV property.

1 Like
8

Use generate data table and change all types of seperators @balkishan. Use whatever works for you

2 Likes
9

Hi @balkishan

Check this

Thanks
Ashwin.S

10

@balkishan It looks like a combination CSV try opeining with notepad to check which delimiter it has, use that if it has only one kind, else as per your screen shot your data starts from row 11 read from there by doing a string manipulation.

2 Likes
11

can you explain it more…string manipulation here…

1 Like
12

what I have to select here in Generate Data Table
image

DT is a Read CSV file activity variable. what I have to give in the input?

image
image220×533 9.42 KB

1 Like
13

@balkishan,

Paste the text you have in the input and changing the seperators, preview the data. So, that you will understand how it varies for each seperator

1 Like
14

here also it gives me same as it gives me in xlsx file.

15

change the seperator,

check the CSV parser and try once or even the new line seperators @balkishan

1 Like
17

solution I tired is to.
Read the csv as a Excel.

Steps to follow

  1. Excel Application Scope
  2. Inside Excel Scope use Read Range Activity and create a data type variable
  3. Use Write Range Activity and give the data type variable which is created in the Read Range and in the path field give .xlsx

That’s all
3.

8 Likes
18

Great
Cheers @balkishan

1 Like
19

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