How to get FormatType field of a column

[lsong]

Hi,
I see under each column there is a field called "FormatType". I really need to get that for my application to determine the column type format. If it's a Text, number or datetime type of column. How do I get this information?

Thanks

[Betsy.jiang]

Dear lsong,

Thanks for your inquiry.
You can use NumberFormat to get the format code.

Code: Select all

string format = sheet.Columns[0].NumberFormat;

If there is any question, please let me know.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear lsong,

Did you test the code I provided ? Has your issue been resolved ?

Sincerely,
Betsy
E-iceblue support team