Export sql tables to Excel on button click

  • 15 January 2019
  • 2 replies
  • 5 views

Hi,

 

I need to export SQL tables with more than 500 records to excel spreadsheet.

When the end user clicks on a button, it will export the SQL tables to excel. Can we accomplish this with SQL stored procedure? 

Any help is really appreciated.

 

Thanks.


2 replies

Hi Mani1,

 

K2 does not have this feature OOTB however, you can try a custom control or service broker like the one linked below:
https://community.k2.com/t5/K2-blackpearl/Excel-Controls/ba-p/1105?nobounce#

 

A feature request has also been logged for this and you are welcome to upvote:
https://ideas.k2.com/ideas/APIT-I-107

 

-Sello

Perhaps this built-in feature in K2 5.1 might meet your requirements.  

 

https://help.k2.com/onlinehelp/k2five/userguide/5.2/default.htm#create/views/configuringexporttoexcel.htm

 

If you're using an earlier version than the suggestions Mani1 gave should help.  There is also an export to csv project that I've used in the past that's worked well.

https://community.k2.com/t5/General-K2-Utilities/CSV-Service/ba-p/83163

 

Reply