Skip to main content
Cadet | Tier 2
December 5, 2022
Question

Write from data table

  • December 5, 2022
  • 13 replies
  • 1032 views

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?

13 replies

Padmakumar
Premier Pathfinder | Tier 7
Premier Pathfinder | Tier 7
December 7, 2022

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

Padmakumar
Cadet | Tier 2
May 20, 2024

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.