Detect text styles...

[emailceloftis]

Is there a way to detect the styles (CSS type like font-color, font-
weight, color, text-decoration, etc.) applied to the text (not the
cell itself) in an excel cell?

I was hoping to be able to extract a string with embedded/nested span
elements with styles applied to describe the text in a cell... I know
this is probably a pipe dream but there must be a way to extract this
info... can anyone help?

BTW, I will be using VB.NET to automate excel to perform this
function... suggestions?

 

[Jacob Skaria]

Is this the one you are looking for

cells.Font.Name
cells.Font.ColorIndex (OR .Color)
Cells.Font.Size

If this post helps click Yes

 

[emailceloftis]

Is this the one you are looking for

cells.Font.Name
cells.Font.ColorIndex (OR .Color)
Cells.Font.Size

If this post helps click Yes

jacob,
i'm not just isolating my style search to those attributes but instead
ANY styles that can be applied to the text (underline, bold, italic,
size, color, etc.). The text could have any number and combination of
styles, so I don't want to 1sey 2sey the text in the cell b/c I'd have
to end up checking each character for all its styles which seems awful
ineficient...

I was thinking I could save the spreadsheet as an XML file then mine
the styles of the text <Worksheet><Table><Row><Cell><Data> tags
there... but that seems like overkill... any other ideas or tweaks on
this idea?

 

[Jacob Skaria]

I understand you want this formattig info to be used in a report which is to
be generated from a .NET application. Another way of doing this is to format
an excel file in the way you need in MS Excel itself and save this workbook
as a template. (you can even rename this..and add to your installation kit).
What the program would do is copy this template and populate data and save as
the final report....

If this post helps click Yes

 

[emailceloftis]

I understand you want this formattig info to be used in a report which isto
be generated from a .NET application. Another way of doing this is to format
an excel file in the way you need in MS Excel itself and save this workbook
as a template. (you can even rename this..and add to your installation kit).
What the program would do is copy this template and populate data and save as
the final report....

If this post helps click Yes

Thanks for the suggestion Jacob but this is not for a report - I'm
actually targeting a database with the info but need to preserve the
excel text formatting using the styles of a span, or nested span, tags
in the string that is stored in the db...