Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.dhtmlx.com/suite/grid/api/export/grid_xlsx_method/ below:

Website Navigation

• Previous

  png()

• Next

  Clipboard events

JavaScript Grid - xlsx Method

Exports data from a grid to an Excel file

xlsx(config?: object): void;

• config - (optional) an object with export settings. You can specify the following settings for export to Excel:
  • url?: string - (optional) the path to the worker.js file of the Json2Excel library (where export will be processed) set as "../libs/json2excel/1.3/worker.js?vx", if the local export server is used. The path to the public export server is used by default
  • name?: string - (optional) "grid" by default. The name of a ready Excel file
  • tableName?: string - (optional) "data" by default. The name of a sheet with grid data in the Excel file
  • dateFormatMask?: string - (optional) "dd/mm/yy" by default. The mask used for dates formatting in Excel

Example

// default export
grid.export.xlsx();

// export with config settings
grid.export.xlsx({
    url: "../libs/json2excel/1.3/worker.js?vx", // a local path to the `worker.js` file of the export module
    name: "my_file", // the name of a ready Excel file
    tableName: "grid", // the name of a sheet with grid data in the Excel file
    dateFormatMask: "mm.dd.yy" // the date format mask for Excel
});

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4