Write text (green flag)

[Stef_99 (Mary)]

I read data from excel
but after write data. number have green flag.

Please guide me for solve it.

[lrtetala (Lakshman Reddy)]

Hi @Stef_99

Use Format Cells activity to convert it into number format

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@Stef_99
Enable preserve format in Read range workbook

[Anil_G (Anil Gorthi)]

@Stef_99

When a value is written on to excel and if a number is written as text then you see that flag symbol

Either write by first converting the column to integer in datatable itself or another way is to use format cells and change the details

Cheers

[Stef_99 (Mary)]

@Anil_G how to​ converting the column to integer in data​table?

[Yoichi]

HI,

How did you read and write it? Can you share your current workflow, if possible?

Regards,

[Anil_G (Anil Gorthi)]

@Stef_99

You need to add a new column as integer and cast each value to integer…and then remove the old column

Cheers

[Stef_99 (Mary)]

@Yoichi Sourcecode and sample file as attached.

Sample.xaml (10.3 KB)

Report.xlsx (10.2 KB)
input11.xlsx (11.7 KB)

[Yoichi]

HI,

Can you try to unchck PreserveFormat option. If this option is enabled, ReadRange activty reads data as String.

Sample
Sample20240731-3.zip (38.3 KB)

Regards,

[Stef_99 (Mary)]

@Yoichi I uncheck PreserveFormat option already.
but number 0 not write - follow file original.

[Yoichi]

HI,

It’s cell format matter. Can you try to copy cell format to target area as the following, for example. Or set proper cell format in advance.

Sample
Sample20240731-3 (2).zip (40.1 KB)

Regards,

[Stef_99 (Mary)]

@Yoichi I follow your suggest.
But I have a question in destination E11.
I want fix position but I want depend from file last row.

Can you suggest about it?

[Yoichi]

Hi,

For examlpe, use FindFirst/Last DataRow activity, as the following.

Sample
Sample20240731-3 (3).zip (38.0 KB)