NanoXLSX
NanoXLSX copied to clipboard
rabanti-github
Is it possible to add Data Validations?
Is it possible to add data validations to a column in the resulting spreadsheet? The excel file I am generating will also be used as an import file for easy of updating large amounts of changes and adding new records. As such, I am wondering if it is possible to implement the Excels data validation functionality? When added to the spreadsheet, via Excel, entries are added to the sheet itself, but I am unable to see any methods on the worksheet, in NanoXLSX, that would allow me to add such functionality to the spreadsheet I am creating. If this functionality does exist, could someone please point me int the right direction.
Hi, Currently, data validation is not implemented. But I think I will place it on the backlog quite high, after inline formatting and conditional formatting. The implementation looks not very hard. It is quite straight forward
Look forward to implementing it in our application when you release it.
By the way, is there any way to make donations for your efforts. We first tried using OpenXML in our application and our implementation became more robust than we were wanting to maintain going forward. That is when we came across your library and were able to implement, in just over a day, what took us almost a week to implement with OpenXML and our code will definitely be easier to maintain going forward.
Thank you, that is very nice of you, and I am extremely happy that the library is useful to you and your organization. It was my intention to provide a way to generate XLSX flies without high requirements. I hope I can start to implement the new backlog features soon.
If you want to support me: https://www.paypal.com/donate/?business=2RR2UEVYGYT6G&no_recurring=0&item_name=I+am+super+happy+that+you+like+my+free%2C+open+source+software%21+If+you+want+to+support+my+work%2C+any+donation+is+appreciated.¤cy_code=CHF
However, this is really not a demand or "subscription plan". I am happy to help people out whit the library, as I was happy to get my problems solved with it, back in the days when I created it. This is my little part of altruism in this world :-)
Please let me know, if you have specific business requirements, since, as the maintainer of the library, I may be already blind to some crucial needs.
Just curious, any updates as to when this feature may be available?
Hi, Sorry about the slowdown in the progress. I have rewritten a lot on the dev-v3 branch until December 4th. Then I had to deal with some other things and took also a short break from coding in my spare time. However, I think I continue the work in February. Data validation will either come directly after conditional formatting or inline formatting (1st priority): https://github.com/rabanti-github/NanoXLSX/wiki/Backlog A time estimation is difficult. I have not analyzed the new features yet and also want to apply tests on every function, the current rework needs a lot of test-adaptions and, as always, will testing consume far more time than actually planned.
Fully understood, life has a way of geting in the way. I just thought I would check in and see how things are going. By the way, Happy New Year.