Browse By Tags

  • Excel.Workbook.Load exception

    I'm working with Infragistics3.Documents.Excel.v11.1
    I'm uploading excel files (excel 2007)
      Dim book As Infragistics.Documents.Excel.Workbook = Infragistics.Documents.Excel.Workbook.Load(filename) 
      
    When loading some files, shows the following error…

  • Excel Import failing using Infragistics35.WebUI.Excel.v10.3

    NetAdvantage 2010.3

    I have a form that currently uses the ACE (Access Control Engine) driver to select and cast data from and MS Excel file into a dataset; however I am having an issue with the data types being set incorrectly by the ACE driver, so it…

  • Worksheet Protection

    Running the following code will not protect my worksheet. Am I doing something wrong or is this a bug?

    Dim ms As New MemoryStream()
    Dim wb as new Workbook()

    wb.SetCurrentFormat(WorkbookFormat.Excel2007)
    wb.Worksheets.Add("TEST WORKSHEET")
    wb…