Export to Excel on List View

Hello  @BB33,

Please kindly review the content below to help export your data: 

EXCEL AS SMO SERVICE BROKER,

https://community.k2.com/t5/General-K2-Utilities/EXCEL-AS-SMO-SERVICE-BROKER/ba-p/86040?nobounce

Import and export data from Excel to database,

https://community.k2.com/t5/K2-Cloud/Import-and-export-data-from-Excel-to-database/td-p/113135

Exporting to CSV

https://help.k2.com/onlinehelp/k2cloud/userguide/update_10/default.htm#Apps/Report/Report-Approval-Apps.htm

Enjoy

Hi  @BB33 ,

I see there has been a solution to your problem by showing hidden column before executing "export to excel" and hiding the column after that.

However, I created the following example to implement a similar solution by using OData to export data from a SmartObject to Excel without the need to show the hidden column before exporting and re-hiding the column  afterwards.

Created a SmartObject with two properties, Value and Image:

Created an Editable List View from the SmartObject where I can add fieelds to the view:

In the "Value" Column unchecked the "Visible checkbox.

Added a few rows with values and images and as seen, the Value column is hidden:

Navigate to the K2 Management site and navigate to "SmartObject OData":

Click to Enable "SmartObject OData API"

Under "Which SmartObjects?" select "Selected SmartObjects" and choose your SmartObject that contains the data and copy the "OData URL" as you will need this when exxporting your data to Excel:

After configuring the settings shown above, remember to copy the OData URL. And then click "Apply Changes"

Open Excel, under the "Data" tab, click to add data "From Other Sources" and select "From OData Data Field"

Paste the OData URL that you copied into the "Location of the data feed" field and enter your relevant login details:

Click Next, and select your SmartObject:

Click Next and then Finish, then choose how you want to view the data in Excel.

Your data should now be displayed with the id and the hidden column without the images:

Hope this helps.

Kind regards,

Dian