Import spreedsheet import data from Excel to generate a Sharepoint list

Recently, users want to create a new project site. However, as many project materials are available, they want to import some Excel files to the Sharepoint list.

SharePoint itself already provides this import function: Import spreadsheet. However, some problems may occur during import.

1. The first one is the most common: The method 'post' fails when it acts on the object 'iowspostdata '.

There are many solutions on the internet, generally because of an office file exptoows. xla. Make some changes.

Generally, the file is stored in the following path: C:/program files/Microsoft Office/office12/1033 (slightly different from office languages)

I found three locations on my computer:

C:/program files/Microsoft Office/office11/1028

C:/program files/Microsoft Office/office14/2052

C:/program files/Microsoft Web designer tools/office12/2052

When an error occurs for the first time, the files in the C:/program files/Microsoft Office/office14/2052 (I installed the files in the Simplified Chinese version of Office 2007) path were changed. The problem was solved, yes.

After a few days, an error occurred, and exptoows was enabled. the xla file also prompts memory overflow... try to change exptoows under C:/program files/Microsoft Web designer tools/office12/2052. the xla file solves the problem.

I do not know whether to enable the exptoows. xla file in the C:/program files/Microsoft Web designer tools/office12/2052 path during import. But why do I only need to change the files in the C:/program files/Microsoft Office/office14/2052 path for the first time?

 

2. The second problem was found in a blog: cannot connect to the server at this time. Your table cannot be published

The reason for this problem is that the top site is not created. Generally, it is created when used, so the chance of encountering it is very low.

 

Reference: http://www.etechplanet.com/post/2008/11/26/How-to-import-an-Excel-SpreadSheet-in-SharePoint-and-save-it-as-a-Custom-List.aspx