[Help] How can I generate two tabs/worksheets for excel?

[prady00]

[rajansoft1]

This library is for making csv files and not excel file, i dont think their is any library for angular to convert json to excel

[ghost]

I want to export multiple csv files as a zip/rar on a button/anchor click ... how can i do that? I tried passing an array of arrays in ng-csv directive but it didn't work. please help.

[shaohaolin]

@asafdav I have modified the code to be able to generate multiple tables by passing an object. The object is format like this: var object = { array1: [ ], array2: []} I finished the implementation and unit test for the multi-csv feature. It's in my repo on the multicsv branch. Let me know what you think !

[asafdav]

Hi, can you add a test case and pull request? I'll checkout locally and test it

On Fri, Oct 16, 2015 at 4:29 PM, Shaohao [email protected] wrote:

@asafdav https://github.com/asafdav I have modified the code to be able to generate multiple tables by passing an object. The object is format like this: var object = { array1: [ ], array2: []} I wonder how I can do a demon for you?

— Reply to this email directly or view it on GitHub https://github.com/asafdav/ng-csv/issues/90#issuecomment-148716634.

[codingquark]

So I cannot export more than one table at this point. Is that right? If it is, is there some work around so that I can include some meta info such as filters applied etc at the top of the table/sheet?

[codingquark]

I have solved it by using a callback for ng-csv Ability to format the data however we want is useful. :)

[DeepzSandra]

i have also same issue can u please tell me!!

[dtturcotte]

@asafdav @shaohaolin Has the feature to export multiple tabs to CSV format been added? I'd like them to be able to open it in Google Sheets or something with:

col1  |  col2 |       col3  |      col4
-------------------------------------
1          4           7           10
2          5           8           11
3          6           9           12

-------------------------------------
[<current> csv sheet 1]  [csv sheet 2]  [csv sheet n] 

[dtturcotte]

@shaohaolin I cherry picked your updates for multi CSV. It doesn't create multiple tabs, nor does it take into account separate Header sets per dataset. Any updates there?

[aarchsk]

Hi , I am also looking for same feature multi csv, any updates?How do we achieve it?