Issue with Excel decimal separators

Hi @jsegura 2409 ,

Please follow the below,

To work with an Excel file that has numbers with both commas and dots as decimal separators, you can use Automation Anywhere to standardize the format and ensure that the type of decimal separator doesn't matter. Here's a step-by-step guide on how to do this:

1. Open Excel File:

   • Use Automation Anywhere to open the Excel file that contains the data.

2. Read Data:

   • Use Automation Anywhere's Excel Packages to read the data from the file into a data table or a variable.

3. Standardize Decimal Separators:

   • Iterate through each cell or row in the data table.
   • For each cell containing a number, use Automation Anywhere string manipulation commands to replace any commas with dots or vice versa. You can use the Replace function to do this.

4. Save Changes:

   • Use Automation Anywhere to save the changes back to the Excel file.

5. Close Excel File:

   • Finally, close the Excel file using Automation Anywhere Excel Package Actions.