Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
U

User 7628281

@User 7628281
About
Posts
1
Topics
0
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • How to check if Excel-workbook is empty?
    U User 7628281

    WorkSheets = all your Worksheets private void deleteUnUsedWorksheets() { foreach (Excel._Worksheet sheet in WorkSheets) { if (IsWorkbookEmpty(sheet)) sheet.Delete(); } } private bool IsWorkbookEmpty(Excel._Worksheet sheet) { ExcelRange = sheet.UsedRange; if (ExcelRange.Columns.Count > 1 | ExcelRange.Rows.Count > 1 | ExcelRange.Count > 1) return false; else return true; } You dont have to check each cell. Its senseless and you throw a lot of memory Don`t throw a catch if its only a return false!

    C# question com testing tools tutorial
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups