Showing posts with label Convert csv to xlsx as openpyxl does not support .csv file format. Show all posts
Showing posts with label Convert csv to xlsx as openpyxl does not support .csv file format. Show all posts

Saturday, June 10, 2023

Convert csv to xlsx as openpyxl does not support .csv file format


import csv
from openpyxl import Workbook

wb = Workbook()
ws = wb.worksheets[0]
ws.title = "zomato"

with open(r'C:\Users\allso\Desktop\new vba projects\openpyxl\zomato.csv',encoding='cp437', errors='ignore') as f:
    reader = csv.reader(f)
    for row_index, row in enumerate(reader):
        for column_index, cell in enumerate(row):
            column_letter = column_index + 1
            cell_value = cell.replace('"', '')
            ws.cell(row = row_index + 1, column = column_letter).value = cell_value



wb.save(filename = r'C:\Users\allso\Desktop\new vba projects\openpyxl\zomato.xlsx')