Python convert csv to xlsx

Question

In this post there is a Python example to convert from csv to xls   However  my file has more than 65536 rows so xls does not work  If I name the file xlsx it doesnt make a difference  Is there a Python package to convert to xlsx

User · Answer

With my library pyexcel       pip install pyexcel pyexcel-xlsx   you can do it in one command line   from pyexcel cookbook import merge all to a book   import pyexcel ext xlsx   no longer required if you use pyexcel  gt   0 2 2  import glob   merge all to a book glob glob  your csv directory   csv     output xlsx     Each csv will have its own sheet and the name will be their file name

User · Answer

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

User · Answer

Adding an answer that exclusively uses the pandas library to read in a  csv file and save as a  xlsx file   This example makes use of pandas read csv  Link to docs  and pandas dataframe to excel  Link to docs      The fully reproducible example uses numpy to generate random numbers only  and this can be removed if you would like to use your own  csv file    import pandas as pd import numpy as np    Creating a dataframe and saving as test csv in current directory df   pd DataFrame np random randn 100000  3   columns list  ABC    df to csv  test csv   index   False     Reading in test csv and saving as test xlsx  df new   pd read csv  test csv   writer   pd ExcelWriter  test xlsx   df new to excel writer  index   False  writer save

User · Answer

First install openpyxl   pip install openpyxl   Then   from openpyxl import Workbook import csv   wb   Workbook   ws   wb active with open  test csv    r   as f      for row in csv reader f           ws append row  wb save  name xlsx

User · Answer

How I do it with openpyxl lib   import csv from openpyxl import Workbook  def convert csv to xlsx self       wb   Workbook       sheet   wb active      CSV SEPARATOR            with open  my file csv   as f          reader   csv reader f          for r  row in enumerate reader               for c  col in enumerate row                   for idx  val in enumerate col split CSV SEPARATOR                        cell   sheet cell row r 1  column idx 1                      cell value   val      wb save  my file xlsx

User · Answer

Simple 1-to-1 CSV to XLSX file conversion without enumerating looping through the rows    import pyexcel  sheet   pyexcel get sheet file name  myFile csv   delimiter      sheet save as  myFile xlsx     Notes    I have found that if the file name is really long   30 characters excluding path  then the resultant XLSX file will throw an error when Excel tries to load it  Excel will offer to fix the error which it does  but it is frustrating  There is a great answer previously provided that combines all of the CSV files in a directory into one XLSX workbook  which fits a different use case than just trying to do a 1-to-1 CSV file to  XLSX file conversion

User · Answer

There is a simple way  import os import csv import sys  from openpyxl import Workbook  reload sys  sys setdefaultencoding  utf8    if   name         main         workbook   Workbook       worksheet   workbook active     with open  input csv    r   as f          reader   csv reader f          for r  row in enumerate reader               for c  col in enumerate row                   for idx  val in enumerate col split                            cell   worksheet cell row r 1  column c 1                      cell value   val     workbook save  output xlsx

User · Answer

Simple two line code solution using pandas    import pandas as pd    read file   pd read csv   File name csv     read file to excel   File name xlsx   index   None  header True

[python] Python convert csv to xlsx

Examples related to python

Examples related to excel

Examples related to file

Examples related to csv

Examples related to xlsx