Excel reader code example

  """Example code using the sc-excel-reader library."""

  import platform
  import pprint
  import sys

  from sc_excel_reader import ExcelReader

  EXCEL_FILE = "examples/example_excel.xlsx"


  def main():
      print(f"Hello from sc-excel_reader example running on {platform.system()}")

      # Create an instance of ExcelReader
      print("Testing ExcelReader...")
      excel_reader = ExcelReader(EXCEL_FILE)

      # Extract a table
      try:
          table_data = excel_reader.extract_data(source_name="Table1", source_type="table")
      except ImportError as e:
          print(f"Error extracting table: {e}")
          sys.exit(1)
      else:
          print("\nTable data extracted successfully:")
          pprint.pprint(table_data)

      # Extract a range
      try:
          range_data = excel_reader.extract_data(source_name="RangeTable1", source_type="range")
      except ImportError as e:
          print(f"Error extracting range: {e}")
          sys.exit(1)
      else:
          print("\nRange data extracted successfully:")
          pprint.pprint(range_data)

      # Extract a worksheet
      try:
          sheet_data = excel_reader.extract_data(source_name="Sheet", source_type="sheet")
      except ImportError as e:
          print(f"Error extracting sheet: {e}")
          sys.exit(1)
      else:
          print("\nWorksheet data extracted successfully:")
          pprint.pprint(sheet_data)


  if __name__ == "__main__":
      main()