Not able to open the excel report placed in a folder using connect-file method.
I have a requirement to create a report in excel format(xlsx) and place it in a shared path.
I have implemented the report generation along with case creation. The excel file will be attached to the case and same will be placed in the path using Connect-File method.
The file is being placed successfully in the path. But, excel file is not opening and giving the below error message:
"Excel cannot open the file '<<Filename>>.xlsx' because the file format or file extension is not valid. Verify that file has not been corrupted and that the file extension matches the format of the file."
Attached the error message and connect-file method.
The same file attached to the case was able to download and open without any issues.
***Edited by Moderator Marije to change type from General to Product, added Product details and Capability tags****