Guest User

Untitled

a guest
Jan 30th, 2025
22
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. new_worksheet = spreadsheet.add_worksheet(title=f"Program results: {today_date}", rows=100, cols=30)
  2. ...Inserting data into worksheet code...
  3. merge_request = [
  4. {
  5. "range": table_formatter.a1_range_to_grid_range("A1:M1", new_worksheet),
  6. "mergeType": table_formatter.MergeType.merge_rows,
  7. },
  8. {
  9. "range": table_formatter.a1_range_to_grid_range("N1:R1", new_worksheet),
  10. "mergeType": table_formatter.MergeType.merge_rows,
  11. },
  12. {
  13. "range": table_formatter.a1_range_to_grid_range("S1:Y1", new_worksheet),
  14. "mergeType": table_formatter.MergeType.merge_rows,
  15. },
  16. {
  17. "range": table_formatter.a1_range_to_grid_range("B2:C2", new_worksheet),
  18. "mergeType": table_formatter.MergeType.merge_rows,
  19. },
  20. {
  21. "range": table_formatter.a1_range_to_grid_range("D2:H2", new_worksheet),
  22. "mergeType": table_formatter.MergeType.merge_rows,
  23. },
  24. {
  25. "range": table_formatter.a1_range_to_grid_range("I2:M2", new_worksheet),
  26. "mergeType": table_formatter.MergeType.merge_rows,
  27. }
  28. ]
  29. new_worksheet.batch_merge(merge_request)
  30.  
Advertisement
Add Comment
Please, Sign In to add comment