title: Print just the sheetnames with Python
body: <p>How can I print just the sheet names. I using a loop that gets the sheets from range 2 to 9 and prints but I would like to remove the label around it and just print the name of the sheet.</p>
  
  <pre><code>import glob
  import openpyxl
  
  path = 'C:/ExcelFolder/*.xlsx'
  files = glob.glob(path)
  
  for file in files:
  wb = openpyxl.load_workbook(file)
  
  for n in range(2, 9):
      SheetName = wb.worksheets[n]
      print(SheetName)
  </code></pre>
  
  <p>Output example:</p>
  
  <pre><code>&lt;Worksheet "Monday"&gt;
  &lt;Worksheet "Tuesday"&gt;
  &lt;Worksheet "Wednesday"&gt;
  &lt;Worksheet "Thursday"&gt;
  &lt;Worksheet "Friday"&gt;
  &lt;Worksheet "Saturday"&gt;
  </code></pre>