About table actions 2
Simply put, when you write directly to Excel using the write action from a data table, all data ends up in string format (left justified).
Let's see it in action. If you create a table in an input file and then use the 'Write from Data Table' action to another workbook.
The problem is that you have to modify the format of the output file every time you process it.
Anyone experiencing the same issue
This time, I performed a Write action from this data table to write to another column, and then entered a Set Cell Formula action in the designated location, which successfully converted characters to strings, dates to dates, and numbers to number format.
It's kind of a useless logic though.
If the number of target data records is small, a double loop as shown below may be sufficient.
However, there is an unnecessary function in Excel that automatically suppresses the zeros.
Can anyone tell me a good way to write from data table action?






Comments