Community | Tags

Browse By Tags

  • Workbook.Save() failed or sometimes takes more than day.

    Recently we have encountered this issue about exporting reports to excel file.

    Our report table contains more or less 1.26 million records as of now. We are trying to create an excel(2007) file for this, so approximately this would be a 2 worksheet file…

  • 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…

  • 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…