{"id":8624,"date":"2012-02-06T00:10:18","date_gmt":"2012-02-05T16:10:18","guid":{"rendered":"http:\/\/bohu.net\/blog\/?p=8624"},"modified":"2012-02-06T00:10:18","modified_gmt":"2012-02-05T16:10:18","slug":"excel-%e6%95%b0%e5%ad%97%e5%88%97%e5%90%8d%e5%ba%8f%e5%8f%b7%e4%b8%8e%e5%ad%97%e6%af%8d%e5%88%97%e5%90%8d%e5%ba%8f%e5%8f%b7%e7%9a%84%e8%bd%ac%e6%8d%a2","status":"publish","type":"post","link":"https:\/\/www.bohu.net\/blog\/8624\/","title":{"rendered":"Excel \u6570\u5b57\u5217\u540d(\u5e8f\u53f7)\u4e0e\u5b57\u6bcd\u5217\u540d(\u5e8f\u53f7)\u7684\u8f6c\u6362"},"content":{"rendered":"

2012\u5e742\u67086\u65e5<\/small>\u4f5c\u8005:enet<\/p>\n

 <\/p>\n

\u6765\u81ea: http:\/\/www.tal-rasha.com\/archives\/254.html<\/a>
\n\u5199\u4ee3\u7801\u4f7f\u7528\u5230\u7684Excel<\/strong>\u5217<\/strong>\u540d<\/strong>\u4e0e\u5217<\/strong>\u7d22\u5f15\u95f4\u7684\u8f6c\u6362\uff0c\u5176\u5b9e\u5c31\u662f\u5341\u8fdb\u5236\u548c\u4e8c\u5341\u516d\u8fdb\u5236\u95f4\u7684\u8f6c\u6362<\/p>\n

        \/\/\/ <summary>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ \u7528\u4e8eexcel<\/strong>\u8868\u683c\u4e2d\u5217<\/strong>\u53f7\u5b57\u6bcd<\/strong>\u8f6c\u6210\u5217<\/strong>\u7d22\u5f15\uff0c\u4ece1\u5bf9\u5e94A\u5f00\u59cb\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <\/summary>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <param name=\"column\">\u5217<\/strong>\u53f7<\/param>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <returns>\u5217<\/strong>\u7d22\u5f15<\/returns>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 private int ColumnToIndex(string column)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (!Regex.IsMatch(column.ToUpper(), @\"[A-Z]+\"))\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 throw new Exception(\"Invalid parameter\");\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int index = 0;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 char[] chars = column.ToUpper().ToCharArray();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for (int i = 0; i < chars.Length; i++)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 index += ((int)chars[i] - (int)'A' + 1) * (int)Math.Pow(26, chars.Length - i - 1);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return index;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <summary>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ \u7528\u4e8e\u5c06excel<\/strong>\u8868\u683c\u4e2d\u5217<\/strong>\u7d22\u5f15\u8f6c\u6210\u5217<\/strong>\u53f7\u5b57\u6bcd<\/strong>\uff0c\u4eceA\u5bf9\u5e941\u5f00\u59cb\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <\/summary>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <param name=\"index\">\u5217<\/strong>\u7d22\u5f15<\/param>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\/ <returns>\u5217<\/strong>\u53f7<\/returns>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 private string IndexToColumn(int index)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (index <= 0)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 throw new Exception(\"Invalid parameter\");\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 index--;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string column = string.Empty;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 do\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (column.Length > 0)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { index--;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 column = ((char)(index % 26 + (int)'A')).ToString() + column;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 index = (int)((index - index % 26) \/ 26);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } while (index > 0);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return column;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/pre>\n","protected":false},"excerpt":{"rendered":"
2012\u5e742\u67086\u65e5\u4f5c\u8005:enet   \u6765\u81ea: http:\/\/www.tal-rasha.com\/ar … \u7ee7\u7eed\u9605\u8bfb\u201cExcel \u6570\u5b57\u5217\u540d(\u5e8f\u53f7)\u4e0e\u5b57\u6bcd\u5217\u540d(\u5e8f\u53f7)\u7684\u8f6c\u6362\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,4,26],"tags":[50,98,151,152],"class_list":["post-8624","post","type-post","status-publish","format-standard","hentry","category-net","category-c-net","category-26","tag-net","tag-c","tag-excel","tag-exception-invalid"],"_links":{"self":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts\/8624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/comments?post=8624"}],"version-history":[{"count":0,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts\/8624\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/media?parent=8624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/categories?post=8624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/tags?post=8624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}