print_labels_from_csv.py 685 B

123456789101112131415161718192021
  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. medir = os.path.dirname(__file__)
  6. example_data_path = os.path.join(medir, 'labels.csv')
  7. df = pd.read_csv(example_data_path, converters={i: str for i in range(3)})
  8. printer = ql_wrapper.BrotherQlPrinter(model='QL-800', printer_connection='usb://0x04f9:0x209b')
  9. for _, row in df.iterrows():
  10. label = li.MiceToiletLabel()
  11. label.put_text(row['Heading'], row['Line1'], row['Line2'])
  12. file_path = label.save()
  13. cut = False
  14. if row['Cut'] == 1:
  15. cut = True
  16. printer.print_image(file_path, cut = cut, rotation=270)
  17. os.remove(file_path)