Import excel with path to RadSpreadsheet

1 posts, 0 answers
  1. jose
    jose avatar
    1 posts
    Member since:
    Jun 2017

    Posted 27 Jun 2017 Link to this post

    Hi, I'm trying to bind between an excel file and the RadSpreadsheet control using what I checked in your forums.
    The code I use and does not work is:
         Dim formatProvider As Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider = New Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider
                            Using input As Stream = New FileStream(filePath, FileMode.Open)
                                RadSpreadsheet1.Sheets.AddRange(Telerik.Web.Spreadsheet.Workbook.FromDocument(formatProvider.Import(input)).Sheets)  
                            End Using

    In the UI part
      </div>
            <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1">
    <div>


    The version of the spreadsheet is 2016.2.421.40 and telerik web.UI 2016.2.504.40.
    I'm trying to get this code working in chrome.
Back to Top