{"id":62,"date":"2007-11-11T15:08:16","date_gmt":"2007-11-11T13:08:16","guid":{"rendered":"http:\/\/www.mysticslayer.com\/?p=62"},"modified":"2009-05-08T15:09:31","modified_gmt":"2009-05-08T13:09:31","slug":"generating-excel-xmlspreadsheet-in-c-part-2","status":"publish","type":"post","link":"http:\/\/www.mysticslayer.com\/?p=62","title":{"rendered":"Generating Excel (XmlSpreadSheet) in C# Part 2."},"content":{"rendered":"

In part 1 we started to explain a couple of things in our Excel xml spreadsheet. So let\u2019s start how to explain it in code.<\/p>\n

First of all we need a StringBuilder. With a StringBuilder we can append all the data we want. Let\u2019s build a couple if simple functions. Everything is written in C#, because it\u2019s a common written language in .NET. So if you would like to write in VB.NET <\/span>you have to convert it to VB.N<\/span>et.<\/p>\n

First we start with the header of our Xml Spreadsheet:<\/p>\n

\n
    \n
  1. \n
    \/\/ We need a newline after each rule we’ve made. So this will make it in our StringBuilder.<\/span><\/div>\n<\/li>\n
  2. \n
    private<\/span> string<\/span> _Newline =<\/span> “\\n<\/span>“<\/span>;<\/div>\n<\/li>\n
  3. \n
     <\/div>\n<\/li>\n
  4. \n
    \/\/ Returns the _NewLine<\/span><\/div>\n<\/li>\n
  5. \n
    protected<\/span> string<\/span> NewLine<\/div>\n<\/li>\n
  6. \n
    {<\/span><\/div>\n<\/li>\n
  7. \n
           get<\/div>\n<\/li>\n
  8. \n
           {<\/span><\/div>\n<\/li>\n
  9. \n
                 return<\/span> _NewLine;<\/div>\n<\/li>\n
  10. \n
           }<\/span><\/div>\n<\/li>\n
  11. \n
    }<\/span><\/div>\n<\/li>\n
  12. \n
    protected<\/span> string<\/span> StartHeader<\/div>\n<\/li>\n
  13. \n
    {<\/span><\/div>\n<\/li>\n
  14. \n
           get<\/div>\n<\/li>\n
  15. \n
           {<\/span><\/div>\n<\/li>\n
  16. \n
                    StringBuilder sb =<\/span> new<\/span> StringBuilder(<\/span>)<\/span>;<\/div>\n<\/li>\n
  17. \n
     <\/div>\n<\/li>\n
  18. \n
                    sb.Append<\/span>(<\/span>“< ?xml version=\\”<\/span>1.0\\”<\/span>?>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  19. \n
                    sb.Append<\/span>(<\/span>“< ?mso-application progid=\\”<\/span>Excel.Sheet\\”<\/span>?>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  20. \n
                    sb.Append<\/span>(<\/span>“<workbook xmlns=\\”<\/span>urn:schemas-microsoft-com:office:spreadsheet\\”<\/span>“<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  21. \n
                    sb.Append<\/span>(<\/span>“xmlns:o=\\”<\/span>urn:schemas-microsoft-com:office:office\\”<\/span>“<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  22. \n
                    sb.Append<\/span>(<\/span>“xmlns:x=\\”<\/span>urn:schemas-microsoft-com:office:excel\\”<\/span>“<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  23. \n
                    sb.Append<\/span>(<\/span>“xmlns:ss=\\”<\/span>urn:schemas-microsoft-com:office:spreadsheet\\”<\/span>“<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  24. \n
                    sb.Append<\/span>(<\/span>“xmlns:html=\\”<\/span>http:\/\/www.w3.org\/TR\/REC-html40\\”<\/span>>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
  25. \n
     <\/div>\n<\/li>\n
  26. \n
                    return<\/span> sb.ToString<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
  27. \n
          }<\/span><\/div>\n<\/li>\n
  28. \n
    }<\/span><\/div>\n<\/li>\n
  29. \n
     <\/div>\n<\/li>\n
  30. \n
    <\/<\/span>workbook><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

    So we have written our first part of our spreadsheet header. Let\u2019s see what we\u2019ve got now. Ah yes. Now our DocumentProperties we can write in our stringbuilder.<\/p>\n

    \n
      \n
    1. \n
      protected<\/span> string<\/span> DocumentProperties<\/div>\n<\/li>\n
    2. \n
              {<\/span><\/div>\n<\/li>\n
    3. \n
                  get<\/div>\n<\/li>\n
    4. \n
                  {<\/span><\/div>\n<\/li>\n
    5. \n
                      StringBuilder sb =<\/span> new<\/span> StringBuilder(<\/span>)<\/span>;<\/div>\n<\/li>\n
    6. \n
       <\/div>\n<\/li>\n
    7. \n
                      sb.Append<\/span>(<\/span>“<documentproperties xmlns=\\”<\/span>urn:schemas-microsoft-com:office:office\\”<\/span>>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
    8. \n
                      sb.Append<\/span>(<\/span>“<author>Author<\/author>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
    9. \n
                      sb.Append<\/span>(<\/span>“<lastauthor>LastAuthor<\/lastauthor>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
    10. \n
                      sb.Append<\/span>(<\/span>“<created>”<\/span> +<\/span> DateTime.Now<\/span> +<\/span> “<\/created>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
    11. \n
                      sb.Append<\/span>(<\/span>“<version>12.00<\/version>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
    12. \n
                      sb.Append<\/span>(<\/span>“<\/documentproperties>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
    13. \n
       <\/div>\n<\/li>\n
    14. \n
                      return<\/span> sb.ToString<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
    15. \n
                  }<\/span><\/div>\n<\/li>\n
    16. \n
              }<\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

      So we have written now our DocumentProperties. Now we can write our ExcelWorkbook properties. There are a couple of things important. Don\u2019t forget to put ProtectStructure and ProtectWindows in your ExcelWorkbook properties. These are important things we need to use.<\/p>\n

      \n
        \n
      1. \n
         protected<\/span> string<\/span> ExcelWorkbook<\/div>\n<\/li>\n
      2. \n
                {<\/span><\/div>\n<\/li>\n
      3. \n
                    get<\/div>\n<\/li>\n
      4. \n
                    {<\/span><\/div>\n<\/li>\n
      5. \n
                        StringBuilder sb =<\/span> new<\/span> StringBuilder(<\/span>)<\/span>;<\/div>\n<\/li>\n
      6. \n
         <\/div>\n<\/li>\n
      7. \n
                        sb.Append<\/span>(<\/span>“<excelworkbook xmlns=\\”<\/span>urn:schemas-microsoft-com:office:excel\\”<\/span>>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      8. \n
                        sb.Append<\/span>(<\/span>“<windowheight>8130<\/windowheight>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      9. \n
                        sb.Append<\/span>(<\/span>“<windowwidth>18015<\/windowwidth>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      10. \n
                        sb.Append<\/span>(<\/span>“<windowtopx>360<\/windowtopx>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      11. \n
                        sb.Append<\/span>(<\/span>“<windowtopy>75<\/windowtopy>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      12. \n
                        sb.Append<\/span>(<\/span>“<calculation>ManualCalculation<\/calculation>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      13. \n
                        sb.Append<\/span>(<\/span>“<donotcalculatebeforesave \/>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      14. \n
                        sb.Append<\/span>(<\/span>“<protectstructure>False<\/protectstructure>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      15. \n
                        sb.Append<\/span>(<\/span>“<protectwindows>False<\/protectwindows>”<\/span> +<\/span> NewLine)<\/span>; <\/div>\n<\/li>\n
      16. \n
                        sb.Append<\/span>(<\/span>“<\/excelworkbook>”<\/span> +<\/span> NewLine)<\/span>;<\/div>\n<\/li>\n
      17. \n
         <\/div>\n<\/li>\n
      18. \n
                        return<\/span> sb.ToString<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
      19. \n
                    }<\/span><\/div>\n<\/li>\n
      20. \n
                }<\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

        We have done our first part of our document. Now we can see allready that we have done alot of work to write our header for our document. Let\u2019s start with our Styles. You can add styles in a couple of manners to your document. You can write an external document that we can add to our project. Or you can add this by code. Well like you write a stylesheet for your webpage, I wrote a styles.config to add to our project. <\/p>\n

        You can add this in by the following code part.<\/p>\n

        \n
          \n
        1. \n
           <\/div>\n<\/li>\n
        2. \n
          private<\/span> string<\/span> Styles(<\/span>string<\/span> filename)<\/span><\/div>\n<\/li>\n
        3. \n
            {<\/span><\/div>\n<\/li>\n
        4. \n
             System<\/span>.IO<\/span>.StreamReader<\/span> sr;<\/div>\n<\/li>\n
        5. \n
           <\/div>\n<\/li>\n
        6. \n
             string<\/span> sLine;<\/div>\n<\/li>\n
        7. \n
             string<\/span> sText =<\/span> string<\/span>.Empty<\/span>;<\/div>\n<\/li>\n
        8. \n
           <\/div>\n<\/li>\n
        9. \n
             sr =<\/span> System<\/span>.IO<\/span>.File<\/span>.OpenText<\/span>(<\/span>filename)<\/span>;<\/div>\n<\/li>\n
        10. \n
             sLine =<\/span> sr.ReadLine<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
        11. \n
           <\/div>\n<\/li>\n
        12. \n
             sText =<\/span> sLine;<\/div>\n<\/li>\n
        13. \n
           <\/div>\n<\/li>\n
        14. \n
             while<\/span>(<\/span>sLine !=<\/span> null<\/span>)<\/span><\/div>\n<\/li>\n
        15. \n
             {<\/span><\/div>\n<\/li>\n
        16. \n
              sLine =<\/span> sr.ReadLine<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
        17. \n
              sText +=<\/span> sLine +<\/span> “\\n<\/span>“<\/span>;<\/div>\n<\/li>\n
        18. \n
           <\/div>\n<\/li>\n
        19. \n
             }<\/span><\/div>\n<\/li>\n
        20. \n
           <\/div>\n<\/li>\n
        21. \n
             sr.Close<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
        22. \n
           <\/div>\n<\/li>\n
        23. \n
             return<\/span> sText;<\/div>\n<\/li>\n
        24. \n
            }<\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

          This was the part for reading our styles.config into a StreamReader and return it as string. Well we have done the most of things now. Let\u2019s start with the main part. The main part is making the ExcelWorksheet and the table with data. In Html you can write a table like this:<\/p>\n

          \n
            \n
          1. \n
            <<\/span>table><\/span><\/div>\n<\/li>\n
          2. \n
            <<\/span>tr><<\/span>td><\/<\/span>td><\/<\/span>tr><<\/span>tr><\/span><\/div>\n<\/li>\n
          3. \n
            <\/<\/span>tr><<\/span>tr><<\/span>td><\/<\/span>td><\/<\/span>tr><<\/span>tr><\/span><\/div>\n<\/li>\n
          4. \n
            <\/<\/span>tr><\/<\/span>table><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

            Well the xml spreadsheet is almost the same. Let\u2019s see how to make a simple template of it.<\/p>\n

            \n
              \n
            1. \n
              <<\/span>table><\/span><\/div>\n<\/li>\n
            2. \n
              <<\/span>row><\/span><\/div>\n<\/li>\n
            3. \n
              <<\/span>cell><<\/span>data><\/<\/span>data><\/<\/span>cell><\/span><\/div>\n<\/li>\n
            4. \n
              <<\/span>cell><<\/span>data><\/<\/span>data><\/<\/span>cell><\/span><\/div>\n<\/li>\n
            5. \n
              <\/<\/span>row><\/span><\/div>\n<\/li>\n
            6. \n
              <\/<\/span>table><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

              There are not many differences between html and xml spreadsheet. But it\u2019s important to know that you don\u2019t forget any closing tags. In particular big documents it\u2019s a problem to find the problem. Well let\u2019s start with some simple data to put it in our document.<\/p>\n

              \n
                \n
              1. \n
                 protected<\/span> string<\/span> _data<\/div>\n<\/li>\n
              2. \n
                        {<\/span><\/div>\n<\/li>\n
              3. \n
                            get<\/div>\n<\/li>\n
              4. \n
                            {<\/span><\/div>\n<\/li>\n
              5. \n
                                StringBuilder sb =<\/span> new<\/span> StringBuilder(<\/span>)<\/span>;<\/div>\n<\/li>\n
              6. \n
                 <\/div>\n<\/li>\n
              7. \n
                                sb.Append<\/span>(<\/span>“<worksheet ss:Name=\\”<\/span>Sheet1\\”<\/span>>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              8. \n
                                sb.Append<\/span>(<\/span>“<table ss:ExpandedColumnCount=\\”<\/span>12\\”<\/span> ss:ExpandedRowCount=\\”<\/span>1\\”<\/span> x:FullColumns=\\”<\/span>1\\”<\/span> x:FullRows=\\”<\/span>1\\”<\/span> ss:DefaultRowHeight=\\”<\/span>15\\”<\/span>>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              9. \n
                                sb.Append<\/span>(<\/span>“<column ss:Index=\\”<\/span>2\\”<\/span> ss:StyleID=\\”<\/span>s62\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              10. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s63\\”<\/span> ss:Width=\\”<\/span>53.25\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              11. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s65\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              12. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s66\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span> ss:Width=\\”<\/span>67.5\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              13. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s67\\”<\/span> ss:Width=\\”<\/span>54.75\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              14. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s68\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              15. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s69\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              16. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s70\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              17. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s71\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              18. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s72\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              19. \n
                                sb.Append<\/span>(<\/span>“<column ss:StyleID=\\”<\/span>s73\\”<\/span> ss:AutoFitWidth=\\”<\/span>\\”<\/span>\/>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              20. \n
                                sb.Append<\/span>(<\/span>“<row>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              21. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>String\\”<\/span>>General<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              22. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>Number\\”<\/span>>0<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              23. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>Number\\”<\/span>>12345<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              24. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>String\\”<\/span>>\u00e2\u201a\u00ac<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              25. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>DateTime\\”<\/span>>2007-03-14T00:00:00.000<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              26. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>DateTime\\”<\/span>>1899-12-31T13:30:00.000<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              27. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>Number\\”<\/span>>1<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              28. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>Number\\”<\/span>>0.33333333333333331<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              29. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>Number\\”<\/span>>0.33333333333333331<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              30. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>String\\”<\/span>>text<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              31. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>String\\”<\/span>>Breda<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              32. \n
                                sb.Append<\/span>(<\/span>“<cell><data ss:Type=\\”<\/span>Number\\”<\/span>>12345<\/data><\/cell>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              33. \n
                                sb.Append<\/span>(<\/span>“<\/row>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              34. \n
                                sb.Append<\/span>(<\/span>“<\/table>”<\/span>)<\/span>;<\/div>\n<\/li>\n
              35. \n
                 <\/div>\n<\/li>\n
              36. \n
                                return<\/span> sb.ToString<\/span>(<\/span>)<\/span>;<\/div>\n<\/li>\n
              37. \n
                            }<\/span><\/div>\n<\/li>\n
              38. \n
                        }<\/span><\/div>\n<\/li>\n
              39. \n
                <\/<\/span>worksheet><\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n

                On part 3 we\u2019re going further. Cause the fact is that WordPress doesn\u2019t allow me to write alot of text in one article\u2026 <\/p>\n","protected":false},"excerpt":{"rendered":"

                In part 1 we started to explain a couple of things in our Excel xml spreadsheet. So let\u2019s start how to explain it in code. First of all we need a StringBuilder. With a StringBuilder we can append all the data we want. Let\u2019s build a couple if simple functions. Everything is written in C#, […]<\/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,114,116,111,117],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-programming","tag-net","tag-c","tag-excel","tag-excel-stylesheet","tag-xml","tag-xml-stylesheet"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pe1EH-10","_links":{"self":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/62","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=62"}],"version-history":[{"count":1,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":63,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions\/63"}],"wp:attachment":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}