my goal is to write result into single excel file,here is simple code :
import numpy_financial as npf
Present =2000
period =20
rate =0.12
pmt =abs(npf.pmt(rate/12,period*12,Present))
print(pmt)
import csv
file =open("Result.xlsx",'w')
file = csv.writer(file)
file.writerow([pmt])
as a outcome -Result.xlsx is created, but i can’t open, if i change xlsx extension to csv , then it works fine, i know , that there is another library called as xlsxwriter , but just for shake of curiosity , does csv module supports xlsx extensions? am i missing something?
>Solution :
No, the csv module does not support xlsx extensions. Here is a quote from the documentation I linked:
The csv module implements classes to read and write tabular data in
CSV format
The documentation does not mention support for writing xlsx.