sheetjs
sheetjs copied to clipboard
Identify the Format type using the format String
Is it possible to identify the type of format using the format string ? For examples, i would like to have a function like:
SSF.getFormat("m-d-yy h:mm;@") should return "Date"
Similarly, SSF.getFormat("(* #,##0.00);(* (#,##0.00);(* "-"??);(@_)") should return "Accounting"
This is in context with what is displayed in the Ribbon Format Dropdown.
Please let me know, if there is any existing function to support this or is it in your road map for future enhancements.
SSF.is_date(fmt)
will test if a format is a date.