KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Export json to excel #1746

Open ankit raj opened this topic on on Dec 3, 2020 - 1 comments
ankit raj commented on Dec 3, 2020

Hi, I am showing top 500 records , but when someone clicks on download , i need to fetch all records and export it to excel. I have already fetched the json of the complete data but how to export it to excel? And what should be the format of the json which the widget will understand?

Sebastian Morales commented on Dec 4, 2020

Ankit, pls use the Map process to convert your json to array data with json_decode($jsonValue, true) and pipe them to a datastore. Then export the datastore to excel.

https://www.koolreport.com/docs/processes/map/

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed
Excel

Designed and built with by KoolPHP Inc.

Code licensed MIT.