I have seen other posts on this topic, but none of them seem to have garnered any solutions:
My issue is specific to an HTML/Web Page Excel. I guess it is a report that gets generated as HTML inside of an excel workbook. I need to have UI path convert this to an xlsx. If the workbook is opened, I get an warning saying the format and file extension do not match. If I click ‘yes’ to continue, it will display the data. I can then manually save the file as ‘xlsx’. I am not sure how to accomplish this in Studio X or Studio.
Simply trying to rename the file extension to ‘xlsx’ using a file move will not work. I believe the file needs to be opened, the error overcome and the file saved as ‘xlsx’.