Malcolm If you don't necessarily need to display this info in Excel itself, but would be happy to display it in VFP, you could use OLE automation. Depending on the number of columns in the worksheet, you could create a table/cursor in VFP and populate it with the format codes from the worksheet cells
That approach might be more straightforward than saving to XML and parsing out ? Just a thought. HTH Paul Newton PS Another thought - you could go a step further and create another worksheet containing the format codes of the "source" worksheet ? Malcolm Greene wrote: > Excel gurus: Is there a way to have Excel display all the formatting > codes used in each cell in the same way that Excel displays cell > formulas (vs. cell data)? > > In other words, Ctrl+~ toggles between Excel data and Excel formulas. > > I'm looking for a similar way to toggle between Excel formatting codes > and data so I can get a big picture view of how a spreadsheet is > formatted (vs. having to manually visit each cell and use Ctrl+1 to view > its format) > > Any suggestions (other than saving to XML format and parsing out > styleids/codes and mapping back to cell coordinates?) > > Thanks! > Malcolm > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
