This utility allows user to Read Excel data and convert them to Kentico CMS Custom Table. The web part is featured with OpenXML and JSON.
Instructions for use
Add a reference to this assembly: 'WindowsBase, Version=220.127.116.11, Culture=neutral, PublicKeyToken=31bf3856ad364e35' into your web.config file.
Create new Media library & upload the Excel containing the sample Excel data into this library (sample Excel is attached in the download package).
Paste the "Read Excel To Custom Table" web part on a page.
Select the Excel file from Media Library
Click on Read Customer Information button, this would read and show records in the file.
Provide desired Custom Table display name, Namespace and Table name.
Click on Create Custom Table button.