Databases
StackOverflow2013
Postsdbo
POCreate Excel file as html markup
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreate Excel file as html markup
    text
    copied!<p>I have some plain text file (.xls extension) with next markup (attached below). It's opening in excel 2003 without any error. </p> <p>Now I need to know what is the name of technology, when I could create excel file through html markup?</p> <p>Becouse I need to fix this file to open correctly in Excel 2007 and earlier. (I see "file in the different format" error now).</p> <pre><code>&lt;html xmlns:o=\"urn:schemas-microsoft-com:office:office\\ xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"&gt; &lt;head&gt; &lt;meta http-equiv=Content-Type content="text/html; charset=utf-8"&gt; &lt;meta name=ProgId content=Excel.Sheet&gt; &lt;meta name=Generator content="Microsoft Excel"&gt; &lt;!--[if gte mso 9]&gt;&lt;xml&gt; &lt;x:ExcelWorkbook&gt; &lt;x:ExcelWorksheets&gt; &lt;x:ExcelWorksheet&gt; &lt;x:Name&gt;Sheet1&lt;/x:Name&gt; &lt;x:WorksheetOptions&gt; &lt;x:Selected/&gt; &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt; &lt;x:ProtectObjects&gt;False&lt;/x:ProtectObjects&gt; &lt;x:ProtectScenarios&gt;False&lt;/x:ProtectScenarios&gt; &lt;/x:WorksheetOptions&gt; &lt;/x:ExcelWorksheet&gt; &lt;/x:ExcelWorksheets&gt; &lt;x:ProtectStructure&gt;False&lt;/x:ProtectStructure&gt; &lt;x:ProtectWindows&gt;False&lt;/x:ProtectWindows&gt; &lt;/x:ExcelWorkbook&gt; &lt;/xml&gt;&lt;![endif]--&gt; &lt;style&gt; &lt;!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:" ";} .xl2 { mso-number-format:M/D/YY; border-left:.5pt solid; border-top:.5pt solid; border-right:.5pt solid; border-bottom:.5pt solid; } .xl3 { border-left:.5pt solid; border-top:.5pt solid; border-right:.5pt solid; border-bottom:.5pt solid; } --&gt; &lt;/style&gt; &lt;/head&gt; &lt;body&gt; &lt;table&gt; &lt;tr&gt; &lt;td class=xl2&gt;17.02.2010&lt;/td&gt; &lt;td class=xl3&gt;4&lt;/td&gt; &lt;td class=xl3&gt;0&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/body&gt; &lt;/html&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload