in terms of permissions, anyone can write to the collection but only members can read it. So, a visitor can enter the site, upload a picture using the upload button and I want only site members to view it. it's correct that only members can access the data in the collection. However, the link that you can find in the media manager for this picture, can be opened by anyone.

@russian-dima do you know if I can freeze the first item?

It's very easy to create a responsive table with HTML-component but I am pulling the data from a google sheet file with about 18 columns and I want to write the file as well.Using a repeater might be a good idea. I will try it.

hmm I guess that designing a repeater like a table is not that easy. Anyway, will it be responsive? did you try it?

@russian-dima Hi, the example above is a free website and as you can see, it is working. do you click the document icon and then the "export to excel" button?

@russian-dima sure. here is an example. if you want, I can add you as an editor https://zivassor.wixsite.com/exporttoexcel

Hi, you can use ןא on free web sites as well. if you want, I can share a free website with you so you can check it.

Hi, you can use it on free-sites as well

Looks like I need to choose a file and replace this url with this: gcr.io/corvid-api/mysql-connector-node@sha256:b52ca2327216edb6c7c92728b75c0e463c9b6fa45994a847068fb556fba3bf9f yet, something is go wrong and I can't use MySQL as an external database for wix velo

Hi, just use the wixData.query function to add the data from each collection, then you can pass it to the excel file.

Hi, sure. You can add another sheet.

Hi @Lmarie , Sounds like the best way to do what you are asking for is using google sheet API. You can see here how to do that. good luck!

Hi @Contato 2Fee , about the empty cells, in the "Button element (I called it iconButton2)" replace this code result2[i] = Object.values(results.items[i]); with this result2[i] = [results.items[i].first_col, results.items[I].sec_col, etc...]; make sure you to write all columns you need (In case you too many, you can use a loop for this). About the header, in the "Button element (I called it iconButton2)", replace this code createAoA(rowsNum, colNum).then(result2 => { for (var i = 0; i < rowsNum; i++) {                         result2[i] = Object.values(results.items[i]);                     } with this createAoA(rowsNum, colNum).then(result2 => { result2[0] = [col_1, col_2, col_3, etc...]; for (var i = 0; i < rowsNum; i++) {                         result2[i+1] = Object.values(results.items[i]);                     } please let me know if you have any questions

Hi, it works perfectly here

Hi, just ignore the require error. Can you share the link for this page? I will try to see what is wrong

Did you figure it out?

It's ok. just ignore it

@Ofir Aviram awesome 😎

here is a new tutorial: https://www.wix.com/corvid/forum/tips-tutorials-examples/export-data-collection-to-xls-excel-file-using-code

Hi Ofir, you are welcome to try my tutorial using the xlsx package. https://www.wix.com/corvid/forum/tips-tutorials-examples/export-data-collection-to-xls-excel-file-using-code let me know if you have any question