Generate Excel from filtered data of Collections

Discussion Ask a question
,
1

I need to generate an Excel of data of a collection. I need to select what fields should be included and have the possibility of filter records. The information should not be as JSON. I need to be presented in one column for each field.
Is it this possible with Wix Code?
Thanks for your help!!!

1 Like
2

@avillarg
Yes…Its Possible :slight_smile:

3

Nithin, thank you for your answer.
And now a second question: Where can I find a tutorial or instructions to generate it?

4

There is no tutorial or instructions to do it with wix…but I can try using some npm modules available in wix to do it…

5

@thrishtilabs : npm modules?

6

@avillarg yes there is a csv npm module available in wix…

7

@thrishtilabs I’ll try it. Thank you!

2 Likes
8

Is it working? did you try it?

9

Ofir I used a different method based in this link: https://www.wix.com/corvid/forum/community-discussion/export-any-data-collections-to-ms-excel-using-wix-code-video
I had to change the HTML code as follows

resultados.xls
10

@thrishtilabs : I need your help again! Could you please look my question in https://www.wix.com/corvid/forum/community-discussion/bulkremove
I’m very frustrated!

11

I just wrote how to do that :slight_smile:

let me know if you have any question

12

Hi Ofir,
you are welcome to try my tutorial using the xlsx package.

let me know if you have any question

13

It Works! Thanks!!!

14

@ofiraviram awesome :sunglasses:

15

I want to have customized headers in excel rather than field names. for example, rather than having column name as ‘publishdate’, I want to show ‘Publish Date’. How do I achieve this? thanks in advance. Since I know the exact number of columns I will have in excel, I don’t mind even hard coding them. thanks