How to copy data from txt file and paste to XLSX as value with Python?

Question

(txt)File: simple.txt which contains date,name,qty,order id I need the data from txt and copy paste to xlsx as VALUE.

How it's possible it? Which package could handle this process with Python? openpyxl?Panda? Could you please give an example code?

My code which not suitable for the paste and save as values:

import csv

import openpyxl

input_file = 'C:\Users\mike\Documents ep\LX02.txt'

output_file = 'C:\Users\mike\Documents ep\LX02.xlsx'

wb = openpyxl.Workbook()

ws = wb.worksheets[0]

with open(input_file, 'r') as data:

reader = csv.reader(data, delimiter='	')

for row in reader:

    ws.append(row)

wb.save(output_file)

abokey · Answer

In pandas, with pandas.read_csv and pandas.DataFrame.to_excel combined, you can store the content of a comma delimited .txt file in an .xlsx spreedsheet by running the code below :

#pip install pandas
import pandas as pd

input_file = r'C:\Users\mbalog\Documents\FGI\LX02.txt'
output_file = r'C:\Users\mbalog\Documents\FGI\LX02.xlsx'

pd.read_csv(input_file).to_excel(output_file, index=False)

How to copy data from txt file and paste to XLSX as value with Python?

1 Answers