Excel表格作为“生成”软件的输入。单击botton和new excel sheet作为输出 [英] Excel sheet as input to software with "generate" click botton and new excel sheet as output
问题描述
亲爱的程序员，
我在互联网上寻找关于如何创建软件的想法，或者即使有关于我的问题的任何现有问题，但它结束了这个论坛要求它！希望我在正确的地方。
没有进一步的ado让我的请求。
我在一家公司工作，其中两个代码对我们的工作非常重要。
我们从预制excel表中提取代码。
Excel工作表有两列：Ax有两种类型的代码，第一种是LK1234567（前两个字母总是LK-没有变化 - 后跟七个第二种类型是1234567.两种代码对每种情况都增加增加 - 场景 -
第二列的代码形式为1234-5678- 9012-3456
我正在寻找一个从Excel工作表中提取这些代码的软件，然后点击它生成（提取或打印）Ax列中的代码它来自Bx列的相应代码，条件是一旦代码生成并使用它就应该从excel表中删除。（例子在下面分享）
例如：
----------------------- -------------------
B列栏目
LK1234567 1234- 5678-9012-3456
LK1234568 1236-6548-9513-5649
LK1234569 3549-9587-7546-3158
----- -------------------------------------
软件应该如下：
点击一下按钮就可以显示（打印屏幕）：
A：LK1234567 - ---> B：1234-5678-9012-3456
和Excel表格应该成为;
---------- --------------------------------
一栏B栏
LK1234568 1236-6548-9513-5649
LK1234569 3549-9587-7546-3158
---------------- --------------------------
生成按钮点击：
A：LK1234568 ----> B：1236-6548-9513-5649
Excel表格如下：
------------ ------------------------------
B列栏目
LK1234569 3549-9587-7546-3158
---------------------------------- --------
* / * / * / * / * / * / * / * / * / ** / * / * / * / * / * / * / * / * / * / * / * /
希望你们理解我的想法。
期待在最快的专业人士那里收到你的来信我需要向我的经理提出这个想法。
我尝试过：
老实说，在使用delphi和C ++的日子里我做了这个。
Dear programmers,
I was looking in the internet for an idea on how to create a software or even if there is any existing regarding my issue, but it ended up on this forum Asking for it!! hope I'm in the right place.
without further ado let get to my request.
I am working in a company where two codes are very important for our job.
We are extracting codes from a "pre-made" excel sheet.
The Excel sheet has two columns: Ax which has two type of codes, the first one is like LK1234567 (first two letters which are always LK -doesn't change- followed by seven digits. The second type is 1234567. both codes increment "increase" by one for every case -scenario-
The second column has codes in the form 1234-5678-9012-3456
I am looking for a software that extracts these codes from the excel sheet then with a click it generates (extract or print) the code from Ax column with it corresponding code from Bx column with a condition that once a code generated and used it should be deleted from the excel sheet. (example to be shared below)
Example:
------------------------------------------
A column B column
LK1234567 1234-5678-9012-3456
LK1234568 1236-6548-9513-5649
LK1234569 3549-9587-7546-3158
------------------------------------------
Software should be like follow:
one click on botton and it should shows (print screen):
A: LK1234567 ----> B: 1234-5678-9012-3456
and the Excel Sheet should become;
------------------------------------------
A column B column
LK1234568 1236-6548-9513-5649
LK1234569 3549-9587-7546-3158
------------------------------------------
"Generate" botton clicked:
A: LK1234568 ----> B: 1236-6548-9513-5649
Excel sheet be like:
------------------------------------------
A column B column
LK1234569 3549-9587-7546-3158
------------------------------------------
*/*/*/*/*/*/*/*/*/**/*/*/*/*/*/*/*/*/*/*/*/
Hope you guys understood my idea.
Expecting to hear from you at the soonest pros as I need to present the idea to my manager.
What I have tried:
Honestly I did this back in the days using delphi and C++
推荐答案
如何使用Excel创建队列| Chron.com [ ^ ]
谢谢Gerry的解决方案我会试一试。但是如果我想搜索与我键入的Ax相对应的Bx ???
Thank you Gerry for the solution I'll give it a try. But what if I want to search for Bx that correspond to Ax that I type ???
这篇关于Excel表格作为“生成”软件的输入。单击botton和new excel sheet作为输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
