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.
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.