spreadsheet

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.

描述错误

重现

1. 第一步操作:本地 npm run dev,打开demo
2. 第二步操作: 点开数据透视表tab页
3. 第三步操作:报错
4. 最后看到了什么错误:

期望的结果

![image](https://user-imag

Is your feature request related to a problem? Please describe.
NamedRanges are not tight to a particular sheet object, one could create a function that returns a list of Cell objects
obtained from only a given namedRange access via an instance of SpreadSheet without having to first get any WorkSheet.

Describe the solution you'd like
Create a new function (likely named `namedRan