CODEWITHSUNDEEP
pythonexceltxt
Mike B.
Mike B.

Reputation: 1

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

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

(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\rep\LX02.txt'

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

wb = openpyxl.Workbook()

ws = wb.worksheets[0]

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

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

for row in reader:

    ws.append(row)

wb.save(output_file)

Upvotes: 0

Views: 873

Answers (1)

Timeless
Timeless

Reputation: 37827

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)

enter image description here

Upvotes: 0

Related Questions