While I try to change header titles by passing array of titles to options like below it does not override the headers. Instead it writes new headers first and original data with old headers again from next cell.

I am experiencing the same problem.

In addition, sheets js is mutating the header array passed in, which is not something I would ever expect.

Example:

const head

This would be a nice little feature to have, Excel users are using this a lot.

一般情况，单元格JSON数据：
{
"ct": { //单元格值格式
"fa": "General", //格式名称为自动格式
"t": "n" //格式类型为数字类型
},
"v": 233, //内容的原始值为 233
"m": 233
}
里面的内容是保存在v里面的

而多行文本的内容却保存在ct里面的s里面的v里面，JSON结构如下
{
"ct": { //单元格值格式
"fa": "General", //格式名称为自动格式
"t": "inlineStr" ,
"s":[{"v":"多行文本\n多行文本"}]
}
}

这两种单元格的JSON结构都不一致呢，导致websocket后端保存数据 update