Premium plugin : Open file - GBonnaire/jspreadsheet-plugins-and-editors GitHub Wiki

JSpreadsheet Plugin : openFile

You can buy this plugin on Repo plugin openFile Demo is available on demo

Features

  • modal for open file CSV, XLS, XLSX from your computer (without throught by server)
  • options on open (separator for csv, import style for XLSX, remove current sheets)

Dependencies

Options of plugin

Option name Description Type Default Value
allowShortcut Allow use shortcut CTRL + O for open file Boolean true
icon_toolbar Material icon on toolbar String folder_open

For translation

If you use general translator, you can translate this plugin to replace "text_" by "openfile_"

Option name Default Value
text_toolbar_badge Open file
text_popup_title_options Options of import
text_popup_removesheets Remove current sheets
text_popup_csvdelimiter Delimiter fields in row
text_popup_csvheaders First row is an header
text_popup_loadstyle Load style from file
text_loading_loadingsheet Loading sheet
text_loading_creatingsheet Creating sheet
text_loading_loadingdata Loading data in
text_loading_calculatesheet Calculate data in

Methods of plugin

Method Description Example
open() → Void open modal for choose file on local jspreadsheet.current.plugins.formula.hide();

Events of plugin

Event Arguments Description
openfile_onload DOMElementJSS, instanceJSS After load file, this event is dispatched

Get started

Header on page

<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />

<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />

<script src="/path/to/jspreadsheet.openFile.js"></script>

Initialize plugin on JSpreadsheet

jspreadsheet(document.getElementById('spreadsheet'), {
	...
	plugins: [
      ...
      { name:'openFile', plugin:jss_openfile },
      ...  
    ],
    ...
});

Copyright and license

Copyright GBonnaire.fr and Code released under the commercail License. This plugin requiere license of Repo.gbonnaire.fr

All librairies available on https://repo.gbonnaire.fr

⚠️ **GitHub.com Fallback** ⚠️