How can I export to csv using jquery as multiple sheets in the same excel file?

Asked Aug 19 '15 at 19:54

Active Aug 19 '15 at 20:34

Viewed 759 times

I am using the solution mentioned here: Export to CSV using jQuery and html

The fiddle for this is: http://jsfiddle.net/terryyounghk/KPEGU/

I will be calling the function exportTableToCSV multiple times as I have three tables per category (Category1 has three tables, Category2 has three tables and CAtegory3 has three tables).

What I want is a separate sheet in the same excel file per category.

How do I need to change the following code here to be able to create three sheets in the same excel file - Category 1, 2 and 3?

$(this).attr({
                                'download': 'export.csv',
                                'href': csvData,
                                'target': '_blank'
                            });

I have implemented all 6 tables in one sheet right now. If I can figure this one out with this method, it will be great!

edited May 23 '17 at 11:58

Community

asked Aug 19 '15 at 19:54

Righto

csv doesn't have sheets, you will need to use an excel library – charlietfl Aug 19 '15 at 20:15
Since I am able to download it as an excel sheet, I was wondering there would be some way to create sheets in it as well. – Righto Aug 19 '15 at 20:23

How can I export to csv using jquery as multiple sheets in the same excel file?

0 Answers0