GridJsWorkbook class

GridJsWorkbook class

Represents the main entry class for GridJs

The GridJsWorkbook type exposes the following members:

Constructors

Constructor	Description
init	Constructs a new instance of GridJsWorkbook

Properties

Property	Description
settings	Represents the workbook settings.
cache_imp	Custom implemention for cache storage,If you want to store cache in stream way ,you need to set and implement it.
calculate_engine	Custom implemention for calculation engine ,If you want to do custom calculation, you need to set and implement it.

Methods

Method	Description
import_excel_file	Imports the excel file from file path and open password.
import_excel_file	Imports the excel file from the file path.
import_excel_file	Imports the excel file from the file path.
import_excel_file	Imports the excel file from file stream with load format and open password.
import_excel_file	Imports the excel file from file stream.
import_excel_file	Imports the excel file from file stream with load format and open password.
import_excel_file	Imports the excel file from file stream with load format.
export_to_json	Gets JSON format string from memory data with the specified filename.
export_to_json	Gets JSON format string of the default empty spreadsheet file.
save_to_excel_file	Saves the memory data to the sream, baseed on the origin file format.
save_to_excel_file	Saves the memory data to the file path,if the file has extension ,save format is baseed on the file extension .
save_to_pdf	Saves the memory data to the file path,the save format is pdf.
save_to_pdf	Saves the memory data to the sream,the save format is pdf.
save_to_xlsx	Saves the memory data to the file path,the save format is xlsx.
save_to_xlsx	Saves the memory data to the sream,the save format is xlsx.
save_to_html	Saves the memory data to the file path,the save format is html.
save_to_html	Saves the memory data to the sream,the save format is html
get_json_str_by_uid	Gets the JSON format string from the file cache by the specified unique id.
get_uid_for_file	Gets unique id for the file cache.
import_excel_file_from_json	Imports the excel file from JSON format string.
merge_excel_file_from_json	Applies a batch update to the memory data.
save_to_cache_with_file_name	Saves the memory data to the cache file with the specified filename and also set the open password, the save format is baseed on the file extension of the filename .
get_image_stream	Get Stream of image from memory data.
get_ole	Gets the byte array data of the embedded ole object .
update_cell	Applies the update operation.
insert_image	Inserts image in the worksheet from file stream or the URL,(either the file stream or the URL shall be provided) or /cells/ Inserts sh/cells/n the p.type is one of AutoShapeType
copy_image_or_shape	Copys image or shape.
error_json	Gets the error message string in JSON format.
get_grid_load_format	Gets the load format by file extension
get_image_url	Gets the image URL.
set_image_url_base

See Also

• module aspose.cellsgridjs