Convert Excel document from .xls to .xlsx

  • 13 January 2020
  • 1 reply
  • 2 views

Badge +8

An excel report is sent into to an SP mailbox in .xls format. A workflow is started and included in the WF is the action "query excel services" the workflow errors as it can not perform the action in the .xls format. Therefore the document has to be manually saved in the required format .xlsx before being sent to the SP mailbox. There are multiple documents so this is quite a task just to resave them all.

 

Just wondering if there a way of using nintex to update/rename the format from .xls to .xlsx?


1 reply

Userlevel 6
Badge +22
Hi,

This is hard enough to do in SharePoint let alone doing it with a Nintex workflow.

Two methods I have found:
1. Open the library in Explorer using the Open with Explorer icon from the ribbon and then just rename the files.
2. The other is to use a power shell script.
https://docs.microsoft.com/en-au/archive/blogs/sharepointdevelopersupport/how-to-change-file-extension-of-an-existing-item-in-sharepoint-document-library

Reply