{"version":"https://jsonfeed.org/version/1.1","title":"苏迟但到的主页","home_page_url":"https://kexohproject.pages.dev","feed_url":"https://kexohproject.pages.dev/json/","description":"<p>你好，欢迎访问个人主页！</p><p>擅长密码学，安全分析，数字水印等技术。</p><p>你可以联系我通过:findmykexin@gmail.com或者知乎私信。</p><p>我的知乎链接：<a href=\"https://www.zhihu.com/people/su-chi-dan-dao\" rel=\"noopener noreferrer\" target=\"_blank\">苏迟但到 - 知乎 (zhihu.com)</a></p><p>我的github链接：<a href=\"https://github.com/kexinoh\" rel=\"noopener noreferrer\" target=\"_blank\">kexinoh</a></p>","icon":"https://kexohcdn.gptapi.cyou/kexohproject/production/images/channel-2e54d141ee195646ca12a9d16507a908.jpg","favicon":"https://kexohcdn.gptapi.cyou/kexohproject/production/images/favicon-340a2925d02a0386f3b954a032834917.jpg","authors":[{"name":"苏迟但到"}],"language":"zh-cn","items":[{"id":"snHwDg9Ovce","title":"你被哪个后来知道很sb的BUG困扰过一周以上吗？","content_html":"<p data-pid=\"pApV1yF4\">我手上有一些excel文档，然后糟糕的是我需要读取颜色来收集数据。类似下面：</p><figure data-size=\"normal\"><noscript><img src=\"https://pic4.zhimg.com/v2-4769f145a81c2a3b9baaa07347df48cf_b.jpg\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"287\" data-rawheight=\"317\" data-original-token=\"v2-d32ee6e9d6d0e6ce5b75b63307b78ac5\" data-default-watermark-src=\"https://pic1.zhimg.com/v2-d7a15c319dac9fab3240903d86b7c694_b.jpg\" class=\"content_image\" width=\"287\"/></noscript><img src=\"data:image/svg+xml;utf8,&lt;svg xmlns=&#39;http://www.w3.org/2000/svg&#39; width=&#39;287&#39; height=&#39;317&#39;&gt;&lt;/svg&gt;\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"287\" data-rawheight=\"317\" data-original-token=\"v2-d32ee6e9d6d0e6ce5b75b63307b78ac5\" data-default-watermark-src=\"https://pic1.zhimg.com/v2-d7a15c319dac9fab3240903d86b7c694_b.jpg\" class=\"content_image lazy\" width=\"287\" data-actualsrc=\"https://pic4.zhimg.com/v2-4769f145a81c2a3b9baaa07347df48cf_b.jpg\"/></figure><p data-pid=\"Ztb1n-lh\">但是好在代码其实不难，我们可以使用openpyxl来读取文档，具体是使用cell.fill.start_color.index来单元格的颜色。</p><p data-pid=\"THW3FJWb\">我只需要读取是否为白色就可以了</p><figure data-size=\"normal\"><noscript><img src=\"https://pic4.zhimg.com/v2-460a2e78468a6df261c7238348368d8b_b.jpg\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"451\" data-rawheight=\"465\" data-original-token=\"v2-977b205a682a3abb493bdfcb0c391280\" data-default-watermark-src=\"https://pic4.zhimg.com/v2-97b87f80f674309780678b34c5f731bf_b.jpg\" class=\"origin_image zh-lightbox-thumb\" width=\"451\" data-original=\"https://pic4.zhimg.com/v2-460a2e78468a6df261c7238348368d8b_r.jpg\"/></noscript><img src=\"data:image/svg+xml;utf8,&lt;svg xmlns=&#39;http://www.w3.org/2000/svg&#39; width=&#39;451&#39; height=&#39;465&#39;&gt;&lt;/svg&gt;\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"451\" data-rawheight=\"465\" data-original-token=\"v2-977b205a682a3abb493bdfcb0c391280\" data-default-watermark-src=\"https://pic4.zhimg.com/v2-97b87f80f674309780678b34c5f731bf_b.jpg\" class=\"origin_image zh-lightbox-thumb lazy\" width=\"451\" data-original=\"https://pic4.zhimg.com/v2-460a2e78468a6df261c7238348368d8b_r.jpg\" data-actualsrc=\"https://pic4.zhimg.com/v2-460a2e78468a6df261c7238348368d8b_b.jpg\"/></figure><p data-pid=\"efhhMQZK\">可以看见wps中表格的背景色的定义为FFFFFF，也就是说我只需要判断cell.fill.start_color.index是否为FFFFFFFF即可。但是使用cell.fill.start_color.index却怎么也不能读取到全部的数据，只能读到一小部分的数据。</p><p data-pid=\"4ttkJBa7\">现在很SB的BUG出现了。</p><p data-pid=\"HGmnrR94\">我就可以开始了漫长的debug，然后我尝试把所有的单元格的颜色输出的时候发现，</p><p data-pid=\"jY-AtrdY\">竟然部分单元格的颜色其实为00000000（透明度为100%的黑色），但是我的文档之中FFFFFFFF和00000000都存在，从而导致了读取数据不全的问题。但是在WPS的设置背景颜色中，显示的都是FFFFFF。</p>","content_text":"我手上有一些excel文档，然后糟糕的是我需要读取颜色来收集数据。类似下面：\n\n[https://pic4.zhimg.com/v2-4769f145a81c2a3b9baaa07347df48cf_b.jpg][data:image/svg+xml;utf8,&lt;svg\nxmlns=&#39;http://www.w3.org/2000/svg&#39; width=&#39;287&#39;\nheight=&#39;317&#39;&gt;&lt;/svg&gt;]\n\n但是好在代码其实不难，我们可以使用openpyxl来读取文档，具体是使用cell.fill.start_color.index来单元格的颜色。\n\n我只需要读取是否为白色就可以了\n\n[https://pic4.zhimg.com/v2-460a2e78468a6df261c7238348368d8b_b.jpg][data:image/svg+xml;utf8,&lt;svg\nxmlns=&#39;http://www.w3.org/2000/svg&#39; width=&#39;451&#39;\nheight=&#39;465&#39;&gt;&lt;/svg&gt;]\n\n可以看见wps中表格的背景色的定义为FFFFFF，也就是说我只需要判断cell.fill.start_color.index是否为FFFFFFFF即可。但是使用cell.fill.start_color.index却怎么也不能读取到全部的数据，只能读到一小部分的数据。\n\n现在很SB的BUG出现了。\n\n我就可以开始了漫长的debug，然后我尝试把所有的单元格的颜色输出的时候发现，\n\n竟然部分单元格的颜色其实为00000000（透明度为100%的黑色），但是我的文档之中FFFFFFFF和00000000都存在，从而导致了读取数据不全的问题。但是在WPS的设置背景颜色中，显示的都是FFFFFF。","date_published":"2023-10-02T08:38:06.000Z","_microfeed":{"web_url":"https://kexohproject.pages.dev/i/sbbug-snHwDg9Ovce/","json_url":"https://kexohproject.pages.dev/i/snHwDg9Ovce/json/","rss_url":"https://kexohproject.pages.dev/i/snHwDg9Ovce/rss/","guid":"snHwDg9Ovce","status":"published","itunes:title":"New Article Title for iTunes","date_published_short":"Mon Oct 02 2023","date_published_ms":1696235886000}}],"_microfeed":{"microfeed_version":"0.1.2","base_url":"https://kexohproject.pages.dev","categories":[{"name":"Education","categories":[{"name":"Language Learning"}]},{"name":"Technology"}],"subscribe_methods":[{"name":"RSS","type":"rss","url":"https://kexohproject.pages.dev/rss/","image":"https://kexohproject.pages.dev/assets/brands/subscribe/rss.png","enabled":true,"editable":false,"id":"4KlfbtkEfzy"},{"name":"JSON","type":"json","url":"https://kexohproject.pages.dev/json/","image":"https://kexohproject.pages.dev/assets/brands/subscribe/json.png","enabled":true,"editable":false,"id":"DVFm7TYiNSq"}],"description_text":"你好，欢迎访问个人主页！\n\n擅长密码学，安全分析，数字水印等技术。\n\n你可以联系我通过:findmykexin@gmail.com或者知乎私信。\n\n我的知乎链接：苏迟但到 - 知乎 (zhihu.com)\n\n我的github链接：kexinoh","copyright":"©2024","itunes:type":"episodic","items_sort_order":"newest_first"}}