Python -OpenCV和Excel

发布于 2025-02-13 10:58:52 字数 1551 浏览 1 评论 0原文

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

幽蝶幻影 2025-02-20 10:58:53

在过去的10个小时中,您可能每小时可能会进行40次进口手动,而400项任务将只是清理。

但是,为了解释为什么它可以实现的原因,但也很可能会出现错误,在此处使用自动化是OCR之后的图像并转换为PDF。因此,它可以在CSV表中输出,以使导入出色。 (图像中描述的问题)

”在此处输入图像描述”

OCR有几个自然故障,因此您可能会注意到缺少条目0+860也没有预期的两个数字条目,这是因为OCR是一次字符,然后将其与词典与自我正确单词相比,但无法纠正随机编号。

您可以使用服务做得更好,但是仍然需要解决您追求的输出格式。正如您在这里看到的那样,布局没有用。 沥青路泥土路都应通过一个单元格向下降低。

下一个问题是如何将列和行转换为所需的Excel顺序,而无需缩放?

总而言之,我将尽可能地使用400个类似的工作流程,并将一天的付款设置为我的目标成本,如果需要的话,可能会付款。

Over the past 10 hours you could have perhaps done 40 imports manualy per hour and the 400 item task would be just cleanup.

However to explain why its achievable, but also highly likely with mistakes, using automation here is your image after OCR and convert to PDF. Thus it could be output in a csv table for import to excel. (Issues described under image)

enter image description here

OCR has several natural failings so you may note an entry is missing 0+860 also two numeric entries are not as expected, this is because OCR is one character at a time then compared with a dictionary to self correct words but cannot correct random numbering.

You could do better using a Service, but still need to resolve what format of output you are after. And as you see here the layout is not useful. bitumen road and dirt road should both be lower down, by one cell.
enter image description here

The next problem is how to transform the columns and rows into your desired excel order without any scaling ?

In summary for 400 similar I would have templated workflow as much as possible and set one day pay as my target cost, possibly paying somebody else if needed.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文