从Excel行填写信息路径表单吗? [英] Filling out infopath form from excel rows?
问题描述
大家好，我的处境有些棘手.
我在填写表格时遇到问题.现在，数据到达单个excel主文档，该文档每周更新一次.然后检查其中的值，进行手动修改，然后将其移至第二个excel文档(已完成的文档).我想要的是 单击主excel文档的能力(例如，单击包含员工0111的第1行)，并自动使用excel文档中的可用字段填充信息表单.然后，用户完成表单，然后单击提交. 然后，这将更新第二个文件，并从主Excel文档中删除该值.任何建议将不胜感激.
现在，我已经完成了表格和第二个文件的制作，因此您可以手动输入表格中的所有值(例如，员工0111)并将该信息放入第二个列表中.但我希望能够使第一部分自动化.谢谢！
这是一个主意.我们可以将日期从Excel电子表格导入到SharePoint列表中.然后，更新SharePoint列表中的项目.更新数据后，我们可以导出列表数据 单击功能区上的导出到Excel"按钮，将其导入Excel.
此处是有关如何基于电子表格创建列表的文章:
最好的问候，
Linda Zhang
Hi all, I'm in a bit of a sticky situation.
I have an issue with filing out a form. Right now, the data arrives in a single master excel document that is updated weekly. Then values in it are checked, modified manually, and moved to a second excel document (a completed one). What I would like, is the ability to click on the master excel document, (for instance, click on row 1, which contains employee 0111) and have the info form automatically populate with the fields available in the excel document. Then the user finishes the form, and clicks submit. This then updates the second file, and removes the value from the master excel document. Any advice would be appreciated.
Right now, I have finished making the form, and the second file, so you can manually enter all the values in the form, (The employee 0111 for example) and put that information in the second list. But I would like to be able to automate the first part. Thanks!
Hi pantherfanrh,
Here is an idea. We can import date from the Excel spreadsheet to a SharePoint list. Then, update the item in the SharePoint list. After updating the data, we can export the list data to Excel by clicking on "Export to Excel" button on the ribbon.
Here is an article about how to create a list based on a spreadsheet:
Best Regards,
Linda Zhang
这篇关于从Excel行填写信息路径表单吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
