How to use Workbook.SaveAs() in uipath invoke method

Need to change file format(i.e xls to xlsx) using uipath code.

You can record a sequence for the same to do it in MS Excel. See this

Or another way if you are in between of an automation Use Read Range save data to DataTable, then Use write range and in Excel Application Scope change the extension
“Yourfile.xlsx” that is it

2 Likes

Thanks for you reply… I was previously changing format with Export option in excel, But now i want to do with workbook object using SaveAs method.

1 Like

Is there no way to perform Microsoft.Office.Interop.Excel.Workbook.SaveAs(directory)?

Hi ,
Here is an activity to perform the SaveAs workbook.

Regards
Balamurugan.S