How to handle the popup in CSV File

Help Studio
, ,
1

Hi Community folks,

I am downloading a CSV file from a website, and when I open it in Excel, a popup appears. I need to automatically click the Don’t Convert button and save the file.

I was able to handle this using UI activities in UiPath, but I need a solution that does not rely on UI automation. Is there a way to achieve this using Excel activities or any other approach?

The Microsoft Excel dialog box prompts the user to choose whether to keep default data conversions, such as converting digits near "E" into scientific notation and removing leading zeros, in a file. (Captioned by AI)
The Microsoft Excel dialog box prompts the user to choose whether to keep default data conversions, such as converting digits near "E" into scientific notation and removing leading zeros, in a file. (Captioned by AI)501×245 10.6 KB

Looking for your responses.. :smiley:

2

@mkankatala

  1. CSV is not an excel it should be handled differently
  2. is the file getting opened directly? if yes then ui activities is the way
  3. Or as a one time thing check the checkbox you see in the pop up
  4. File > Options > Data > Automatic Data Conversion and uncheck use this and check if the setting works

cheers

3

@mkankatala,

I would suggest to try this workaround.

  1. Use Read CSV activity to read the CSV
  2. Write this Datatable from step 1 to an excel file using Write Range
  3. Now use this excel file for further processing.

Thanks

4

Hi @Anil_G

It will not open automatically, I am just downloading the file.

When click on Don’t convert some of the values are getting changed. So I have to mandatorily click on Don’t convert.

If I uncheck the automatic data conversation option it will work for this file, but I am downloading files everytime so file changes.

5

Hi @ashokkarale

When I click on “Don’t Convert,” some values change. Only after that only I can read the actual values when reading the CSV.

6

@mkankatala

Try to read the file as text and check what data are you getting

How are you opening the file?

Cheers

1 Like
7

@mkankatala,

Ohh :hushed_face:

Did you tried reading text file and then use Generate Data Table From Text

1 Like
8

@mkankatala try opening csv file by Start process activity and then handle that pop up using UI activities.

9

Hey @Anil_G & @ashokkarale

It was working by reading the file as text and used Generate Datatable from Text activity to generate as Table.

It was giving exact values with out handling popup.

Thanks Everyone for your response!!

2 Likes
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.