search

MortalreminderPT / edit-xlsx

A quick and easy-to-use Rust library for Excel file editing.
https://crates.io/crates/edit-xlsx
25 stars 4 forks source link

Support for read/write date cells #17

Open erosinnocenti opened 6 months ago

erosinnocenti commented 6 months ago

Hi, thanks for this library. Although there are many crates which can write or read Excel, none of them have read-write support, so nice job!

I'm using your code for a small project, and at the moment I miss the ability to read / write Date formatted cells. It would be nice to also have the possibility to specify the format mask (e.g., yyyy-mm-dd for dates or #,##0.00 for numbers).

Do you think adding this would be a lot of work? Thanks

MortalreminderPT commented 6 months ago

Constructive suggestions, I'll think carefully about this feature afterward. But I'm busy with other work right now.😔

mschnell1 commented 6 months ago

OOOuuuff I thought date would be handled like numbers and provide a String. But unfortunately it just provides a number as a string. :(

Thanks for pointing this out !

mschnell1 commented 6 months ago

Also other number formatting options seem to be ignored. E,g. Percent and count of decimals.

As we get a string, in a perfect world, we should expect to get it formatted in the same way excel displays it.