how to use normal mode and stream writer mode together?

[adhil-tinvio]

i am currently using streamwriter mode to generate reports using excelize.
for some particular section i want to use SetCellRichText to enhance the styling of the data in the cell.

in the same sheet i am not able to use both of them together.
i even tried to add the new cell after flushing stream writer.still its the same.however i am able to add it in a new independent sheet
please let me know if this is solvable.Thanks

[mengpromax]

@adhil-tinvio it can't be used like this, because when you flushed the stream writer, the data content is the xl/Sheet.xml had been done, so you can't modify this content anymore.
So you should use the SetCellRichText by stream writer to write the data.

[xuri]

As the documentation says: "the normal mode functions and stream mode functions can not be work mixed to writing data on the worksheets". But the stream writer support set cell rich text. Please reference example about set cell rich text with SetRow function in the documentation.