Save Excel sheet as .CSV utf 8

Help Activities
, , , ,
1

Hi all,

Can anyone help me how to create a Excel file as
.CSV UTF-8 format.

I have my input data in datatable format. I want to write that data in new excel as format - .CSV UTF-8 format.

2

@Rreddy
Use the Read Range activity which creates a datatable then use the Write CSV activity to write the datatable into a csv file.

3

Hi @Krishna_Raj I want to write it as - .CSV UTF-8 format.

4

Hi @Rreddy
Check the below thread

Hope it helps!!

5

Hi @pravallikapaluri currently I’m checking this one. Will update once it works.

6

@Rreddy

image
image1330×782 37.6 KB

image
image1504×323 20.4 KB

After running the process Check the Csv file by opening the csv file and click on "File " and then “Save as” Then you find in what format the csv file is saved

Hope it helps you

7

@Rreddy
image
check encoding with different Unicode, UTF-7, UTF-8, UTF-16, UTF-32, ASCII

8

@Rreddy

  1. use output datatable activity to convert datatable to string

  2. use write text file activity to write string variable from step (1) to a text file, set encoding = utf-8 !!
    set filename = your csv file path

image
image1051×510 31.8 KB

9

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