ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Anyone has any idea about XF: Extended Format (E0h) record ? (https://www.excelbanter.com/excel-programming/299231-anyone-has-any-idea-about-xf-extended-format-e0h-record.html)

KongHu

Anyone has any idea about XF: Extended Format (E0h) record ?
 
Hey Gentry,

I am writing a program to extract data from excel file directly. having an
issue on the XF record.
According the document from microsoft(Office 97 document).
Every cell keep a XF index point to the XF table, you can get the format
ID from the XF table, but I am trying this method against several excel
file, I found the same format(for example 12,345.00) map to different
format ID, in my case it's 176/179, anyone has any idea about how to
get the format information of the cell ?

any input is appreciated.


Thanks,

Tim
--





All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com