PicoXLSX icon indicating copy to clipboard operation
PicoXLSX copied to clipboard

Features request

Open SebZar opened this issue 3 years ago • 2 comments

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

SebZar avatar Aug 18 '22 08:08 SebZar

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.

rabanti-github avatar Aug 18 '22 11:08 rabanti-github

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)

DixonDacya avatar Oct 02 '22 11:10 DixonDacya