Problems with Excel Import/Export

[Boris]

With regard to this previous thread: http://www.telerik.com/forums/rad-grid-import-from-excel

2 things.

First, I've examined the code and I'm a bit confused.  I thought this technique only worked for XLS format, not the new XLSX.

Second, I have had an app up and running for some time now using that technique to import xls files without any problem. 

Now, suddenly I cannot perform this operation locally in Visual Studio.2012  (It was working fine during the original development)  It crashes: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

 As far I know this is part of the package Microsoft Access Database Engine 2010.  I have version 14 installed.

Suggestions?

 

[Boris]

My apologies.  Let's forget this.

It seems definite that my problems all stem from the installation of 64-bit Office 2013 on my current development machine.

[Karen]

Hi,

I'm trying to Export Telerik Grid to Excel by using code(SharePoint 2013):

using Telerik.Windows.Documents.Spreadsheet;
using Telerik.Windows.Documents.Spreadsheet.FormatProviders;
using Telerik.WinControls.Export;
using Telerik.Windows.Documents.Core;
using Telerik.Windows.Zip;
using Telerik.Web.UI.Export;
using Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml;
using Telerik.Windows.Documents.Spreadsheet.Model;
using Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx;
using Telerik.Windows.Documents.Fixed;

        protected void btnEportToXLS_Click(object sender, EventArgs e)
        {

            if (TicketsGrid.Items.Count > 0)
            {
                try
                {

                    TicketsGrid.Rebind();
                    TicketsGrid.ExportSettings.ExportOnlyData = true;
                    TicketsGrid.ExportSettings.IgnorePaging = true;
                    TicketsGrid.ExportSettings.OpenInNewWindow = true;
                    TicketsGrid.MasterTableView.UseAllDataFields = true;
                    TicketsGrid.ExportSettings.FileName = "C:\\ExcelFile.xlsx";// Guid.NewGuid().ToString();
                    TicketsGrid.MasterTableView.ExportToExcel();
                }
                catch (Exception exc)
                {

                }
            }

        }

        private GridItemType[] supportedItemTypes = new GridItemType[] 
        { 
            GridItemType.Header, 
            GridItemType.AlternatingItem, 
            GridItemType.Item 
        };

 

After executing the code getting exception:
Could not load file or assembly 'Telerik.Windows.Documents.Spreadsheet, Version=2016.1.106.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7' or one of its dependencies. The system cannot find the file specified.

Any suggestions please?