|
|
Posted by Captain Paralytic on 02/02/07 14:27
On 2 Feb, 13:39, "Sonnich" <sonnich.jen...@elektrobit.com> wrote:
> Hi all!
>
> We discussed it lately, how to create xls files.
>
> I use(d) a way to save in html format, which excel can open nicely.
> However, now I need 2 sheets, and I am stuck on that.
>
> Any ideas?
>
> I have
>
> <html><head><STYLE TYPE="text/css"> <!-- .number2dec {mso-number-
> format: Fixed;}
> .number0dec {mso-number-format: 0\;} -->
> </STYLE></head>
> <table border=1 name="sheet1">
> <tr><td>2006/01</td><td class="number2dec">66.666666666667</td><td
> class="number2dec">25.666666666667</td></tr>
> </table>
> <table border=1 name="sheet2">
> <tr><td>abc</td></tr>
> </table>
> </html>
>
> but that merges them into one sheet.... there probably is a way
>
> S
I would tend to save in XML format which Excel can also read well.
Whether saving in XML or HTML, try saving from Excel in the prescribed
format and copy what it does. However for multi-sheet books, if you
want only one file, you will need to use either a web archive (.mht)
or an xml file.
[Back to original message]
|