Question

Write from data table


Badge +2

Hi,

When I updated a worksheet of an excel file by Excel advanced: Write from data table, all the cell formats went to text.

When the data table is saved in a csv file, the value shows normal.

Any idea or improvement on A360?


12 replies

Userlevel 7
Badge +11

Hi @Healsko.H ,

 

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

Badge +2

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.

Userlevel 7
Badge +11

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

     

Badge +2

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.

Userlevel 7
Badge +11

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

 

Badge +2

Yup~

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

 

Userlevel 7
Badge +11

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

Badge +2

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

Userlevel 7
Badge +11

Yes…
 

 

Badge +2

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

Userlevel 7
Badge +11

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

Userlevel 4
Badge +7

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

Reply