Do you know where your variables are? | |
PerlMonks |
Re^2: Read Excel cell comments?by pKai (Priest) |
on Apr 02, 2007 at 21:38 UTC ( [id://607928]=note: print w/replies, xml ) | Need Help?? |
While being bound to Excel Excel will drop <Cell> tags if no "significant" data or format information has to be saved there. Instead the next cell in the output will get an attribute to indicate its column position in the worksheet instead. Suppose you have a row which looks similar to
Then your XMLSS output might look somewhat like:
which makes it harder than necessary for my taste to navigate to the cells in search for.
Update: *) I now think XML-Spreadsheet (XMLSS) export was introduced with Excel 10 ->MSDN
In Section
Seekers of Perl Wisdom
|
|