Read CSV and Write Range on ".xlsx" file. (Encoding:"shift_jis", still falls "0"s and mis-convert large numbers)

Help
, , , ,
1

Hello, this is my first post and I’m sorry if my English is hard to read.
This is what I want to do:

1.use “Read CSV” to read a csv file content as datatable
-Delimitator: Comma
-Encoding: “shift_jis”

2.Use “Excel application scope” to open an excel format(.xlsx)
-In the detail setting of the excel file: “show 0s” : ON

3.use “Write Range” to paste the datatable

When I open the excel format after pasting the datatable, I have two problems:

  1. "0"s (in the beginning of each cell) fall
  2. the last 5 or 6 digits of large numbers automatically converted into "0"s

I would appreciate you very much if you give me advice.
I am not allowed to use “invoke code” or use excel macro basically.
Thank you for reading:)

2

Hi,

"0"s (in the beginning of each cell) fall

Do you mean like “00100” to “100”?
It’s because the value is identified as integer.

the last 5 or 6 digits of large numbers automatically converted into "0"s

How many digits is your large number?
If it’s larger than 15, its specification of Excel.

[Solution]
You need to set format of each cell as String in your worksheet in advance.
or
Add "'" to your each value in datatable.

Regards,

3

Thank you very much for your kind reply:)
I could solve the problem by setting excel file format column’s data type to “string” this time.
But those information is very useful to solve the problems using functions of UiPath.
Thank you again.

1 Like