How create single HTML file to viewed in Excel with multiple sheets?
- by Dmitry Nelepov
I want know, is it possible create single HTML file wich (after chaging extension to xls) when opened at Excel will parsed to multiple sheets.
Little example
i got file
test.xls with contents
<html>
<body>
<table>
<tr>
<td>
1
</td>
<td>
2
</td>
<td>
3
</td>
<td>
=sum(A1:C1)
</td>
</tr>
</table>
</body>
</html>
When i open this file at Excel i got one Sheet with calculated sum of cells A1 to C1 in A4=6
I wonder, it's possible create a HTML file wich containts multiple tables wich will be parsed as multiple sheets at Excel.
Here Excel view of this file
