Hi All,

I am not able to figure out how to capture the formatting styles from an excel spreadsheet in my .net application.

To explain it, if I have an excel cell in which the text is "This is text", when I read this cell from .net application i should get the formatting options meaning font style, font color, etc., for that cell. I have gone through the Office Interop, but with that I found out that it gets only the property for the entire cell, but not the part of the cell. And the other option I found out is converting xlsx into office open xml, but I am not able to figure out how to parse those xml files.

Can any one please hetp me out in this issue.

Thanks All.

There is an alternative - export the sheet containing the cell as HTML and look at the HTML.

thank you for the reply, but I am trying to follow the new open office xml format,

so i wanted to read the xml files the excel file creates in open office xml formats and prase through those files.

thanks for your reply.