XML is case sensitive
XML is case sen...
Anyway, I knew that . Well formed XML is case sensitive. I'm sending data to Excel, so what's wrong with my code:
<Workbook>
<Worksheet>
<table>
<Row>
<Cell>
</Cell>
</Row>
</table>
</Worksheet>
</Workbook>
All of the XML editors say it's perfectly fine XML but Excel doesn't like it. It seems to open the file but nothing displays. Remember, XML is case sensitive! Excel's XML tags are also case sensitive:
<Workbook>
<Worksheet>
<Table>
<Row>
<Cell>
</Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
Thus, to open XML in Excel, the tags must be spelled exactly as above.
<table>
with a lower case t won't do!!
No comments:
Post a Comment