{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Select t_jhk","SQL Statement"],"read":"whole","date_system":"1900"}

{"sheet":"Select t_jhk","index":0,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[0,0,0,5]]}
["2020年黑龙江省中等职业学校毕业生专业对口升学招生录取专科批次征集志愿投档分数线"]
["院校代码","院校名称","专业代码","专业名称","科类","投档最低分"]
["5004","黑龙江林业职业技术学院","01","园林工程技术","01.种植类",292.054006032]
["5004","黑龙江林业职业技术学院","05","工程测量技术","14.土木水利类",308.049035024]
["5004","黑龙江林业职业技术学院","06","汽车检测与维修技术","17.交通运输类",239.016004019]
["5005","哈尔滨传媒职业学院","04","工艺美术品设计","12.工艺美术",276.049014013]
["5006","哈尔滨城市职业学院","03","会计","11.会计",328.064030034]
["5008","黑龙江艺术职业学院","01","摄影摄像技术","12.工艺美术",302.051015036]
["5008","黑龙江艺术职业学院","05","环境艺术设计","12.工艺美术",291.048012031]
["5009","大庆职业学院","05","市场营销","20.市场营销",306.066023017]
["5009","大庆职业学院","06","酒店管理","23.旅游服务类",{"v":313.06601703,"d":"313.066017030"}]
["5011","黑龙江冰雪体育职业学院","03","计算机应用技术","13.计算机应用",331.067038026]
["5011","黑龙江冰雪体育职业学院","04","汽车运用与维修技术","17.交通运输类",277.042016019]
["5011","黑龙江冰雪体育职业学院","05","运动训练","31.体育与健身类",263.038007018]
["5012","大兴安岭职业学院","02","护理","04.护理类",282.048016018]
["5012","大兴安岭职业学院","03","旅游管理","23.旅游服务类",292.055018019]
["5014","鹤岗师范高等专科学校","01","会计","11.会计",284.050006028]
["5014","鹤岗师范高等专科学校","02","计算机应用技术","13.计算机应用",277.055010012]
["5016","黑龙江商业职业学院","04","电子商务","21.电子商务",282.047010025]
["5017","黑龙江农业经济职业学院","07","水利工程","14.土木水利类",275.050014011]
["5019","黑龙江能源职业学院","01","计算机应用技术","13.计算机应用",269.048000021]
["5020","伊春职业学院","01","护理","04.护理类",234.000016018]
["5020","伊春职业学院","02","计算机应用技术","13.计算机应用",330.073034023]
["5024","齐齐哈尔理工职业学院","01","财务管理","11.会计",330.067025038]
["5024","齐齐哈尔理工职业学院","02","会计","11.会计",301.064025012]
["5024","齐齐哈尔理工职业学院","03","建筑装饰工程技术","12.工艺美术",277.050006021]
["5024","齐齐哈尔理工职业学院","05","数字媒体应用技术","13.计算机应用",272.046008018]
["5024","齐齐哈尔理工职业学院","06","软件技术","13.计算机应用",293.051014028]
["5024","齐齐哈尔理工职业学院","07","建筑工程技术","14.土木水利类",318.051046021]
["5024","齐齐哈尔理工职业学院","08","工程造价","14.土木水利类",267.034018015]
["5024","齐齐哈尔理工职业学院","13","物流管理","20.市场营销",234.012008014]
["5025","黑龙江三江美术职业学院","03","软件技术","13.计算机应用",278.047014017]
["5025","黑龙江三江美术职业学院","06","美术教育","27.学前教育",271.048011012]
["5027","黑龙江民族职业学院","01","护理","04.护理类",268.044010014]
["5029","七台河职业学院","01","护理","04.护理类",266.042009015]
["5029","七台河职业学院","03","计算机网络技术","13.计算机应用",269.049006014]
["5034","齐齐哈尔高等师范专科学校","01","汽车检测与维修技术","17.交通运输类",274.044014016]
["5035","黑龙江农业职业技术学院","05","会计","11.会计",347.073039035]
["5040","哈尔滨北方航空职业技术学院","02","酒店管理","23.旅游服务类",283.048021014]

{"sheet":"SQL Statement","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
["select a.yxdh,b.yxmc,a.zydh,substr(c.zymc,3) zymc,d.klmc,a.tdzdf from t_jhk a,td_yxdh b,td_zydh c,td_kldm d where a.pcdm='1' and a.yxdh=b.yxdh and a.yxdh=c.yxdh and a.zydh=c.zydh and a.kldm=d.kldm order by 1,3"]