Import files to grid

FastGrid documentation

Files to FastGrid can be imported by dropping them to the grid or by opening them by clicking to Import icon on toolbar.
It is possible to import xlsx, csv or json files.
If set Book, the xlsx or json is imported as all new sheets, the csv is imported as one new sheet.
If not set Book, the active sheet data in xlsx or json are added to existing grid, the csv data are added to existing grid. It does not modify columns.
How files can be imported to the grid:
1. bit &1 - If files can be imported by choosing them in system file dialog.
2. bit &2 - If files can be imported by dropping them to grid.
3. bit &4 - If more files can be imported at once.
If files can be dropped to the grid.
If set to 1 or -1, dropping of any unsupported file to the grid will cancel default browser action for this file drop.
It must be set to 1 to permit dropping xlsx files for import and dropping image files to cells.
List of file extensions that can be imported to the grid. It can be comma separated string or array.
It can be also an object with name:value to specify extensions and their meaning like ImportExt:{xlsx:"xlsx",xlsm:"xlsx",xltx:"xlsx",json:"json",js:"json",csv:"csv"}.
There is built-in support for importing standard xlsx and csv formats and proprietar FastGrid json format.
If the imported file(s) will be added to existing data or the existing data will be discarded.
0 - It shows message with buttons Add/Discard/Cancel.
1 - It adds the file(s) to the existing data.
2 - It discards the existing data and opens the file(s).
5 - It shows message with Add/Cancel buttons.
6 - It shows message with Discard/Cancel buttons.
What imports from the xlsx or json to existing grid (no Book is set) and ImportAdd adds the data or ImportReplace is not set.
0 - imports only cell values. If import contains editable formulas, imports only their results.
1 - imports also cell attributes and editable formulas.
If set Book, it always imports the data fully including attributes and full layout. If not set, removes from the imported json all JavaScript code, removes all event handlers, JavaScript formulas and JavaScript functions. If set and no Book is set, the imported data replaces also columns.
0 - uses JavaScript eval for parsing the input data. The format is less strict, but if the data contains JavaScript code, it is executed.
1 - uses JavaScript eval for parsing the input data, but fails if the json contains any functions calls, global assignments or function definitions. The format is still less strict than JSON parse. It also switches Method from null to get.
2 - uses safe JSON.parse for parsing the input data. It requires correct JSON format, but never runs any JavaScript code in data. It also switches Method from null to get.
id of the part, where the data are added, if no Book is set.
For csv the CsvBody is preferred.
Encoding of the imported text files like json and csv. The value is ISO encoding like "iso-8859-1" or "UTF-8".
How the locked sheets and workbooks with password will be imported.
0 - password will be removed and the sheet can be unlocked.
1 - password will be stored and the saved sheet will be locked with this password and the changed locks if any. Sheet can be unlocked in grid.
2 - password will be stored and the saved sheet will be locked with this password and the same locks. Sheet can be unlocked in grid.
3 - password will be stored and the saved sheet will be locked with this password and the same locks. Sheet cannot be unlocked.
Opens system dialog to choose file(s) for import. Available only if set ImportAction&1.
Called before given files are imported to the grid.
type is 1 for adding files, 2 for discard existing data.
Return true to cancel the import.
Called after given files were read and before the read data data are imported to the grid.
type is 1 for adding files, 2 for discard existing data.
errors contains array of errors if any, see OnImportDataError.
Return true to not do the default import.
Called after given files have been imported to the grid. The changes are already painted.
errors is array of errors - the other files that were imported but failed, see OnImportDataError. On full success the array has zero length.
Called after given files have been imported to the grid and / or there were some errors. The changes are already painted.
files can have zero length if no file was successfully imported.
errors contains array of errors - the files that failed to import. The structure is [[code1,filename1,errortext1,file1,error1],[code2,filename2,errortext2,file2,error2],...].
Where code is data error code, here can be -8 - Invalid xlsx data or -9 - Error loading imported file, filename is name of the file, errortext is error message, file is File object, error is full error object or exception.
It is called before OnImportedData if both events are called.
Return true to not display default error message.
Merges grid and all other sheets in its Book into actual grid and its Book.
Adds the new sheet to the end of actual grid Book.
If the grid has no Book, adds it as single sheet. If actual grid has no Book, adds it in begining of grid Book.
If none of the grids has Book, it creates new Book with these two sheets.