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
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.
Is there no way to perform Microsoft.Office.Interop.Excel.Workbook.SaveAs(directory)?
Here is an activity to perform the SaveAs workbook.