New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How to batch write multi rows and multi columns at one time? #58

Open

flyly0755 opened this issue Jun 28, 2024 · 0 comments

flyly0755 commented Jun 28, 2024

wb = Workbook()
ws = wb.active
data_list = [['name', 'age', 'gender'],['xxx', 20, 'M'],['yyy', 22, 'F'], ['zzz', 19, 'M'], ...]
# then how to write this data_list at one time like?
ws.write(start='A0', data=data_list)
# Save the file
wb.save("sample.xlsx")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment