﻿{"id":157,"date":"2010-05-25T11:32:47","date_gmt":"2010-05-25T03:32:47","guid":{"rendered":"http:\/\/nick.workao.org\/?p=157"},"modified":"2010-05-25T11:32:57","modified_gmt":"2010-05-25T03:32:57","slug":"c%e7%94%a8-excel-%e4%bd%9c%e4%b8%ba%e6%a8%a1%e6%9d%bf%e6%89%93%e5%8d%b0%e7%9a%84%e6%ba%90%e7%a0%81","status":"publish","type":"post","link":"http:\/\/nick.txtcc.com\/index.php\/win\/157","title":{"rendered":"C#\u7528 excel \u4f5c\u4e3a\u6a21\u677f\u6253\u5370\u7684\u6e90\u7801"},"content":{"rendered":"<p>\u6e90\u7801<\/p>\n<p>\/*\n&#8216;\u00a0\u00a0\u00a0\/\/-<strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><em>-\/\/\n&#8216;\u00a0\u00a0\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5982\u679c\u60a8\u8981\u732e\u4e00\u4efd\u7231\u5fc3\uff0c\u8bf7\u53c2\u9884\u5e0c\u671b\u5de5\u7a0b\uff01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\n&#8216; \/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5982\u679c\u60a8\u8fd8\u652f\u6301\u4f5c\u8005\uff0c\u8bf7\u8054\u7cfb\u4f5c\u8005\uff01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\n&#8216;\/\/-<\/em><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong>-\/\/\n&#8216;\n&#8216;\u00a0\u00a0\u00a0\u00a0\/\/\/ \u4f5c \u8005\uff1a\u957f\u6c5f\u652f\u6d41(\u5468\u65b9\u52c7)\n&#8216;\u00a0\u00a0\u00a0\u00a0\/\/\/ Email\uff1aMisGoldPrinter@163.com\u00a0\u00a0QQ\uff1a150439795\n&#8216;\u00a0\u00a0\u00a0\u00a0\/\/\/ \u7f51 \u5740\uff1awww.webmis.com.cn\n&#8216;\u00a0\u00a0\u00a0\u00a0\/\/\/ \u2605\u2605\u2605\u2605\u2605\u60a8\u53ef\u4ee5\u514d\u8d39\u4f7f\u7528\u6b64\u7a0b\u5e8f\uff0c\u4f46\u662f\u8bf7\u60a8\u5b8c\u6574\u4fdd\u7559\u6b64\u8bf4\u660e\uff0c\u4ee5\u7ef4\u62a4\u77e5\u8bc6\u4ea7\u6743\u2605\u2605\u2605\u2605\u2605\n&#8216;\n*\/<\/p>\n<p>\/\/\u6253\u5370\u64cd\u4f5c\uff0c\u5957\u6253\u3001\u6253\u5370\u3001\u9884\u89c8\nenum PrintFlag\n{\n\/\/\/ <summary>\n\/\/\/ \u5957\u6253\uff0c\u53ea\u6253\u5370\u6ca1\u6709\u5370\u5237\u7684\u90e8\u5206\n\/\/\/ <\/summary>\nCasePrint,\n\/\/\/ <summary>\n\/\/\/ \u6253\u5370\u5168\u90e8\n\/\/\/ <\/summary>\nPrintAll,\n\/\/\/ <summary>\n\/\/\/ \u9884\u89c8\u5168\u90e8\n\/\/\/ <\/summary>\nPreviewAll\n}<\/p>\n<p>\/\/\u5957\u6253\u3001\u6253\u5370\u3001\u9884\u89c8\u4e09\u4e2a\u6309\u94ae\u5173\u8054\u4e9b\u59d4\u6258\u5b9e\u4f8b\nprivate void Print_Click(object sender, System.EventArgs e)\n{\nButton btn = (Button)sender;\nswitch(btn.Tag.ToString())\n{\ncase &#8220;\u5957\u6253&#8221;:\nPrint(PrintFlag.CasePrint);\nbreak;\ncase &#8220;\u6253\u5370&#8221;:\nPrint(PrintFlag.PrintAll);\nbreak;\ncase &#8220;\u9884\u89c8&#8221;:\nPrint(PrintFlag.PreviewAll);\nbreak;\n}\n}<\/p>\n<p>private void Print(PrintFlag p_printFlag)\n{<\/p>\n<p>\/\/\u5236\u4f5c\u6b65\u9aa4\uff1a\n\/<em>\u00a0\u00a0\u00a0\u00a01\u3001\u7528Excel\u4f5c\u51fa\u4e0e\u8981\u6253\u5370\u7684\u6837\u5f0f\u4e00\u6837\u7684\u7535\u5b50\u8868\u683c\u5b58\u4e3a\u6a21\u677f\uff1b\n<\/em>\u00a0\u00a0\u00a0\u00a0\u00a0\u6280\u5de7\uff1a\u6700\u597d\u628a\u7b2c\u4e00\u884c\u4e0e\u7b2c\u4e00\u5217\u4f5c\u4e3a\u7a7a\u884c\uff0c\u4ee5\u5229\u4e8e\u8c03\u6574\u8fb9\u8ddd\uff08\u867d\u7136Excel\u3001\u6253\u5370\u673a\u53ef\u8c03\u6574\u9875\u8fb9\u8ddd\uff09\uff0c  \u5c3d\u91cf\u7684\u5728\u9700\u8981\u8c03\u6574\u7684\u5730\u65b9\u591a\u7a7a\u51e0\u884c\u4e0e\u51e0\u5217\uff0c\u4ee5\u5229\u4e8e\u8c03\u6574\u5957\u6253\u5bf9\u51c6\n<em>\n<\/em>\u00a0\u00a02\u3001\u5982\u540c\u672c\u7a0b\u5e8f\u4e00\u6837\uff0c\u5c06Excel\u4f5c\u4e3a\u5957\u6253\u7684\u6a21\u677f\uff0c\u76f4\u63a5\u5c06\u8981\u6253\u5370\u7684\u6570\u636e\u5199\u5165\uff1b\n<em>\n<\/em>\u00a0\u00a03\u3001\u6253\u5370\uff0c\u6839\u636e\u5b9e\u9645\u7684\u6548\u679c\u8c03\u6574Excel\u6a21\u677f\u884c\u9ad8\u5217\u5bbd\u53ca\u7a7a\u51fa\u7684\u884c\u5217\uff0c  \u76f4\u5230\u80fd\u591f\u51c6\u786e\u7684\u5957\u4e0a\u3002\u5c06\u6a21\u677f\u62f7\u8d1d\u4e00\u4efd\uff0c\u6e05\u9664\u6a21\u677f\u4e0a\u7684\u6587\u5b57\u4e0e\u7f51\u683c\u7ebf\uff0c\u505a\u6210\u5957\u6253\u7684\u6a21\u677f\u3002\n*\/<\/p>\n<p>#region \u5957\u6253\u3001\u6253\u5370\u9884\u89c8<\/p>\n<p>\/\/\u7528Excel\u6253\u5370\uff0c\u6b65\u9aa4\u4e3a\uff1a\u6253\u5f00\u3001\u5199\u6570\u636e\u3001\u6253\u5370\u9884\u89c8\u3001\u5173\u95ed\nGoldPrinter.ExcelExpert.ExcelBase excel = new  GoldPrinter.ExcelExpert.ExcelBase();\nstring strFileName = &#8220;invoice.xlt&#8221;;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u6a21\u677f\u6587\u4ef6\u540d<\/p>\n<p>if (p_printFlag == PrintFlag.CasePrint)\n{\nstrFileName = &#8220;invoiceCase.xlt&#8221;;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u5957\u6253\u6a21\u677f\u6587\u4ef6\u540d\n}<\/p>\n<p>string strExcelTemplateFile =  System.IO.Path.GetFullPath(@&#8221;&#8230;.ExcelTemplate&#8221; + strFileName);<\/p>\n<p>excel.Open(strExcelTemplateFile);\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ \u7528\u6a21\u677f\u6587\u4ef6\nexcel.Visible =  false;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u5efa\u8bae\uff1a\u5982\u679cexcel\u4e0d\u53ef\u89c1\u4e14\u5728\u7f16\u7a0b\u60c5\u51b5\u4e0b\u5199\u6570\u636e\u7279 \u522b\u662f\u5927\u91cf\u6570\u636e\u65f6\nexcel.ScreenUpdating =  false;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u8bbe\u7f6e\u6b64\u5f00\u5173\u80fd\u5927\u5927\u63d0\u9ad8\u6548\u7387\u3002\u5199\u5b8c\u540e\u5982\u8981\u53ef\u89c1\uff0c\u518d\u8bbe\u7f6e\u6b64\u5c5e\u6027\u4e3a\u771f\u5237\u65b0\u5c4f \u5e55\u3002\nexcel.Caption = &#8220;\u7a0e \u52a1 \u673a \u5173 \u4ee3 \u5f00 \u7edf \u4e00 \u53d1 \u7968\uff08\u56fd  \u7a0e\uff09&#8221;;\u00a0\u00a0\u00a0\u00a0\/\/&#8221;MIS\u91d1\u8d28\u6253\u5370\u901a\u00a0\u00a0\u901a\u6253\u5929\u4e0b\u62a5\u8868&#8221;;<\/p>\n<p>\/\/\u5728\u6a21\u677f\u4e2d\u5199\u5165\u8981\u6253\u5370\u7684\u6570\u636e<\/p>\n<p>\/\/<strong><em>\u53d1\u7968\u62ac\u5934<\/em><\/strong><\/p>\n<p>\/\/\u5e74\u6708\u65e5\nexcel.SetCellText(7,&#8221;B&#8221;,txtYear.Text + &#8220;\u5e74&#8221; + txtMonth.Text +  &#8220;\u6708&#8221; + txtDay.Text + &#8220;\u65e5&#8221; );<\/p>\n<p>\/\/\u4ed8\u6b3e\u65b9\u540d\u79f0\nexcel.SetCellText(8,&#8221;D&#8221;,txtPayer.Text);\n\/\/\u6536\u6b3e\u65b9\u540d\u79f0\nexcel.SetCellText(9,&#8221;D&#8221;,txtCollecter.Text);\n\/\/\u53ca\u5730\u5740\u3001\u7535\u8bdd\nexcel.SetCellText(11,&#8221;D&#8221;,txtCollecterAddTel.Text);<\/p>\n<p>\/\/ \u4ee3\u5f00\u666e\u901a\u53d1\u7968\u00a0\u00a0\u00a0 \u7533 \u8bf7 \u8868 \u53f7 \u7801\nexcel.SetCellText(8,&#8221;J&#8221;,txtInvoiceApplicationNo.Text);\n\/\/\u6536\u6b3e\u65b9\u8bc6\u522b\u53f7\u6216 \u8bc1 \u4ef6 \u53f7 \u7801\nexcel.SetCellText(9,&#8221;J&#8221;,txtCollecterID.Text);<\/p>\n<p>\/\/<strong><em>\u54c1\u540d\u53ca\u91d1\u989d\u3001\u5907\u6ce8<\/em><\/strong>\n\/\/B14\u5230B23\u662f\u54c1\u540d\u00a0\u00a0\u00a0F14\u5230F23\u4e3a\u91d1\u989d<\/p>\n<p>excel.SetCellText(&#8220;B14&#8221;,txtP1.Text);\nexcel.SetCellText(&#8220;F14&#8221;,txtJ1.Text);<\/p>\n<p>excel.SetCellText(&#8220;B15&#8221;,txtP2.Text);\nexcel.SetCellText(&#8220;F15&#8221;,txtJ2.Text);<\/p>\n<p>excel.SetCellText(&#8220;B16&#8221;,txtP3.Text);\nexcel.SetCellText(&#8220;F16&#8221;,txtJ3.Text);<\/p>\n<p>excel.SetCellText(&#8220;B17&#8221;,txtP4.Text);\nexcel.SetCellText(&#8220;F17&#8221;,txtJ4.Text);<\/p>\n<p>excel.SetCellText(&#8220;B18&#8221;,txtP5.Text);\nexcel.SetCellText(&#8220;F18&#8221;,txtJ5.Text);<\/p>\n<p>excel.SetCellText(&#8220;B19&#8221;,txtP6.Text);\nexcel.SetCellText(&#8220;F19&#8221;,txtJ6.Text);<\/p>\n<p>excel.SetCellText(&#8220;B20&#8221;,txtP7.Text);\nexcel.SetCellText(&#8220;F20&#8221;,txtJ7.Text);<\/p>\n<p>excel.SetCellText(&#8220;B21&#8221;,txtP8.Text);\nexcel.SetCellText(&#8220;F21&#8221;,txtJ8.Text);<\/p>\n<p>excel.SetCellText(&#8220;B22&#8221;,txtP9.Text);\nexcel.SetCellText(&#8220;F22&#8221;,txtJ9.Text);<\/p>\n<p>excel.SetCellText(&#8220;B23&#8221;,txtP10.Text);\nexcel.SetCellText(&#8220;F23&#8221;,txtJ10.Text);<\/p>\n<p>\/\/\u5907\u6ce8\n\/\/excel.SetCellText(14,&#8221;I&#8221;,txtMemo.Imag.);<\/p>\n<p>\/\/<strong><em>\u53d1\u7968\u603b\u91d1\u989d<\/em><\/strong><\/p>\n<p>\/\/\u5408\u8ba1\u4eba\u6c11\u5e01\u00a0\u00a0\u00a0\uff08\u5927\u5199\uff09\nexcel.SetCellText(24,&#8221;D&#8221;,txtTotalUpper.Text);\n\/\/\u5408\u8ba1\u4eba\u6c11\u5e01\u00a0\u00a0\u00a0\uff08\u5c0f\u5199\uff09\nexcel.SetCellText(24,&#8221;K&#8221;,txtTotalLower.Text);<\/p>\n<p>\/\/\u7a0e\u989d\u00a0\u00a0\u00a0\uff08\u5927\u5199\uff09\nexcel.SetCellText(25,&#8221;D&#8221;,txtTaxUpper.Text);\n\/\/\u7a0e\u989d\u00a0\u00a0\u00a0\uff08\u5c0f\u5199\uff09\nexcel.SetCellText(25,&#8221;L&#8221;,txtTaxLower.Text);<\/p>\n<p>\/\/<strong><em>\u53d1\u7968\u5c3e<\/em><\/strong>\n\/\/\u7a0e\u63a7\u7801\nexcel.SetCellText(26,&#8221;C&#8221;,txtTaxControlCode.Text);\n\/\/\u5f00\u7968\u4eba\uff1a\nexcel.SetCellText(26,&#8221;H&#8221;,txtWriter.Text);<\/p>\n<p>\/\/\u5237\u65b0Excel\u5c4f\u5e55\nexcel.ScreenUpdating = true;<\/p>\n<p>if (p_printFlag == PrintFlag.CasePrint || p_printFlag ==  PrintFlag.PrintAll)\n{\nexcel.Print();\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u6253\u5370\n}\nelse\n{\nexcel.PrintPreview();\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u9884\u89c8\n}<\/p>\n<p>excel.Close();\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u5173\u95ed\u5e76\u91ca\u653e<\/p>\n<p>#endregion<\/p>\n<p>}<\/p>\n<p>private void frmInvoice_Load(object sender, System.EventArgs e)\n{\n\/\/\u521d\u59cb\u5f53\u65e5\u65e5\u671f\nSystem.DateTime dt = System.DateTime.Now;\nSetToday(dt);\n}<\/p>\n<p>private void btnExit_Click(object sender, System.EventArgs e)\n{\nthis.Close();\n}<\/p>\n<p>\/\/\u56de\u8f66\nprivate void frmInvoice_KeyPress(object sender,  System.Windows.Forms.KeyPressEventArgs e)\n{\nif (e.KeyChar == (char)13)\n{\nSendKeys.Send(&#8220;{TAB}&#8221;);\n}\n}<\/p>\n<p>\/\/\u91d1\u989d\u5c0f\u5199\u8f6c\u4eba\u6c11\u5e01\u5927\u5199\nprivate void txtTotalLower_KeyUp(object sender,  System.Windows.Forms.KeyEventArgs e)\n{\nSetUpperMoney();\n}<\/p>\n<p>\/\/\u91cd\u65b0\u603b\u8ba1\nprivate void txtJX_TextChanged(object sender, System.EventArgs  e)\n{\ndouble dblMoney = 0;<\/p>\n<p>dblMoney += GetInputMoney(txtJ1.Text);\ndblMoney += GetInputMoney(txtJ2.Text);\ndblMoney += GetInputMoney(txtJ3.Text);\ndblMoney += GetInputMoney(txtJ4.Text);\ndblMoney += GetInputMoney(txtJ5.Text);\ndblMoney += GetInputMoney(txtJ6.Text);\ndblMoney += GetInputMoney(txtJ7.Text);\ndblMoney += GetInputMoney(txtJ8.Text);\ndblMoney += GetInputMoney(txtJ9.Text);\ndblMoney += GetInputMoney(txtJ10.Text);<\/p>\n<p>txtTotalLower.Text = dblMoney.ToString();\nSetUpperMoney();<\/p>\n<p>}<\/p>\n<p>\/\/\u6539\u53d8\u7a0e\u7387\u91cd\u7b97\nprivate void cboTaxRate_TextChanged(object sender,  System.EventArgs e)\n{\nSetUpperMoney();\n}<\/p>\n<p>private void btnRefDate_Click(object sender, System.EventArgs e)\n{\ncldSelect.Visible = true;\ncldSelect.SetDate(new  DateTime(int.Parse(txtYear.Text),int.Parse(txtMonth.Text),int.Parse(txtDay.Text)));\ncldSelect.Focus();\n}<\/p>\n<p>private void cldSelect_DateSelected(object sender,  System.Windows.Forms.DateRangeEventArgs e)\n{\nSetToday(e.End);\ncldSelect.Visible = false;\n}<\/p>\n<p>\/\/\u5927\u5199\u5408\u8ba1\u4eba\u6c11\u5e01\u3001\u7a0e\u989d\nprivate void SetUpperMoney()\n{\ntry\n{\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string strUpper =  GoldPrinter.ExcelExpert.ChineseNum.GetUpperMoney(Double.Parse(txtTotalLower.Text));\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u5408\u8ba1\u4eba\u6c11\u5e01\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0txtTotalUpper.Text = strUpper;\n\/\/\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0strUpper =  GoldPrinter.ExcelExpert.ChineseNum.GetUpperMoney(Double.Parse(txtTotalLower.Text)  <em> Double.Parse(cboTaxRate.Text) \/ 100);\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u7a0e\u989d = \u5408\u8ba1\u4eba\u6c11\u5e01 <\/em> \u7a0e\u7387\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0txtTaxUpper.Text = strUpper;<\/p>\n<p>}\ncatch{}\n}<\/p>\n<p>private double GetInputMoney(string p_text)\n{\ndouble dblReturn = 0;\ntry\n{\ndblReturn = double.Parse(p_text);\n}\ncatch{}<\/p>\n<p>return dblReturn;\n}<\/p>\n<p>private void SetToday(System.DateTime dt)\n{\ntxtYear.Text = dt.Year.ToString();<\/p>\n<p>txtMonth.Text = GetLengthTwoDate(dt.Month.ToString());\ntxtDay.Text = GetLengthTwoDate(dt.Day.ToString());\n}<\/p>\n<p>private string GetLengthTwoDate(string p_MonthOrDay)\n{\nstring strReturn = p_MonthOrDay;\nif (strReturn.Length == 1)\n{\nstrReturn = &#8220;0&#8221; + strReturn;\n}<\/p>\n<p>return strReturn;\n}<\/p>\n<p>}\/\/End Class\n}\/\/End Namespace<\/p>","protected":false},"excerpt":{"rendered":"<p>\u6e90\u7801 \/* &#8216;\u00a0\u00a0\u00a0\/\/&#8211;\/\/ &#8216;\u00a0\u00a0\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5982\u679c\u60a8\u8981\u732e\u4e00\u4efd\u7231\u5fc3\uff0c\u8bf7\u53c2\u9884\u5e0c\u671b\u5de5\u7a0b\uff01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ &#8216; \/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[92,102,105,106],"class_list":["post-157","post","type-post","status-publish","format-standard","hentry","category-win","tag-c","tag-excel","tag-105","tag-106"],"_links":{"self":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=157"}],"version-history":[{"count":2,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":159,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/157\/revisions\/159"}],"wp:attachment":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}