Write from data table

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().