什么是自动化Excel任务的最简单方法 [英] What is the easiest way to automate Excel tasks

问题描述

如果我需要自动化系列在Excel表单就像一个任务

If I need to automate a series a task on an excel sheet like

• 删除，其中3列包含值ASDF的所有行

• remove all rows where column 3 contains value "asdf"

删除列7和第9列

根据排序列4

等。

什么是Excel自动化等任务的最简单的方法？我认为这将录制宏，但有时宏不得不被编辑了很多真正使他们的工作甚则宏停止，如果Excel工作表有变化。编辑宏脚本可能是一个时间服用过程，变得低效此类任务。自动化是必需的，因为Excel工作表的数量会很多。您能否提供一个更简单的方法？

What is the easiest way of automating such tasks in excel? I think it would recording a macro but sometimes macro have to be edited a lot to actually make them work and even then macros stop if the excel sheet has a variation. Editing macro scripts could be a time taking process which becomes inefficient for such tasks. The automation is required since number of excel sheets will be a lot. Can you suggest an easier way ?

推荐答案

只要，你有活动定义 - 宏仍然是更好的东西来寻找结果
可能有一些事情可能会改变。

As long as, you have the activities defined - Macro is still the better thing to look for.
There could be some things that could change.

请解释与code的帮助的问题。结果
如果您已经定义了几个变量的步骤，应该很容易写一个宏，不会在变化的情况下停止。

Please explain the problem with the help of code.
If you have defined the steps with a few variables, it should be easy to write a macro that wouldn't stop in case of variation.

请张贴code和详细描述你想要什么？这点它停止，在变化的情况下，？你想什么code办？

Please post the code and describe in detail what you would want? which point does it stop, in case of variation? What would you like the code to do?

编辑：或者，你可以写code在VB6 / .NET（C＃/ vb.net）/ Python的自动化

Alternatively, you can write code in VB6/.net (c#/vb.net)/Python for automation.

这篇关于什么是自动化Excel任务的最简单方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！