poplawaves.blogg.se

Create a COM object for everything that is referencedExcel.Workbook xlWorkbook = - Copy - Copy.xlsx") Excel._Worksheet xlWorksheet = xlWorkbook.Sheets //iterate over the rows and columns and print to the console as it appears in the fileIf (xlRange.Cells != null & xlRange.Cells.Value2 != null)Console.Write(xlRange.Cells.Value2.ToString() + "\t") //rule of thumb for releasing com objects:// never use two dots, all COM objects must be referenced and released individually// ex. //iterate over the rows and columns and print to the console as it appears in the file//Create COM Objects.