Cannot create an instance of Excel 2016 in Visual Studio 2015

Instead of Microsoft.Office.Interop.Excel.Application library i recommend you to use more lithely configurable and stable library EPPlus. It works much times faster than reflection-based COM hell-library, and it can be installed through nuget.

Had to mention, that EPPlus supports only xlsx file format, and if you need to work with older xls-file formats, you can use library CSharpJExcel, that works without COM, for reading your xls files and then save them as xlsx through EPPlus.

Such convertion from xls to xlsx can looks like:

// Reading xls-file data with CSharpJExcel

var cellsData = new List<List<string>>();

var book = Workbook.getWorkbook(new FileInfo(fileName));
var dataSheet = book.getSheet(0);

// Loop over rows and fill collection with data
for (int r = 0; r < dataSheet.getRows(); r++)
{
    var dataRow = new List<string>();

    // Loop over columns  
    for (int c = 0; c < dataSheet.getColumns(); c++)
    {
        var cellValue = dataSheet.getCell(c, r).getContents();
        dataRow.Add(cellValue);
    }

    cellsData.Add(dataRow);
}


// Saving data to xlsx file with EPPlus
using (var xls = new ExcelPackage(new FileInfo(path + ".xlsx")))
{
    var sheet = xls.Workbook.Worksheets.Add("test");

    int row = 1;
    foreach (var cellsRow in cellsData)
    {
        int col = 1;

        // Some data processing logic...

        foreach (var cellData in cellsRow)
        {
            sheet.Cells[row, col].Value = cellData;

            ++col;
        }
        ++row;
    }

    xls.Save();
}