{"id":58,"date":"2007-11-09T15:04:12","date_gmt":"2007-11-09T13:04:12","guid":{"rendered":"http:\/\/www.mysticslayer.com\/?p=58"},"modified":"2009-07-04T01:45:13","modified_gmt":"2009-07-03T23:45:13","slug":"generating-excel-xmlspreadsheet-in-c-part-1","status":"publish","type":"post","link":"http:\/\/www.mysticslayer.com\/?p=58","title":{"rendered":"Generating Excel (XmlSpreadSheet) in C# Part 1."},"content":{"rendered":"<p>If you want to export data with <span class=\"caps\">VB.NET <\/span>of C# you can do it with the Office <span class=\"caps\">API\u2019<\/span>s delivered with your Office <span class=\"caps\">API\u2019<\/span>s, but I wasn\u2019t to happy with the Excel Object. After doing some research on the internet I discovered alot of ways to write your own manner to Generate an Excel document with the XmlSpreadsheet. Well after doing some tryouts with Excel I discovered that Excel has alot of options how to save your data.<\/p>\n<ul>\n<li>Excel Workbook (*.xlsx) Office 2007 Format<\/li>\n<li>Excel Macro-Enabled Workbook (*.xlsm) Office 2007 Format<\/li>\n<li>Excel Binary Workbook (*.xlsb) Office 2007 Format<\/li>\n<li>Excel 97-2003 Workbook (*.xls)<\/li>\n<li><span class=\"caps\">XML<\/span> Data (*.xml)<\/li>\n<li>Single File Web Page (*.mht; *.mhtml)<\/li>\n<li>Web Page (*.htm; *.html)<\/li>\n<li>Excel Template (*.xltx) Office 2007 Format<\/li>\n<li>Excel Macro-Enabled Template (*.xltm) Office 2007 Format<\/li>\n<li>Excel 97-2003 Template (*.xlt)<\/li>\n<li>Text (Tab Delimited) (*.txt)<\/li>\n<li>Unicode Text (*.txt)<\/li>\n<li><strong><span class=\"caps\">XML<\/span> Spreadsheet (*.xml)<\/strong><\/li>\n<li>Microsoft Excel 5.0\/95 Workbook (*.xls)<\/li>\n<li><span class=\"caps\">CSV <\/span>(Comma Delimited) (*.csv)<\/li>\n<li>Formatted Text (Space Delimited) (*.prn)<\/li>\n<li>Text (Macintosh) (*.txt)<\/li>\n<li>Text (MS-DOS) (*.txt)<\/li>\n<li><span class=\"caps\">CSV <\/span>(Macintosh) (*.csv)<\/li>\n<li><span class=\"caps\">CSV <\/span>(MS-DOS) (*.csv)<\/li>\n<li><span class=\"caps\">DIF <\/span>(Data Interchange Format) (*.dif)<\/li>\n<li><span class=\"caps\">SYLK <\/span>(Symbolic Link) (*.slk)<\/li>\n<li>Excel Add-In (*.xlam) Office 2007 Format<\/li>\n<li>Excel 97-2003 Add-In (*.xla)<\/li>\n<\/ul>\n<p>You\u2019ll see that the <span class=\"caps\">XML<\/span> Spreadsheet normally would be saved in the Extension of *.xml, however you can save this also as *.xls. Why is that? You would ask? Well Excel has alot of manners how to open or save data. If you would have a <span class=\"caps\">CSV <\/span>file delimited in Comma\u2019s or Tab delimited files you can also open this with Excel. And you can see that the data is perfectly rendered in the Spreadsheet.<\/p>\n<p>Let\u2019s see where a <span class=\"caps\">XML<\/span> SpreadSheet starts with:<\/p>\n<div class=\"geshi no xml\">\n<ol>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;<\/span> ?xml <span class=\"re0\">version<\/span>=<span class=\"st0\">&#8220;1.0&#8221;<\/span><span class=\"re2\">?&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;<\/span> ?mso-application <span class=\"re0\">progid<\/span>=<span class=\"st0\">&#8220;Excel.Sheet&#8221;<\/span><span class=\"re2\">?&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;workbook<\/span> <span class=\"re0\">xmlns<\/span>=<span class=\"st0\">&#8220;urn:schemas-microsoft-com:office:spreadsheet&#8221;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"re0\">xmlns:o<\/span>=<span class=\"st0\">&#8220;urn:schemas-microsoft-com:office:office&#8221;<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"re0\">xmlns:x<\/span>=<span class=\"st0\">&#8220;urn:schemas-microsoft-com:office:excel&#8221;<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"re0\">xmlns:ss<\/span>=<span class=\"st0\">&#8220;urn:schemas-microsoft-com:office:spreadsheet&#8221;<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"re0\">xmlns:html<\/span>=<span class=\"st0\">&#8220;http:\/\/www.w3.org\/TR\/REC-html40&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;documentproperties<\/span> <span class=\"re0\">xmlns<\/span>=<span class=\"st0\">&#8220;urn:schemas-microsoft-com:office:office&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;author<span class=\"re2\">&gt;<\/span><\/span><\/span>Author<span class=\"sc3\"><span class=\"re1\">&lt;\/author<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;lastauthor<span class=\"re2\">&gt;<\/span><\/span><\/span>LastAuthor<span class=\"sc3\"><span class=\"re1\">&lt;\/lastauthor<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;created<span class=\"re2\">&gt;<\/span><\/span><\/span>11-09-2007<span class=\"sc3\"><span class=\"re1\">&lt;\/created<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;version<span class=\"re2\">&gt;<\/span><\/span><\/span>12.00<span class=\"sc3\"><span class=\"re1\">&lt;\/version<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/documentproperties<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;excelworkbook<\/span> <span class=\"re0\">xmlns<\/span>=<span class=\"st0\">&#8220;urn:schemas-microsoft-com:office:excel&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;protectstructure<span class=\"re2\">&gt;<\/span><\/span><\/span>False<span class=\"sc3\"><span class=\"re1\">&lt;\/protectstructure<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;protectwindows<span class=\"re2\">&gt;<\/span><\/span><\/span>False<span class=\"sc3\"><span class=\"re1\">&lt;\/protectwindows<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/excelworkbook<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/workbook<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n<p>After this section you will include you styles. When writing your styles you can build a Excel Workbook manually and make some different styles init. After that you can save this Workbook to a <span class=\"caps\">XML<\/span> Spreadsheet. When you finally saved a Workbook it will generate for example the following styles:<\/p>\n<div class=\"geshi no xml\">\n<ol>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;styles<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;Default&#8221;<\/span> <span class=\"re0\">ss:Name<\/span>=<span class=\"st0\">&#8220;Normal&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;alignment<\/span> <span class=\"re0\">ss:Vertical<\/span>=<span class=\"st0\">&#8220;Bottom&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;borders<\/span> <span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;font<\/span> <span class=\"re0\">ss:FontName<\/span>=<span class=\"st0\">&#8220;Calibri&#8221;<\/span> <span class=\"re0\">x:Family<\/span>=<span class=\"st0\">&#8220;Swiss&#8221;<\/span> <span class=\"re0\">ss:Size<\/span>=<span class=\"st0\">&#8220;11&#8221;<\/span> <span class=\"re0\">ss:Color<\/span>=<span class=\"st0\">&#8220;#000000&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;interior<\/span> <span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;protection<\/span> <span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s62&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;Fixed&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s63&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;&amp;quot;\u00e2\u201a\u00ac&amp;quot;#,##0.00&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s65&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;0%&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s66&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;Short Date&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s67&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;[$-F400]h:mm:ss\\ AM\/PM&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s68&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;Percent&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s69&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;#\\ ?\/?&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s70&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;Scientific&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s71&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;@&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s72&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;00.00.00.000&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;style<\/span> <span class=\"re0\">ss:ID<\/span>=<span class=\"st0\">&#8220;s73&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;numberformat<\/span> <span class=\"re0\">ss:Format<\/span>=<span class=\"st0\">&#8220;Standard&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/style<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/styles<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n<p>What you can do is giving alot of extra options to your excel sheet. Every above style has a particular function. You can specify a column and give it a specific style. So that the column will be formatted by for example Scientific functions. After the styles there will be the data for your spreadsheet.<\/p>\n<p>First we start with a new Worksheet. Every worksheet has a name . Let\u2019s start with that:<\/p>\n<div class=\"geshi no xml\">\n<ol>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;worksheet<\/span> <span class=\"re0\">ss:Name<\/span>=<span class=\"st0\">&#8220;ExampleSheet&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\"><\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/worksheet<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n<p>When we have done that we can add our table with data in our Worksheet. It will look like this.<\/p>\n<div class=\"geshi no xml\">\n<ol>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;worksheet<\/span> <span class=\"re0\">ss:Name<\/span>=<span class=\"st0\">&#8220;ExampleSheet&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;table<\/span> <span class=\"re0\">ss:ExpandedColumnCount<\/span>=<span class=\"st0\">&#8220;12&#8221;<\/span> <span class=\"re0\">ss:ExpandedRowCount<\/span>=<span class=\"st0\">&#8220;1&#8221;<\/span> <span class=\"re0\">x:FullColumns<\/span>=<span class=\"st0\">&#8220;1&#8221;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"re0\">x:FullRows<\/span>=<span class=\"st0\">&#8220;1&#8221;<\/span> <span class=\"re0\">ss:DefaultRowHeight<\/span>=<span class=\"st0\">&#8220;15&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:Index<\/span>=<span class=\"st0\">&#8220;2&#8221;<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s62&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s63&#8221;<\/span> <span class=\"re0\">ss:Width<\/span>=<span class=\"st0\">&#8220;53.25&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s65&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s66&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span> <span class=\"re0\">ss:Width<\/span>=<span class=\"st0\">&#8220;67.5&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s67&#8221;<\/span> <span class=\"re0\">ss:Width<\/span>=<span class=\"st0\">&#8220;54.75&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s68&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s69&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s70&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s71&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s72&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;column<\/span> <span class=\"re0\">ss:StyleID<\/span>=<span class=\"st0\">&#8220;s73&#8221;<\/span> <span class=\"re0\">ss:AutoFitWidth<\/span>=<span class=\"st0\">&#8220;0&#8221;<\/span><span class=\"re2\">\/&gt;<\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;row<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;String&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>General<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;Number&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;Number&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>12345<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;String&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>\u00e2\u201a\u00ac<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;DateTime&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>2007-03-14T00:00:00.000<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;DateTime&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>1899-12-31T13:30:00.000<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;Number&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>1<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;Number&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>0.33333333333333331<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;Number&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>0.33333333333333331<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;String&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>text<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;String&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>Breda<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;cell<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;data<\/span> <span class=\"re0\">ss:Type<\/span>=<span class=\"st0\">&#8220;Number&#8221;<\/span><span class=\"re2\">&gt;<\/span><\/span>12345<span class=\"sc3\"><span class=\"re1\">&lt;\/data<span class=\"re2\">&gt;<\/span><\/span><\/span><span class=\"sc3\"><span class=\"re1\">&lt;\/cell<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/row<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/table<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"sc3\"><span class=\"re1\">&lt;\/worksheet<span class=\"re2\">&gt;<\/span><\/span><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>If you want to export data with VB.NET of C# you can do it with the Office API\u2019s delivered with your Office API\u2019s, but I wasn\u2019t to happy with the Excel Object. After doing some research on the internet I discovered alot of ways to write your own manner to Generate an Excel document with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[101],"tags":[113,110,105,114,188,116,115,111,112],"class_list":["post-58","post","type-post","status-publish","format-standard","hentry","category-programming","tag-net","tag-c","tag-csharp","tag-excel","tag-excel-spreadsheet","tag-excel-stylesheet","tag-office","tag-xml","tag-xml-spreadsheet"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pe1EH-W","_links":{"self":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=58"}],"version-history":[{"count":4,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":98,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions\/98"}],"wp:attachment":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}