Features request

[SebZar]

Hi,
I'm missing some features.

• Write RichText to cells
• Add conditional formattings to cells
• Some more overloads for convenience like to make the switch to library more easy:
  Cell.Range(startColumn, startRow, endColumn, endRow)).
  Workbooks.Add("name") which return a new workbook

Perhaps you can put them on the roadmap.

Thanks

[rabanti-github]

Hi
Thanks for the request.

RichText (inline formatting) is on top of the (not yet written down :-) roadmap.
Conditional formatting is also planned but will be probably a bigger task.
Also on the list is a formula builder.
The convenience functions sounds good. Let me know if you have more of them. It may be that some functions may be already implemented in the dev brach. You will find some changes in that branch, and even more in the dev branch of NanoXLSX.

As info:
Future versions of PicoXLSX will be most likely a facade of NanoXLSX, since maintenance of the two separate (four, if the Java versions are taken into account) libraries grew up to nightmare level, and the monolithic aspect of PicoXLSX is nowadays not that important as back in 2013, when I startet the project.

[DixonDacya]

As a suggestion for overloads, it would be nice to have Worksheets.Exists(string WorksheetName) as shortcut for Wb.Worksheets.Exists(ws => ws.SheetName == WorksheetName)

[rabanti-github]

• RichText formatting (in-line cell styling) was implemented with PicoXLSX v4.0.0 (NanoXLSX v3.0.0)
• Conditional formatting is still pending
• The Range struct has now more constructor options
• Workbook.Add(...) is currently still void, but I think returning the created worksheet should be no breaker (maybe in the next release) --> Will add this to the Backlog