- Export of data from Spreadsheet to Excel
- Import of data from Excel to Spreadsheet
- Number formatting
- Auto filling of cells
- Hotkeys behavior in a range of cells
Import and Export to Excel
The current update enables end users to import Excel data into a web spreadsheet component as well as export data from Spreadsheet to Excel.
Check the samples with import of Excel data into Spreadsheet and export of Spreadsheet data to Excel >
The export and import operations became possible due to our two new WebAssembly-based libraries Excel2Json and Json2Excel. These libraries were developed by our team as open-source tools for converting Excel files into the JSON format and vice versa. They make use of the Rust programming language and WebAssembly.
1) Install the corresponding library for export and import
2) Specify the necessary options in the Spreadsheet configuration and link the component to the installed libraries
3) Apply the related API methods
V3.1 comes out with an ability to set different formats for numeric values in cells. Spreadsheet default number formats are common (“”), currency (“$#,##0.00”), number (“#,##0.00”), and percent (“#,##0.00%”).
Applying a number format to a value is easy with the setFormat method:
Besides, there is the getFormat method, which allows you to define what number format is applied for a particular cell:
On top of all, you can modify the default number formats or even create custom formats via the formats configuration option. For example, you can change the name of the predefined currency format for “U.S. dollar” and add two new formats with ids – “euro” and “franc”:
name: "U.S. Dollar",
name: "Swiss franc",
mask: "[$CHF ]#.##0,00"
By the way, our Spreadsheet component automatically detects the format of content in cells due to the autoFormat configuration option enabled by default. However, you are free to disable it if you want.
Automatic Filling of Cells with Content
Enhanced Hotkeys Navigation
We’ve improved hotkeys behavior for easier spreadsheet navigation inside a range of cells:
- Enter – moves the selected cell down within the selected range
- Shift + Enter – moves the selected cell up within the selected range
- Tab – moves the selected cell right within the selected range
- Shift + Tab – moves the selected cell left within the selected range
So the next step is to download dhtmlxSpreadsheet 3.1 free trial version and test all the new features yourself!
We’re looking forward to your feedback about the release – share your thoughts in the comments below or write to us: firstname.lastname@example.org
Current clients are invited to download the latest version in their Client’s Area.