Error: Column is read only

Hi all,

i am getting this error on this workflow. How should i fix it?

image

Please change your excel file from read only format to editable format to avoid this error;

Thanks,
David

I am creating the excel with excel application scope and do not choose read only field. Then the robot throw the excel to google drive. How can i change form?

@David3

You are looping through the data table and changing the value while looping which is not possible @mazlumkacar. So, you can create a new data table with the same values using assign and while looping through one data table , modify the another one by using the indexes

Now it is working. But this time it says invalid data because of my data is “0” and i made group by aggregation’s aggregation type is double. How will i do it this time?

  1. data of th data table was null and i replaced it “0”.
    image

@HareeshMR

You are trying to change the column name or data here @mazlumkacar?

Now i am also change the “0” data type to double and it is working. But now i am getting this error.

image
@HareeshMR

Can you post the screenshot how you are passing the value to group by?

@mazlumkacar

You can try thisread%20only

Thanks,
Sivasankar S

1 Like

@HareeshMR

I mean the properties panel of the Group by aggregation activity @mazlumkacar

image

@HareeshMR

Just give a try converting the values to type Integer @mazlumkacar

i have just try it but getting the same error.

@HareeshMR
@Palaniyappan

1 Like

I haven’t tried group by till now @mazlumkacar :slight_smile:

We can use this as well, can you try

CDbl(Table.Compute(“Column Name)”, “”))

Check this in the message box and if you got the right values, use it