Menu
I am looking for a python library or any help to convert .XLSX files to .CSV files.
912
Use the xlrd or openpyxl module to read xls or xlsx documents respectively, and the csv module to write. Alternately, if using Jython, you can use the Apache POI library to read either . xls or . xlsx , and the native CSV module will still be available.
Read your excel using the xlrd module and then you can use the csv module to create your own csv.
Install the xlrd module in your command line:
pip install xlrd
Python script:
import xlrd import csv def csv_from_excel(): wb = xlrd.open_workbook('excel.xlsx') sh = wb.sheet_by_name('Sheet1') your_csv_file = open('your_csv_file.csv', 'w') wr = csv.writer(your_csv_file, quoting=csv.QUOTE_ALL) for rownum in range(sh.nrows): wr.writerow(sh.row_values(rownum)) your_csv_file.close() # runs the csv_from_excel function: csv_from_excel() If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
