Sep-03-2022, 03:47 AM
import glob import os import csv import xlsxwriter files = glob.glob(r'C:\Users\Sam\OneDrive\Desktop\python_demo\*.csv') workbook = xlsxwriter.Workbook(r'C:\Users\Sam\OneDrive\Desktop\python_demo\Log.xlsx') row_numer = 0 for file_path in files: file = open(file_path) csvreader = csv.reader(file) file_name = os.path.basename(file_path) file_no_ext = os.path.splitext(file_name)[0] worksheet1 = workbook.add_worksheet(file_no_ext) row_numer = 0 for row in csvreader: for index in range(len(row)): worksheet1.write(row_numer, index, row[index]) row_numer += 1 file.close() workbook.close() import csv import openpyxl def csv_to_excel(csv_filename, excel_filename): # Read CSV file csv_data = [] with open(csv_filename) as f: csv_data = [row for row in csv.reader(f)] # Write to Excel file workbook = openpyxl.workbook.Workbook() worksheet = workbook.active for row in csv_data: worksheet.append(row) workbook.save(excel_filename) if __name__ == "__main__": csv_to_excel("Log.csv", "Log.xlsx")Tried two ways to converted from .csv to 。xlsx.content format is string,but save as .xlsx by manual format keep it.