Export Buttons

[manusimon]

It would be great having optional buttons for exporting data from the table in PDF, CSV...

[tevosouza]

hello @manusimon!
I hope that u are fine!

i'm trying to implement a plugin that can export the data, its earlier yet and i can export data to JSON at the moment and have a few limitations, like:

• If pagination is active, it can only export the current page
• Not tested on server search or pagination yet

Follow my code (experimental)

@afshinm, can you let me know if i'm on "right" path?

import { h } from 'preact';
import { useSelector } from "gridjs";
import { download } from './actions'


export interface ExportedRowData
{
  rowindex: number;
  columns: ExportColumnData[]
}

export interface ExportColumnData
{
  index:number
  name: string;
  value: string 
}

export function ExportGrid() {

  const data = useSelector((state) => state.data);
  const header = useSelector((state) => state.header);

  function doExport() {

  const exported: ExportedRowData[] = [];
    
    if (data)    
      data.rows.forEach((r, i) => {
        
        exported.push({
          rowindex: i,
          columns: []
        });

        r.cells.map(x => x.data).forEach((x, ic) => {
          exported[i].columns.push(
            {
              index: i,
              name: header.columns[ic].name,
              value: x
            }
          )
        });
      });
    
    download(JSON.stringify(exported), 'exported.json', 'application/json')  
  }
  
  return (
    <input
      type={'button'}
      value='Export JSON'
      onClick={() => doExport()}
    />
  );

}

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.