pip install xlwt xlrd
python
import xlrd
workbook = xlrd.open_workbook('example.xlsx')
sheet = workbook.sheet_by_index(0)
num_rows = sheet.nrows
num_cols = sheet.ncols
for i in range(num_rows):
row_data = sheet.row_values(i)
print(row_data)
python
data = [
]
python
import xlwt
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Sheet1')
for i in range(len(data)):
for j in range(len(data[i])):
sheet.write(i, j, data[i][j])
workbook.save('output.xlsx')
