以编程方式将excel上传到文档库，并读取这些内容以创建自定义列表 [英] Upload excel to Document library programmatically and read those contents to make a custom list
问题描述
我需要进行处理，在这里我必须创建一个html输入控件表单以浏览并将Excel文档(例如xls或xlsx)上传到Sharepoint 2013中的文档库，然后使用该excel数据创建一个新的自定义列表并将其显示在 共享点.
I have requirement to work on, where I have to create a html input control form to Browse and Upload Excel docs(say xls or xlsx) to document library in Sharepoint 2013, and then using that excel data I need to create a new custom list and display them in Sharepoint.
在我刚接触Sharepoint时，我一直在尝试在多个论坛上对此进行研究，但没有任何进展，请对此提供帮助.
As I new to Sharepoint, I have been trying to research about this on multiple forums but haven't had any progress, requesting to please help me on this.
确切地说，我的确切要求是:说我有一个如下的excel，
To be precise my exact requirement is: Say I have an excel as below,
我需要将此excel上载到文档库，然后按如下所示创建自定义列表:
I need to upload this excel to document library and then make a custom list as follows:
每个月的新计划值等于(该月的计划+(上个月的计划-前一个月的实际值)，这需要动态计算
The new Planned value of each next month be equal to (Planned of that month +(Planned of previous month - Actual of previous month), this needs to calculated dynamically
推荐答案
根据您的描述，您希望以编程方式将excel文件上传到库中，并使用其内容来创建自定义列表.
From your description, you want to upload an excel file into a library programmatically, and use its content to create a custom list.
有一些关于使用代码将文档上传到库中的线程，您可以参考它们:
There are some threads about uploading document into a library using code, you can refer to them:
http://stackoverflow .com/questions/468469/如何将文件上传到共享库中的文档库
https://www.codeproject.com/Articles /103503/如何上载Sharepoint中的文档
http://sharepointdotnetcart.blogspot.sg/2013/11/programmatically-upload-document .html
将excel数据上传到自定义列表中
Upload excel data into a custom list:
http://adicodes.com/upload-excel-data-into-sharepoint-自定义列表/
除了使用代码外，您可以考虑使用OOB功能将excel文件上传到库中并创建一个导入电子表格列表:
Except using code, you can consider using the OOB feature to upload the excel file into the library and create an Import Spreadsheet list:
http://3sharp.com/Blog/load-excel-data-to-sharepoint-2013-list-fast-easy/
这篇关于以编程方式将excel上传到文档库，并读取这些内容以创建自定义列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
