The data table do not display with search & sorting filters

[digitala11y]

I replaced the spread sheet with my own sheet that can be viewed with a link by anyone. The sortable data table do not appear along with search & pagination.

I am a screen reader user & screen reader identifies data table & announce the content of all rows.

Is there a specific format for the google sheet need to be setup? I used the index.html in GitHub file & just replaced with my own sheet.

[chriszarate]

The sortable data table do not appear along with search & pagination.

Do you mean that you are trying to use DataTables, per this example?
https://chriszarate.github.io/sheetrock/#datatables

The only requirement is that you provide a public Google Sheets URL that includes the gid parameter:

Sheetrock’s only required option is the URL of a public Google Spreadsheet. (Click “Share” and set visibility to “Anyone with the link” or “Public on the web.”) As an example, let’s use this spreadsheet, which contains 1986 National League batting statistics.

Make sure you include the #gid=X portion of the URL; it identifies the specific worksheet you want to use.

[digitala11y]

Hello,
Yes, i am trying to get the data table. currently i have 30 rows of data. i did add the URL the right way. for some reason your example works perfectly on all browsers & screen reader. my sheet is broken on chrome, no table semantics. only firefox table is identified with no sorting & search field. i will do some more digging & get back.

[digitala11y]

Ok, i replaced my sheet content with your sheet & it works. I will take it forward from here. is there a way to download the filtered content as csv? any function or library i need to use?

[chriszarate]

is there a way to download the filtered content as csv? any function or library i need to use?

Hmmm, I'm not sure the best way to do that. I can see that there are a few DataTables plugins that might help with that. For example:

https://datatables.net/reference/button/csv

[digitala11y]

Thank you for that resource, i see that datatables.net provide the necessary functions i need. can i use any of them with sheet rock? i see they have charts & other plug-ins too. not sure if they conflict with sheet rock. so would like to check before i start my development.