이번 시간에는 Insert Column activity, Insert Rows activity activity를 python 코드로 구현해보는 시간을 가져보자.
(Insert Column activity, Insert Rows activity activity 알아보기)
def insert_column(file_name: str, sheet_name: [str, int], start_position: [str, int], insert_column_value: [str ,list]):
wb = load_workbook(file_name)
ws = wb[sheet_name]
pattern = r'[a-z A-Z]+'
result = re.findall(pattern, start_position)
alphabet = result[0]
pattern = r'\d+'
result = re.findall(pattern, start_position)
number = int(result[0])
start_column = column_index_from_string(alphabet)
if type(insert_column_value) == list:
ws.insert_cols(start_column, amount=len(insert_column_value))
for column_value in insert_column_value:
ws.cell(row=number, column=start_column, value=column_value)
start_column += 1
else:
ws.insert_cols(start_column)
ws.cell(row=number, column=start_column, value=insert_column_value)
wb.save(file_name)
def insert_column(file_name: str, sheet_name: [str, int], start_position: [str, int], insert_column_value: [str ,list]):
wb = load_workbook(file_name)
ws = wb[sheet_name]
pattern = r'[a-z A-Z]+'
result = re.findall(pattern, start_position)
alphabet = result[0]
pattern = r'\d+'
result = re.findall(pattern, start_position)
number = int(result[0])
start_column = column_index_from_string(alphabet)
if type(insert_column_value) == list:
ws.insert_cols(start_column, amount=len(insert_column_value))
for column_value in insert_column_value:
ws.cell(row=number, column=start_column, value=column_value)
start_column += 1
else:
ws.insert_cols(start_column)
ws.cell(row=number, column=start_column, value=insert_column_value)
wb.save(file_name)
def insert_row(file_name: str, sheet_name: [str, int], start_row: int, num_rows_to_insert: int):
wb = load_workbook(file_name)
ws = wb[sheet_name]
ws.insert_rows(start_row, amount=num_rows_to_insert)
wb.save(file_name)
def insert_row(file_name: str, sheet_name: [str, int], start_row: int, num_rows_to_insert: int):
wb = load_workbook(file_name)
ws = wb[sheet_name]
ws.insert_rows(start_row, amount=num_rows_to_insert)
wb.save(file_name)