Export multiple Angular ng-grids to an Excel file?

Question

i have 7 grids and i need to export them to an Excel file. It can be done putting each one on a sheet or all of them in the same sheet but I don't have a single clue in how to achieve this.

Can someone give me an advise?

Please do some research into creating excel files and when you have some real live code problems you will get plenty of help then. There are libraries available for both client and server. Question is just far too broad currently — charlietfl
– charlietfl, Commented Sep 24, 2015 at 21:00

eddyP23 · Accepted Answer · 2017-03-03 11:49:43Z

1

Why not get the data from grids into arrays, then use .join function to make strings from arrays, to convert it to CSV format. It is not the main .xls(x) format, but close enough.

For example, if you have an array:

var myArray = ["Peter", "21", "2005"]
var myString = myArray.join(",")

Then myString will be "Peter,21,2005", which is exactly CSV format.

Now just open the file with excel and you have it.

edited Mar 3, 2017 at 11:49

answered Sep 24, 2015 at 21:10

eddyP23

6,96312 gold badges59 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export multiple Angular ng-grids to an Excel file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related