Hi @Healsko.H ,

May I know the kinds of data that you are having in that Worksheet that you are referring here?

Hi @Padmakumar ,

It’s a normal data table which contains string and double. below is an example.

col1, col2, col3

aa, 11, 1234

bb, 22, 2345

When the data table is written to an excel, all fields are formatted as text, including the value in column col2 & col3.

Now I have to add extra loops to set value one by one from the data table to the excel.

Hi @Healsko.H ,

This is because of the Excel Auto checking. Try after disabling it. Follow the below steps to disable the same.

1. Under Excel menu, go to the Options
2. Select Formulas
3. Uncheck the Enable background error checking option

   

    

Hi @Padmakumar ,

It doesn’t work and the format is still text.

Nvm, since I have to set specific cell format to percentage / double with 2 digits / double with 4 digits, I used VBScript to accomplish.

Is the mentioned format issue same as shown in below snap?

Yup~

If the format isn’t text, calculation is shown when you select multiple fields in status bar.

I had this issue, and I could fix it by disabling the above setting in Excel. 

You mean when you select B2:B4, calculation is shown in the status bar?

Yes…
 

I tried + or - is working fine. But it doesn’t when you use *, /, or sum().

All numeric calculations will be fine once this option got disabled. 

Hi @Healsko.H 

Maybe the follow resource helps:

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/data-table-package-change-column-type-action.html

Regards

Change column type action is not working. 
So i use double loop and input from table cell to output cell 1 by 1.
its correct format.

My experience changed column tape action, write from data table action are useless for same issue.

The output file all data is left side in excel. 
Alphabetic is left side(string), Numeric and date is right side, its common sense.
Hence i am searching the solution.