PDF

コメント

1. ikoi より:

   2023-02-01 10:05 PM

   filename1 = “C:/Labo/sheetfile5.xlsx”

   wb = load_workbook(filename)

   ws = wb.worksheets[0]

   for row in ws.rows:
   for cell in row:
   print(cell)
   #print(cell.border._StyleProxy__target)
   #print(“here”)
   print(cell.border.bottom)

   返信
2. ikoi より:

   2023-02-01 10:34 PM

   from openpyxl import load_workbook

   filename = “C:/Labo/sheetfile4.xlsx”

   wb = load_workbook(filename)

   ws = wb.worksheets[0]

   for row in ws.rows:
   for cell in row:
   print(cell.border.top.style)
   print(cell.border.bottom.style)
   print(cell.border.left.style)
   print(cell.border.right.style)

   返信
3. ikoi より:

   2023-02-02 10:37 PM

   import openpyxl
   from copy import copy

   filename = “C:/Labo/sheetfile4.xlsx”
   filename2 = “C:/Labo/sheetfile5.xlsx”

   wb1 = openpyxl.load_workbook(filename)
   ws = wb1.worksheets[0]

   ws.insert_rows(4)

   i = 1

   for row in ws.iter_rows():
   for cell in row:
   if cell.row == 3:
   ws.cell(row=4, column=i).border = copy(cell.border)
   i = i + 1

   wb1.save(filename2)

   返信