check data format

[lsong]

Hi,
is there a function to call to check if the Data Format received from the template file is of type "Number" or "Date"?

something like _myWorkSheet.Rows[rowNumber].Cells[j].Style.hasNumberFormat

Thanks

[Betsy.jiang]

Dear lsong,

Thanks for your inquiry.
At present, here is a method which can return the format code, and then you can determine the type via the format code.

Code: Select all

String format = sheet.Rows[1].Cells[1].NumberFormat;

If there is any question, please let me know.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear lsong,

How is your issue now ?
Could you please give us some feedback at your convenience ?

Thanks,
Betsy
E-iceblue support team