Importing Files Using Angular.js and C#
<p>I am building an Umbraco7 Package and I'm at a bit of a standstill. I have very little experience with Angular and C# and what I'm trying to do is add an import option where a backoffice user can import an xls file and populate an existing database table with the xls contents.</p>

<p>This is what I have so far, I'm not sure how to get it to save the file in the firs place, let alone extract the values from the xls file.</p>

<p>HTML</p>

<pre><code>// This is the view (table.html)
// Excluding the export blank xls file table.

&lt;div class="import-div"&gt;
    &lt;input type="file" name="MyFile" /&gt;
    &lt;input type="submit" class="btn btn-danger" ng-click="ButtonClickHandler()" /&gt;
&lt;/div&gt;
</code></pre>

<p>Angular.Js Controller file</p>

<pre><code>// Here is my js controller file:

    angular.module("umbraco")
        .controller("ImportCtrl", function ($scope, keyResource) {
            $scope.ButtonClickHandler = function () {
                console.log("I was clicked!");
            };
        });
</code></pre>

<p>C# Controller</p>

<pre><code>    //This is the C# controller.

        using AngularUmbracoPackage.Models;
        using System;
        using System.Collections.Generic;
        using System.Linq;
        using System.Web.Mvc;
        using System.Web.Security;
        using umbraco.cms.businesslogic.member;
        using Umbraco.Web.Mvc;
        using Umbraco.Core.Persistence;
        using System.Configuration;
        using Umbraco.Core.Logging;
        using System.Data;
        using System.Text;
        using System.IO;
        using System.Web;
        using System.Net.Http;

        namespace AngularUmbracoPackage.App_Code
{

    [HttpPost]
    public class ImportNewDictionaryController
    {
        [HttpPost]
        public ActionResult importFile()
        {
             public string fileName;
        public string DictionaryKey;

        var db = UmbracoContext.Application.DatabaseContext.Database;
        var insert = new Sql("INSERT INTO cmsDictionary VALUES('" + DictionaryKey + "'");

        }


    }
}
</code></pre>

<p>Can anyone give me any links which may help or guide me through this?</p>