How to use save as in excel? which activity should use . is send hotkey activities is working fine, then in that which function should use?

Help Activities
, ,
1

I wanted to use save as in excel, and I was using click activities on the file-browse-save as , but its not working alwys facing selector issue. I was trying to use send hotkey activities. can you please help on these case?

2

Hi @Priti_Patil

You can use the Keyboard shortcuts activity to save as the file. It will work perfect.

Or if you want to do with excel activities there is an activity called save excel file as activity which will works the same.

Hope It helps!!

3

Hi,

Try by below simple approach:-

  1. Drag and drop an “Excel Application Scope” activity onto your workflow.
  2. In the “WorkbookPath” property of the “Excel Application Scope” activity, specify the path where you want to save the Excel file. You can use a variable or type the path directly.
  3. Within the “Excel Application Scope,” drag and drop a “Write Range” activity.
  4. In the “SheetName” property of the “Write Range” activity, specify the name of the Excel sheet where you want to write the data. If the sheet doesn’t exist, UiPath will create it.
  5. In the “Range” property of the “Write Range” activity, you can specify the range where you want to write the data. For example, you can use “A1” to start writing from cell A1.
  6. In the “DataTable” property of the “Write Range” activity, select the DataTable variable you want to write to the Excel file.

Thanks