{"id":1106,"date":"2020-07-20T17:12:48","date_gmt":"2020-07-20T09:12:48","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/?p=1106"},"modified":"2020-07-20T17:12:48","modified_gmt":"2020-07-20T09:12:48","slug":"xlwt%e5%86%99%e5%85%a5excel%e6%97%b6%e5%87%ba%e9%94%99%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/qbtobjow.ipyingshe.net:5347\/?p=1106","title":{"rendered":"xlwt\u5199\u5165excel\u65f6\u51fa\u9519\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>#\u8bfb\u53d6excel\u6587\u4ef6\u5185\u5bb9\nimport xlrd\nimport xlwt\nworkbook=xlrd.open_workbook(\"text1.xlsx\")\nsheet_name=workbook.sheet_names()\nprint(sheet_name)\nsheet=workbook.sheet_by_index(0)\nprint(sheet.cell_value(1,3))\nrows=sheet.row_values(5)  #fiveth row  output\ncols=sheet.col_values(3)  #therd col  output\nprint(rows)\nprint(cols)\n#print(sheet.name,sheet.nrows,sheet.ncols)\n#\u5199\u5165\u6570\u636e\u5230excel\u6587\u4ef6\uff0c\u8c03\u8bd5\u73af\u5883 debian10,python3.7,pycharm 2020.1\n#from xlwt import Worksheet\nworkbook = xlwt.Workbook(encoding='ascii', style_compression=0) #\u8fd9\u53e5\u53ef\u4ee5\u6b63\u786e\u6267\u884c\uff01\n#workbook = xlwt.Workbook \u5982\u679c\u7a0b\u5e8f\u8fd9\u6837\u5199\uff0c\u8fd0\u884c\u65f6\u603b\u662f\u51fa\u9519\uff01\u53c2\u89c1xlwt\u5305\u6587\u4ef6\uff0c\u7f51\u5740https:\/\/xlwt.readthedocs.io\/en\/latest\/api.html\nworksheet = workbook.add_sheet(\"test1\",cell_overwrite_ok=True)\nworksheet.write(0,0,1357)\nworksheet.write(0,1,358)\nworkbook.save(\"texcel.xls\")\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1106","post","type-post","status-publish","format-standard","hentry","category-2"],"_links":{"self":[{"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1106"}],"version-history":[{"count":1,"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions"}],"predecessor-version":[{"id":1107,"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions\/1107"}],"wp:attachment":[{"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1106"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/qbtobjow.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}