Creating multiple excel sheets in the same excel file from single dataset

1 Answer 198 Views
Excel Export
Abhishek
Top achievements
Rank 2
Iron
Iron
Iron
Abhishek asked on 06 Sep 2023, 02:01 PM
I have single dataset. I want to create multiple sheets in the same excel file.   i tried this example.                                          https://www.telerik.com/forums/how-to-add-multiple-sheet-in-react-export.     But its not saving. i am trying in functional components. Kindly help. Thanks

1 Answer, 1 is accepted

Sort by
1
Accepted
Wissam
Telerik team
answered on 08 Sep 2023, 05:37 AM

Hello, Abhishek,

I prepared an example using functional components where I am using a single dataset to render two different sheets:

I also prepared an example for two Grids like in the Knowledge Base article but with functional components:

I hope this helps, but please let me know if you have any further questions.

Regards,
Wissam
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources!

Abhishek
Top achievements
Rank 2
Iron
Iron
Iron
commented on 08 Sep 2023, 06:26 AM

This worked. Thank you Wissam for your help!!.
Wissam
Telerik team
commented on 08 Sep 2023, 07:07 AM

You are welcome, Abhishek. I am glad that my reply was helpful to you.
Abhishek
Top achievements
Rank 2
Iron
Iron
Iron
commented on 08 Sep 2023, 07:34 AM

1 doubt i have.  Is it possible to pass multiple parameters in ref?? Because in my case Excel columns are same for all the 4 sheets. 
Wissam
Telerik team
commented on 11 Sep 2023, 01:56 PM

Hi, Abhishek,

Could you please provide me with more information on your use case scenario, and possible send me a runnable example?

Are you using the same data object in the 4 sheets or does each sheet have a separate data?

On the other hand, you can refer to the following discussion or a similar one on how to use multiple refs for an array of elements:

In addition, I could see that you do not have a license. Therefore, I would suggest registering for a trial license to benefit from the KendoReact support service.

Regards,
Wissam
Progress Telerik
Tags
Excel Export
Asked by
Abhishek
Top achievements
Rank 2
Iron
Iron
Iron
Answers by
Wissam
Telerik team
Share this question
or