Export to Excel not working, button does not download the Excel spreadsheet

  • 16 February 2021
  • 0 replies
  • 74 views
MillaZ
Userlevel 5
Badge +20
 

Export to Excel not working, button does not download the Excel spreadsheet

kbt151057

PRODUCT
K2 Five 5.1
BASED ON
K2 Five 5.1
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Issue

After using this documentation to set up the Export to Excel toolbar button, nothing appears to happen after the button is clicked.

 

Symptoms

When the button is clicked, the correct Ajax call goes out and a "200 OK" response is sent back with no data (Content Length = 0). No errors are seen in the trace, HostServer logs nor the SmartObjects logs.

Resolution

This is caused by a missing "C:Program Files (x86)Open XML SDKV2.0libDocumentFormat.OpenXml.dll" on the K2 Web Server (it will likely exist on the K2 App Server).

To resolve this issue, download the following on the Web Server and perform an IIS reset: Open XML SDK 2.0 for Microsoft Office

After the IIS reset is complete, refresh the List View page and the Export to Excel button should now successfully download an Excel spreadsheet with the list view's data.

Check out these Nintex University Learning paths: https://community.nintex.com/p/NintexUniversity

0 replies

Be the first to reply!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings