"Some features in your workbook may be lost if you save it as a CSV (comma delimited) manual , However, when Robot Simulate click "Save" button, did not pop up that window, Someone can help me?

Help Studio
, ,
1

Step:
1.Open the xls Excel, refer to attachment
2.press F12(or Fn+F12), then pop up save as window
3.Select CSV(Comma delimited), fill in csv file name
4.Click “Save” button

image
test.xls (24 KB)

2

HI @Lori

Correct me if iam wrong this popup is not appearing all the times when you save them?

Regards
Gokul

3

Hi!

In which step you were stuck ?

try this:

1.Excel Application scope
2.Read Range to read the entire sheet
3.Send HotKey to send the F12
4.Select item to select the csv format
5.Type into to type the data

Regards,
NaNi

4

If yes ,

You can try like this

  • Use Element Exists and indicate on the popup and store in a variable
  • Use If pass the variable of Element Exists which is Boolean Variable

Regards
Gokul

5

If you setting as attachment, I think it should always pop up

image
image1086×530 36.6 KB

6

Okay So Can you elaborate on your task bit mor?

7

I description my step in body, my issue is when manual per my steps, that window pop up, when robot, that window disappear. I need this window and click Yes, it can keep some special characters format。

8

Hi!

use delay activity!

Regards,
NaNi

9

I need this window and click Yes, it can keep some special characters format. however, when robot click save button, this window cannot pop up.

10

Have you enabled the Visible property in Excel Application Scope if you use that ?

Regards
Gokul

11

Hi!

Have a view on this

Exce
Exce545×716 25.6 KB

Regards,
NaNi

12

testExcel.xaml (24.2 KB)

13

Just give it a try with excel modern Activities by enabling show excel alerts in project settings

  • Open Project Settings ->Excel Modern ->Enable show excel alerts.

image
image691×587 31.9 KB

Regards
Gokul

14

I had add the process, Please help to check, thanks.

15

Means that it is not appearing in the foreground for clicking right?

16

It seems that did not have what you said.

image
image731×842 46 KB

17

I will test next week and reply, thanks.

18

If this is your cause you can try with Activate Window Activity

image

Okay Great let us know if it resolved? Happy Weekend!!!

Regards
Gokul

19

@Gokul001
Hi, I test per your method, the element exist output is false, can not get that window and click “Yes” button.

image
image1901×769 63.8 KB

20

Hi!

could you please re-indicate the Element Exists activity on Button instead of text?

Regards,
NaNi