How to Convert Excel to CSV

Help Studio
1

Hi,

I am trying to convert an excel document to CSV because I need to submit the final version as a CSV within the automation. However, I am having problems achieving this. Please assist. Is there something wrong with the logic of my code?

image
image1625×791 86.9 KB

As you can see in the above screenshot, I have a datatable (DTvalue) that is initially expressed as an excel. Then, I try to use the DTvalue as an input to write a CSV file. However, it doesn’t work.

2

Hi @Sinenhlanhla_Shelembe

Your logic is mostly correct, but check these points:
• Ensure DTvalue has data (use DTvalue.Rows.Count)
• Verify your SQL query and DB connection
• Check the file path (try a simple path like C:\Temp\TestData.csv)
• Remove Append Range (not needed for CSV)

See the correct flow:
Execute Query → DTvalue → Write CSV

If DTvalue is empty, CSV won’t be created.

If solution work for you please mark as solution and happy automations with UiPath

3

Yes, thanks for the response. Still not working.

I tried a new approach; append the output directly to a CSV.

image
image1055×539 31 KB

Do you know why it won’t work? When I do it this way, is doesn’t add any information to the CSV file. But, if I do the same thing to an excel, as in the original post, it populates it with the correct information. I’m stuck trying to figure out why.

4

If the CSV doesn’t already exist you need to use Write CSV, not Append CSV.

5

Hi @Sinenhlanhla_Shelembe
You can check the query is bringing value using this or it comes empty without value
DTvalue.Rows.Count.ToString

Also if your sql results contains null values sometimes it will throw error. You can replace the null values
If IsDBNull(row(“columnName”)) Then row(“columnName”) = “”

And also you can check the query is returning any special character characters like comma, linebreaks sometimes it’ll also cause the issue

6

@Sinenhlanhla_Shelembe From what you described, the logic is mostly fine. Since DTvalue is already getting populated correctly and it works when writing to Excel, the issue is likely not with the query, but with how the CSV activity is being used.

If your end goal is a CSV file,

keep the flow simple: Execute Query → store result in DTvalue → Write CSV

You do not need to append to Excel first

Please check below steps:

  1. Confirm DTvalue has data Add a log or check: DTvalue IsNot Nothing AndAlso DTvalue.Rows.Count > 0
  2. Use Write CSV instead of Append to CSV
  3. Make sure the CSV file is not open If the file is open in Excel or Notepad, UiPath may not write to it properly.

Please let me know if it works

7

I’ll try this method. I was using an already existing CSV, but this approach may be the solution. Will update you on the success.

Thanks

8

The reason I created an excel first was to check if it was generating the correct outputs/ values. It was, but now the difficulty is creating a CSV.

I will check whether there are any special characters that may be causing the issues. Great suggestion. In case it does create any special values (commas particularly because there are), what should I do?

Thanks

9

Yes, you’re correct. I tried this approach and surprisingly, on the first attempt it worked. But, since the first attempt, it now doesn’t populate the CSV file at all. I don’t know what the issue is because UiPath frequently presents this challenge where the same code can be run multiple times and get different outcomes every time. Your approach works, but now I am figuring out how to make it work every time.

10

Great @Sinenhlanhla_Shelembe . Please mark it as resolved so that it can help others.

Thanks,

Dhruba

11

image
image1593×854 356 KB

This is what the correct output should be like. (This is an excel version btw).

12

@Sinenhlanhla_Shelembe is that your issue is resolved if not please help me with error in details format soo we can help you there.

13

Unfortunately, still unresolved.

14

@Sinenhlanhla_Shelembe could you please give me error which u are facing now ?

15

Hi @Sinenhlanhla_Shelembe

Can you try the following:

  • In the Write CSV activity, set the Delimiter to pipe (|).
  • Disable the Should Quote option.
16

This is the solution. I disabled Should Quote with changing the Delimiter and it worked.