Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- new_worksheet = spreadsheet.add_worksheet(title=f"Program results: {today_date}", rows=100, cols=30)
- ...Inserting data into worksheet code...
- merge_request = [
- {
- "range": table_formatter.a1_range_to_grid_range("A1:M1", new_worksheet),
- "mergeType": table_formatter.MergeType.merge_rows,
- },
- {
- "range": table_formatter.a1_range_to_grid_range("N1:R1", new_worksheet),
- "mergeType": table_formatter.MergeType.merge_rows,
- },
- {
- "range": table_formatter.a1_range_to_grid_range("S1:Y1", new_worksheet),
- "mergeType": table_formatter.MergeType.merge_rows,
- },
- {
- "range": table_formatter.a1_range_to_grid_range("B2:C2", new_worksheet),
- "mergeType": table_formatter.MergeType.merge_rows,
- },
- {
- "range": table_formatter.a1_range_to_grid_range("D2:H2", new_worksheet),
- "mergeType": table_formatter.MergeType.merge_rows,
- },
- {
- "range": table_formatter.a1_range_to_grid_range("I2:M2", new_worksheet),
- "mergeType": table_formatter.MergeType.merge_rows,
- }
- ]
- new_worksheet.batch_merge(merge_request)
Advertisement
Add Comment
Please, Sign In to add comment