自动Excel乐趣 [英] Automated Excel Fun

问题描述

这是我正在尝试做的事情，请指出我正确的方向....我有一个perl脚本，从.txt中提取数据，以提供随叫随到的人。我没有创建perl脚本。我想每年使用以下年份更新txt文件
所以我们不必每隔x个月更新一次并更改txt文件中的日期。

Here's what I'm trying to do, please point me in the right direction.... I have a perl script that pulls data out of a .txt to provide who is on call. I didn't create the perl script. I want to annually update the txt file with the following years dates so we don't have to go in every x months and change the dates in the txt file.

我想创建一个xls文件，每年用数据更新一个txt文件。

I want to create a xls file that annually updates a txt file with data.

每年一次我想要一个excel文件从txt文件中提取数据并放入一列

Once a year I want an excel file to pull data from a txt file and put into one column

在这个列中，我想用分隔符将文本排序到列值"/"或"，"，

Within this column I want to sort text to columns with the delimiter value of "/" or ","

此时我有4个列（< 1/1 / 2017，bob jones>数据现在位于4个单独的列中<" 1""" ; 1"""""" bob jones">）

At this point I have 4 colums (<1/1/2017,bob jones> data is now in 4 separate colums <"1" "1" "2017" "bob jones">)

我将这些连接成perl脚本喜欢的格式"xx-xxxx，< name>""

I will concatenate these into a format that the perl script likes "x-x-xxxx,<name>"

我想接着输出并覆盖txt文件中的所有当前数据 

I want to then take that output and override all the current data in the txt file 

例如：

我的txt文件如下：

11/1/2017，bob jones

11/1/2017, bob jones

11/2/2017，tom smith

11/2/2017, tom smith

11/3/2017，frank sinatra

11/3/2017, frank sinatra

等。

在10/31/2018我希望xls文件更新新的txt文件：

On 10/31/2018 I want the new txt file to be updated by the xls file:

11/1 / 2018年，鲍勃·琼斯

11/1/2018, bob jones

11/2/2018，汤姆史密斯

11/2/2018, tom smith

11/3/2018，frank sinatra

11/3/2018, frank sinatra

我知道如何获取静态数据并将其操作为我想要的。

I know how to take static data and manipulate it to what I want.

即11/1 2017，bob jones TO 11-1-2017，bob jones

ie 11/1/2017,bob jones TO 11-1-2017,bob jones

然而，我不知道如何自动从txt文件中提取数据并将其输入xls文件，然后在xls文件操作数据后将其推回并覆盖txt文件中的数据。

however, i do not know how to automatically pull data from a txt file and input it in an xls file then after the xls file manipulates the data push it back out and override the data in the txt file.

我输了吗？...哈哈

推荐答案

这是讨论Microsoft Excel功能的问题和反馈的论坛，我将把你的问题转到MSDN的Excel论坛上

Hi,

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或向您学习与我们互动。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于自动Excel乐趣的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！