Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.
Closed 10 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(3)
我担心你可能找不到。 David Mullet 正在正在写一本书,但这意味着它仍然是距离出版还有相当长的一段时间。
你到底需要多“完整”、“系统”、“标准”?你必须考虑到有人需要有动力来制作这样的教程,这将是一项没有报酬的大量工作;这就是为什么一本书正在准备中 - 然后我们就可以向大卫支付他的专业知识!
因此,我们可能需要修改您的需求,以便更能满足当前的现实:您是否有想要解决的特定问题?你能在这里提出一些更具体的问题吗?
I fear you may not find one. David Mullet is working on a book but that rather implies that it's still some considerable time away from publication.
How "complete", "systematic" and "standard" do you really need it to be? You have to consider that someone needs to have the motivation to produce such a tutorial, which would be a substantial piece of work to undertake for no reward; that's why a book is in preparation - then we can pay David for his expertise!
So we may need to modify your need to be more satisfiable by current reality: are there particular problem(s) you are trying to solve? Could you put some more specific questions here?
当我看到你的帖子时,我正在考虑发布同样的问题。我不确定你到底想做什么,但我在 Ruby 和 Excel 方面取得了一些成功。我发现,如果您可以创建一个 Excel 宏来执行与您希望 Ruby 执行的操作类似的操作,那么您可以或多或少地“rubyfy”宏代码并访问 Ruby 代码中的所有相同方法和属性。我能够弄清楚如何让 Ruby 以这种方式创建 Excel 图表和单元格颜色编码。如果您想要交互的软件有类似的宏工具,您也许能够弄清楚如何使用 ruby 与该软件交互。我确实很期待迈克提到的那本书。
I was thinking about posting the same question when I came across your post. I'm not sure what exactly you are trying to do, but I have had some success with Ruby and Excel. I find that if you can create an Excel macro that does something similar to what you would like Ruby to do, you can more or less 'rubyfy' the macro code and access all the same methods and attributes in your Ruby code. I was able to figure out how to get Ruby to create Excel graphs, and cell color coding this way. If the software you want to interact with has a similar macroing tool, you may be able to work out how to use ruby to interact with that software. I do look forward to the book that Mike mentioned.
假设问题出在 win32OLE 而不是 ruby,我会很想寻找其他脚本语言(例如 perl)的指南。
Assuming that the problems are with win32OLE rather than with ruby, I'd be half tempted to look for guides in other scripting languages, such as perl.