type of string cell written by stream writer cannot be shared string

[eaglexiang]

Description

We find the default Type of string cell is str which means formula string. Is there any reason let excelize handle it like this? How can I set it as s( meaning shared string) with stream writer?

excelize/cell.go

Line 445 in 14c6a19

func setCellStr(value string) (t string, v string, ns xml.Attr) {

t, v = "str", bstrMarshal(value)

Steps to reproduce the issue:
1.
2.
3.

Describe the results you received:

Describe the results you expected:

Output of go version:

(paste your output here)

Excelize version or commit ID:

(paste here)

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

[xuri]

Thanks for your issue. Stream writer writes string cell as str type instead of storing the cell value in SST (shared strings table), this avoids operation SST for reduced memory usage and time cost. Yes, this doesn't follow the specification. If you depend on this type or have any other problems, I would consider changing it to the inlineStr. But anyway, the normal mode function will store the value in SST, and the cell type in this mode is s.

[eaglexiang]

In our scene, mem cost of normal mode is unacceptable, and str is also unacceptable. Could you support s or inlineStr in stream write mode? Thanks!

[xuri]

I have changed the stream writer to write inline string type for string cell value. Please upgrade to the master branch code, and this change will be released in the next version.

[eaglexiang]

It works. Thank you so much! :D