print_labels_from_csv.py 769 B

1234567891011121314151617181920212223242526
  1. import pandas as pd
  2. import shimatta_label.label_image as li
  3. import shimatta_label.brother_ql_wrapper as ql_wrapper
  4. import os
  5. import sys
  6. medir = os.path.dirname(__file__)
  7. if len(sys.argv) > 2:
  8. example_data_path = sys.argv[1]
  9. else:
  10. example_data_path = os.path.join(medir, 'labels.csv')
  11. df = pd.read_csv(example_data_path, converters={i: str for i in range(3)})
  12. printer = ql_wrapper.BrotherQlPrinter(model='QL-800', printer_connection='usb://0x04f9:0x209b')
  13. for _, row in df.iterrows():
  14. label = li.MiceToiletLabel()
  15. label.put_text(row['Heading'], row['Line1'], row['Line2'])
  16. file_path = label.save()
  17. cut = False
  18. if row['Cut'] == 1:
  19. cut = True
  20. printer.print_image(file_path, cut = cut, rotation=270)
  21. os.remove(file_path)