如何使用VB.NET导入EXCEL文件 [英] How can I use VB.NET to imports a EXCEL file

问题描述

如何使用VB.NET读取EXCEL文件

解决方案

您好，

如果要将Excel数据导入SharePoint列表，我们可以使用OOTB功能（无代码）来实现它。

SharePoint提供导入电子表格应用，我们可以使用此应用将Excel数据导入列表。

https://support.office.com/en-us/article/创建基于列表的电子表格 - 380cfeb5-6e14-438e-988a-c2b9bea574fa

如果您只想使用VB.NET，我们需要从excel文件中读取数据并将数据添加到SharePoint列表中，以下文章供您参考：

使用VB.NET读取和编写Excel文件

https ：//www.codepro ject.com/Articles/18073/Reading-and-writing-an-Excel-file-using-VB-NET

如何：添加或删除列表项目

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ms467435(v%3Doffice.14 ）

在客户端，我们可以使用带有VB.NET代码的Web服务（Lists.asmx）来添加列表项。

https://blogs.msdn.microsoft.com/ ryanrogers / 2004/10/08 / adding-new-list-items-using-list-asmx-web-service /

最诚挚的问候，

Dennis

How can I use VB.NET to read the EXCEL file

解决方案

Hi,

If you want to import a Excel data to SharePoint List, we can use the OOTB feature(no code) to achieve it.

SharePoint provide a Import Spreadsheet app, we can use this app to import the excel data to a list.

https://support.office.com/en-us/article/create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa

If you just want to use VB.NET, we need read the data from excel file and add the data to a SharePoint list, the following articles for your reference:

Reading and writing an Excel file using VB.NET

https://www.codeproject.com/Articles/18073/Reading-and-writing-an-Excel-file-using-VB-NET

How to: Add or Delete List Items

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ms467435(v%3Doffice.14)

In Client-Side, we can use web service(Lists.asmx) with VB.NET code to add list items.

https://blogs.msdn.microsoft.com/ryanrogers/2004/10/08/adding-new-list-items-using-the-lists-asmx-web-service/

Best Regards,

Dennis

这篇关于如何使用VB.NET导入EXCEL文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！