12 lines
397 B
Python
12 lines
397 B
Python
import openpyxl
|
|
import csv
|
|
import sys
|
|
|
|
workbook = openpyxl.load_workbook(sys.argv[1])
|
|
|
|
for sheet_name in workbook.sheetnames:
|
|
sheet = workbook[sheet_name]
|
|
with open(f'{sys.argv[2]}{sheet_name}.tsv', 'w', newline='') as csvfile:
|
|
writer = csv.writer(csvfile, delimiter='\t', lineterminator='\n')
|
|
for row in sheet.iter_rows(values_only=True):
|
|
writer.writerow(row)
|