Python convert csv to xlsx

by

Here’s an example using xlsxwriter:

import os
import glob
import csv
from xlsxwriter.workbook import Workbook


for csvfile in glob.glob(os.path.join('.', '*.csv')):
    workbook = Workbook(csvfile[:-4] + '.xlsx')
    worksheet = workbook.add_worksheet()
    with open(csvfile, 'rt', encoding='utf8') as f:
        reader = csv.reader(f)
        for r, row in enumerate(reader):
            for c, col in enumerate(row):
                worksheet.write(r, c, col)
    workbook.close()

FYI, there is also a package called openpyxl, that can read/write Excel 2007 xlsx/xlsm files.

Hope that helps.

More Related Contents:

  1. How do I create a python code that distinguishes between the capital of a state and the state that the capital has?
  2. Writing to an Excel spreadsheet
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. Writing a Python list of lists to a csv file
  5. Reading a huge .csv file
  6. How to write to a CSV line by line?
  7. How to write to an Excel spreadsheet using Python?
  8. xls to csv converter
  9. Error: Unsupported format, or corrupt file: Expected BOF record
  10. How can I see the formulas of an excel spreadsheet in pandas / python?
  11. How to read one single line of csv data in Python?
  12. IndexError: too many indices for array
  13. Python Pandas – Read csv file containing multiple tables
  14. Find all CSV files in a directory using Python
  15. Read random lines from huge CSV file
  16. Setting styles in Openpyxl
  17. How to save a dictionary to a file?
  18. Parse key value pairs in a text file
  19. Python : Compare two csv files and print out differences
  20. Fastest way to write huge data in file
  21. Reading integers from binary file in Python
  22. csv.writer writing each character of word in separate column/cell
  23. Calculate summary statistics of columns in dataframe
  24. Extract csv file specific columns to list in Python
  25. Python – re-ordering columns in a csv
  26. Python not able to open file with non-english characters in path
  27. UnicodeDecodeError when reading CSV file in Pandas
  28. How to upload a CSV file in FastAPI and convert it into JSON?
  29. ValueError: x and y must be the same size
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment