Is it possible to export a list of data to excel with the export function but without the the grid component?

1 Answer 491 Views
Button Grid
CHIHPEI
Top achievements
Rank 2
Iron
Iron
Iron
CHIHPEI asked on 15 Sep 2022, 10:08 AM

Scenario:

I've used grid component before,
and I'm aware that it has excel export function,
but what it exports is all the data from the grid.
However, in my scenario,
data in each row of my grid is only the maximum value of a list of data,
and I would like to press the button and export the list of data,
where the button is at the last column of the row.
Its hard to describe with words,
So I'll leave a picture hoping it will clarify my question

1 Answer, 1 is accepted

Sort by
1
Accepted
Aleksandar
Telerik team
answered on 20 Sep 2022, 05:04 AM

Hello CHIHPEI,

You can review the kendo.ooxml.Workbook API and the documentation section on Excel generation on the client for additional details on using the API. So for example, upon click of a button you could make a request to an endpoint, that would return the desired data(if not already available on the client) and generate a Workbook and export to Excel.

Another option I can think of is demonstrated in the Server Export demo where the Excel workbook is generated on the server. Make sure to click on the View Source tab to review the complete implementation and the documentation on the functionality

I hope this helps implement the desired functionality.

Regards,
Aleksandar
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

CHIHPEI
Top achievements
Rank 2
Iron
Iron
Iron
commented on 21 Sep 2022, 01:11 AM

Hi Aleksandar,

Thanks for replying, haven't try any thing yet but 
I think  kendo.ooxml.Workbook might be an ideal option for my case.

Maybe I'll implement the Excel export button in the last cell of a row,

once the button was clicked, then retrieving the row data as query parameters,

and used the Workbook API to return data and generate Excel file.

Again, thanks for providing several solutions

 

CHIHPEI

Tags
Button Grid
Asked by
CHIHPEI
Top achievements
Rank 2
Iron
Iron
Iron
Answers by
Aleksandar
Telerik team
Share this question
or