do something before export sheets

Webix JS
#1

Hi,

1.It is easy to hide column or set cells to blank before export sheet with webix.toExcel(“ss1”,options);
but,I don’t know how to do this before export all the sheets when open the dialog.please have a check with this demo https://snippet.webix.com/y7lu2xfm
2.in this demo,you can see i set a cell as a button. then i want to limit user to edit it(by input or paste) how can I do that by a easy way?
By the way, the webixbutton cannot be shown in webix-pro6.3,it is ok before 6.3.
3.in this demo,you can see I hide “add sheet button” and “sheet_arrow”,i wonder if there is a easier way to do this? set {readonly : true} can hide them,but it also make cells non editable that is not what i hope.

Thanks a lot,have a good day!

#2

Hi @zzhang

  1. You can try to get the export window and change save behaviour.

Example: https://snippet.webix.com/cglh5xth

Another variant - add a custom button with dialog

Example: https://snippet.webix.com/vik872la

  1. Check this: https://snippet.webix.com/pfmixp8m

  2. You can attach “onViewInit” event and change botttom bar config.

Example: https://snippet.webix.com/w5h25dhp

#3

hi Dima_S,

Thanks for your reply,but the links about issue1 and issue2 are empty,please have a check, thanks again.

#4

hi Dima_S,
I have two sheets named ‘tab 1’ and ‘tab 2’;
before I export all sheets,I want to setRangeValue for ‘tab 2’;
ssheet.getSheetData(“Tab 2”).setRangeValue(“A10:A13”, “12”) cannot work,you can see my demo based on yours.do you have some ideas? thx a lot!
https://snippet.webix.com/yws9nk0q

#5

@zzhang

Sorry, check this samples:

https://snippet.webix.com/t3wkl0o9
https://snippet.webix.com/w32fa40g

#6

@zzhang

getSheetData allows only to get data, not modificate. To modificate sheet, you need to show it.

Example: https://snippet.webix.com/0s955w9b