Select item does not work for me!


#1

Hi,

I have an excel automation process underway. Here I have to save the excel file as a csv.

In the process, I click on ‘Save As’ and then use Select Item Activity to click on type "CSV (Comma delimited) ". When I do this, the activity does not accept this value and as a result, the file gets saved as default Excel workbook again.

All other steps above and below the entire process are working fine.

Can someone please help?

Thanks and regards,
Sarika


#2

Hi,
Select item working fine for me.
How ever you could save using excel as csv by using write csv activity by passing the existing datatable.


#3

Hi Dilip,

Thanks, have tried write CSV, but it is overrdung some specfic format changes that I have done in the excel that I need when it writes into csv.

Manually, the only option that works is the Save As. That is why I went to the recording option.

Can you please share a sample xaml file of the activity Select Item that is working fine?
I am basically not able to get the activity to accept the specified input.

Thanks,
Sarika


#4

Hi there @sarikaaggarwal,
While you can get ‘Select Item’ working with the ‘Excel Save As’ window, I find it easier to used a dynamic selector.

Testing - Save As.xaml (18.6 KB)

The above example will demonstrate this, it basically opens the ‘Save As Combo Box’, selects the item, then saves.

Thanks,
Josh


#5

This is awesome! it works!!! Thank you so much!


#6

Hi there @sarikaaggarwal ,
If you are happy with the result, would you please mark the response as the solution :slight_smile:

Thanks,
Josh


#7

Sure :slight_smile: @Mr_JDavey