[Feature request] Provide options for data validation drop list

[gltjk]

Description

I am trying to replicate the official dependent drop list example with excelize-wasm but I can't provide items for the drop list.

In the type definition of DataValidation it can be seen that there's no place for list options -- none of the types are arrays.

According to the documentation, the correct way of providing options in Go is .SetSqrefDropList method but I cannot find its counterpart in JavaScript.

Is it not implemented yet or have I missed something?

Steps to reproduce the issue:

1. N/A

Describe the results you received: There is no way to provide drop list options.

Describe the results you expected: There is a way to provide drop list options.

Output of node -v: v20.1.0

Output of npm -v: 9.6.4

Output of go version: go version go1.20.4 darwin/amd64

Excelize version or commit ID: [email protected]

Environment details (OS, Microsoft Excel™ version, Browser version, physical, etc.):

OS: macOS 13.3.1 (22E261)
Excel version: 16.73 (23050701)

[xuri]

Thanks for your issue. This package doesn't support this currently. I'll add this feature later.

[Jangts]

I engaged the same problem. I set kinds of values to the property Formula1 while the type was list, but none of them worked.