你如何开始自动化我的工作？ - 第2部分 [英] How would you start automating my job? - Part 2

问题描述

（此问题的追踪）

在第一波进货（9小时的复印/粘贴）生存之后，我现在相信我有所有要求。

After surviving the first wave of incoming shipments (9 hours of copy/paste), I now believe I have all the requirements.

以下是更新的工作流程：

Here is the updated workflow:

• Monkey收集电子邮件附件（4个Excel电子表格，1个PDF）

<猴子创建中央数据库，进行复杂的计算（现在这也是一个Excel电子表格）

• Monkey将数据发送给两位独立设置零售价格的老板，第一个回复胜利


• Monkey向我们的其他仓库发送订单，也是Excel


• Monkey将电子表格发送给VIP客户，仔细清理和格式化4种不同的折扣类别）


• 将数据快速输入会计系统。我放弃了自动化这一部分，涉及的业务逻辑太多，数据库是一堆sh ^ W遗产

• Monkey collects email attachments (4 Excel spreadsheets, 1 PDF)
• Monkey creates central database, does complex calculations (right now this is also an Excel spreadsheet)
• Monkey sends data to two bosses, who set the retail prices independently; first one to reply wins
• Monkey sends order form to our other warehouses, also Excel
• Monkey sends spreadsheets to VIP customers, carefully sanitized and formatted (4 different discount categories)
• Jurily enters the data into the accounting system. I've given up on automating this part, there's too much business logic involved, and the database is a pile of sh^W legacy

我的问题：你会用什么技术来实现一个快速而肮脏的解决方案？我主要出售在C＃上，但是来自Linux / C ++背景，我对微软的选择感到困惑。

My question: What technologies would you use for a quick and dirty solution? I'm mostly sold on C#, but coming from a Linux/C++ background, I'm horribly confused about my choices in Microsoft-land.

对于奖励积分：如何你会从头开始重新设计整个系统吗？

For bonus points: How would you redesign the whole system from the ground up?

澄清：我正在寻找任何有潜力让我阅读正确的东西，只是给我关键字和简短描述。 Google会引导我从那里。

Clarification: I'm looking for basically anything that has the potential to get me reading the right things, just give me the keywords and a short description. Google will guide me from there.

如果您想知道，我的职位是系统管理员

P.S. in case you were wondering, my job title is System Administrator.

推荐答案

您可以通过Com Interop与excel交互。请参阅本文，了解如何执行此操作C＃。这是一个难以理解的解决方案，您必须在具有Excel的系统上运行它。您没有创建电子表格，您以编程方式告诉Excel创建电子表格。这有自己的优点和缺点。

You can interact with excel via Com Interop. See this article for how to do this with C#. This is an ugly solution in the sense that you must run it on a system that has Excel. You are not creating spreadsheets, you are programmatically telling Excel to create spreadsheets. This has its own advantages and disadvantages.

自己创建电子表格（Excel可以打开spreadsheetml文件）相当容易，尽管这在某些情况下更加困难;生成一个xls文件的最简单方法是告诉Excel保存一个（将excel视为一个数据库也很简单，但这并不能让您访问所有Excel功能）。

It's reasonably easy to create spreadsheets yourself (Excel can open spreadsheetml files), though this makes it tougher in some instances; the easiest way to generate an xls file is to tell Excel to save one (treating excel as a database is pretty easy too, but that doesn't give you access to all Excel functionality).

这篇关于你如何开始自动化我的工作？ - 第2部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！