Great tool to import data from Excel to a custom table.
It is rare case that someone would like to populate custom table data manually, especially if there is a huge amount of it. This web part comes to solve this problem. This flexible feature allows user to import data from Excel document to a custom table available in your application. It automatically maps Excel columns to custom table fields.
User should select some Excel file, specify sheet name to read data from and select custom table to import data to. Web part maps fields automatically, so column names in Excel should match fields code names as well as columns data type should match.
Please add reference for WindowsBase assembly into your web.config file:
<add assembly="WindowsBase, Version=220.127.116.11, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
It is used to read data from Excel, so no MS Office should be instaled to the server where data import is going to occur.
.NET 4.0 or higher is required