Skip to main content
Solved

Data Table action: Write to file

  • July 5, 2024
  • 1 reply
  • 153 views
R
Forum|alt.badge.img

I am trying to write a table to a csv file, but the contents of each row are being stored in a single cell. I’m using “Data Table action: Write to file”. Does anyone know how to fix this?

 

 

 

Best answer by Maria 4095

I have a couple of suggestions:

The simplest solution is to save the destination file with “.csv” extension, if you’re not already.

If you must save the destination file with “.txt” and use Excel, you can use the Text Import Wizard in Excel. Otherwise, it doesn’t appear there is another way to do this in Automation Anywhere except for the Excel “Save As” action, but once again it would need a “.csv” extension.

To open the Text Import Wizard in Excel, select the entire column and then go to Data > Text to Columns.

 

1 reply

Maria 4095
Forum|alt.badge.img+5
  • Maria 4095
  • Cadet | Tier 2
  • Answer
  • July 5, 2024

I have a couple of suggestions:

The simplest solution is to save the destination file with “.csv” extension, if you’re not already.

If you must save the destination file with “.txt” and use Excel, you can use the Text Import Wizard in Excel. Otherwise, it doesn’t appear there is another way to do this in Automation Anywhere except for the Excel “Save As” action, but once again it would need a “.csv” extension.

To open the Text Import Wizard in Excel, select the entire column and then go to Data > Text to Columns.

 

R
Terms & ConditionsCookie settingsAccessibility statement