📄 thirdday.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
using DBClass;
using System.Data.SqlClient;
namespace AdministrationSystem
{
/// <summary>
/// thirdday 的摘要说明。
/// </summary>
public class thirdday : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlGenericControl dv;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
string tGivenDateTime=Request["GivenDate"];
string tEndDate=Request["EndDate"];
string DateFormating=Convert.ToDateTime(tGivenDateTime).Year+"年"+Convert.ToDateTime(tGivenDateTime).Month+"月"+Convert.ToDateTime(tGivenDateTime).Day+"日";
BusinessDAL myBusiness=new BusinessDAL();
// DataTable dt=myBusiness.thirdday1(Convert.ToDateTime(tGivenDateTime));
DataTable dt=myBusiness.thirddayrange1(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness1=new BusinessDAL();
// DataTable dt1=myBusiness1.thirdday2(Convert.ToDateTime(tGivenDateTime));
DataTable dt1=myBusiness.thirddayrange2(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness2=new BusinessDAL();
// DataTable dt2=myBusiness2.thirdday3(Convert.ToDateTime(tGivenDateTime));
DataTable dt2=myBusiness.thirddayrange3(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness3=new BusinessDAL();
// DataTable dt3=myBusiness3.thirdday4(Convert.ToDateTime(tGivenDateTime));
DataTable dt3=myBusiness.thirddayrange4(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness4=new BusinessDAL();
// DataTable dt4=myBusiness4.thirdday5(Convert.ToDateTime(tGivenDateTime));
DataTable dt4=myBusiness.thirddayrange5(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness5=new BusinessDAL();
// DataTable dt5=myBusiness5.thirdday6(Convert.ToDateTime(tGivenDateTime));
DataTable dt5=myBusiness.thirddayrange6(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness6=new BusinessDAL();
// DataTable dt6=myBusiness6.thirdday7(Convert.ToDateTime(tGivenDateTime));
DataTable dt6=myBusiness.thirddayrange7(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
BusinessDAL myBusiness7=new BusinessDAL();
// DataTable dt7=myBusiness7.thirdday8(Convert.ToDateTime(tGivenDateTime));
DataTable dt7=myBusiness.thirddayrange8(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
StringBuilder s=new StringBuilder();
s.Append("<script language=vbscript>\n");
s.Append("Sub Window_OnLoad()\n");
s.Append("Spreadsheet1.ActiveSheet.Cells.Clear\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A1:i1\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").rowheight=30\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").value =\"各区县行政许可审批事项办理情况统计表\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").font.size=16\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").font.bold=true\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a1\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a1\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A2\").value =\"区县\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b2\").value =\"行政许可和审批（服务）事项\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"f2\").value =\"接件\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"g2\").value =\"受理\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"h2\").value =\"准予许可\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"i2\").value =\"不予许可\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").font.bold=true\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").rowheight =20\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b2:e2\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a3:a10\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").value=\"和平区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a11:a18\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").value=\"河西区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a19:a26\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").value=\"河东区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a27:a34\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").value=\"南开区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a35:a42\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\"). value=\"河北区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:e3\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b3\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b4:e4\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b4\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b5:e5\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b5\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b6:e6\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b6\").value=\"计量器具鉴定（计量器具强制鉴定）\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b7:e7\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b7\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b8:e8\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b8\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b9:e9\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b9\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b10:e10\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b10\").value=\"组织机构代码核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b11:e11\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b11\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b12:e12\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b12\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b13:e13\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b13\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b14:e14\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b14\").value=\"计量器具鉴定（计量器具强制鉴定）\" \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b15:e15\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b15\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b16:e16\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b16\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b17:e17\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b17\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b18:e18\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b18\").value=\"组织机构代码核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b19:e19\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b19\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b20:e20\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b20\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b21:e21\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b21\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b22:e22\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b22\").value=\"计量器具鉴定（计量器具强制鉴定）\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b23:e23\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b23\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b24:e24\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b24\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b25:e25\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b25\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b26:e26\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b26\").value=\"组织机构代码核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b27:e27\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b27\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b28:e28\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b28\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b29:e29\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b29\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b30:e30\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b30\").value=\"计量器具鉴定（计量器具强制鉴定）\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b31:e31\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b31\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b32:e32\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b32\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b33:e33\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b33\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b34:e34\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b34\").value=\"组织机构代码核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b35:e35\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b35\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b36:e36\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b36\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b37:e37\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b37\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b38:e38\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b38\").value=\"计量器具鉴定（计量器具强制鉴定）\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b39:e39\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b39\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b40:e40\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b40\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b41:e41\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b41\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b42:e42\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b42\").value=\"组织机构代码核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:b42\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:b42\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:b42\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A47\").value =\"区县\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b47\").value =\"行政许可和审批（服务）事项\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"f47\").value =\"接件\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"g47\").value =\"受理\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"h47\").value =\"准予许可\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"i47\").value =\"不予许可\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A47:i47\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A47:i47\").font.bold=true\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A47:i47\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A47:i47\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"A47:i47\").rowheight =20\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b47:e47\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a48:a55\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a48\").value=\"红桥区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a48\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a48\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a48\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a56:a63\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a56\").value=\"西青区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a56\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a56\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a56\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a64:a71\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a64\").value=\"东丽区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a64\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a64\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a64\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a72:a79\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a72\").value=\"北辰区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a72\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a72\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a72\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a80:a87\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a80\"). value=\"津南区\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a80\").font.size=12\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a80\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"a80\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b48:e48\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b48\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b49:e49\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b49\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b50:e50\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b50\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b51:e51\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b51\").value=\"计量器具鉴定（计量器具强制鉴定）\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b52:e52\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b52\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b53:e53\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b53\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b54:e54\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b54\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b55:e55\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b55\").value=\"组织机构代码核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b56:e56\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b56\").value=\"计量标准器具核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b57:e57\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b57\").value=\"制造、修理计量器具许可签发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b58:e58\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b58\").value=\"计量检定员资格核准\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b59:e59\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b59\").value=\"计量器具鉴定（计量器具强制鉴定）\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b60:e60\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b60\").value=\"特种设备使用登记\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b61:e61\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b61\").value=\"特种设备作业人员考核\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b62:e62\").Merge\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b62\").value=\"食品生产许可证核发\"\n");
s.Append("Spreadsheet1.ActiveSheet.Range(\"b63:e63\").Merge\n");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -