Write range is changing colum data type from Boolean to string

Help Activities
, ,
1

i have no Excel in my VM , so i use workbook activities ,
when i add a boolean column in a datatable and affect values TRUE /FALSE

but the problem is when i use write range activity (workbook), this column is written as a string one

2

Hi @Emna ,

Would you be so kind as to include a snapshot of the expected output in Excel?

There isn’t a Boolean column in Excel, so the Write Range Activity will convert it to String, but if there is a format you wish to preserve, then if you could provide us with a screenshot it will put us on the same page.

Kind Regards,
Ashwin A.K

4

the problem it worked for an excel and another no but i used this same code for 2 different inputs

1
11348×283 17.6 KB

5

i want it in this format

5
5321×862 8.49 KB

6

but i get this

4
4231×722 5.05 KB

7

hi @ashwin.ashok
the problem it worked for an excel and another no but i used this same code for 2 different inputs
I used for both a write range and as input a different dataframes but for this boolean column i used same code using add column activity and affect boolean for typeArgument

8

This is because Excel is not supporting the boolean datatype. Check your format settings in the excelfile and it should work fine!

10

@lavmang Thanks for the reply! But my problem is not format, but the type of value that Write Range enters into Excel. It is saved as text instead of boolean. and i have not the excel in my vm so i can’t use the excel application scope to solve this problem

11

Instead of checking the format

You can have the Template of the Output excel column with Boolean type.

Just copy the value and paste it in the template

Regards
Gokul

12

@Gokul001 but we don’t have the boolean type in excel, (Excel is not support the boolean type) also in my process, it’s up to me to create the output file, it is not created so the write range create the file and write the dataframe in excel.

how can i force the excel to write this column as a boolean variable and put ‘FALSE’ in the center of cell the with uipath code ?

13

May I know what is the column format set when the value is VRAI and FAUX

If it’s text or general as Boolean is not available then we can directly write in DATATABLE as VRAI or FAUX instead of True or False

Only thing you need to change is the column type in datatable where change that Boolean type to string and mention as VRAI / FAUX instead of TRUE / FALSE

cheers @Emna

14

i solve the problem
I assign to the values of this column TRUE and FALSE
Also I have uploaded a package called “Easy DataTable Activities” in UiPath [Marketplace]
The package contains the activity Change Column Data Type
then in write range, i change the extension of the file from .xls to .xlsx
And change the language of the excel from English to french

1 Like