ValueError: No engine for filetype: 'xlsk' [closed]

Question

from datetime import datetime
x="Hello, it is now %s." % datetime.now().strftime('%d-%m-%Y %H:%M:%S')
import csv
try:
    with open('output.csv', 'w+') as csvFile:
        writer=csv.writer(csvFile)
        writer.writerow(x.encode('UTF-8'))
        print(x.encode('UTF-8'))
finally:
    csvFile.close()
import pandas as pd
data = pd.read_csv('output.csv')
data.to_excel('output.xlsk')

Is this office365 problem? or my code

environment:windows10

Sackman

there is not such format xlsk – Backbreaker

Yeah you want xlsx, not xlsk – Mcalpine

I did mistake.. – Sackman

Answer 1

Your title answers the question. There is no such excel file format as '.xlsk'. Perhaps you meant

data.to_excel('output.xlsx')

?

Bonsai

Answer 2

As mentioned by @osprey, the file output for excel files are generally xlsx.

However,

pandas relies on a package called openpyxl

(an engine to read/write Excel 2010 xlsx/xlsm/xltx/xltm files)

to write pandas dataframes to excel files. Make sure to install this before writing out your data.

Pickard

Answer 3

simply try

df.to_csv("output.csv")

Surah

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review – Bautzen

I was getting same error and i converted this --data.to_excel('output.xlsk')-- to this ---df.to_csv("output.csv")-- is got my desired output, – Surah

Answer 4

You should use the file extension when mentioning the file name. In this case for Excel File the extension would be .xlsx so with the correction it will be data.to_excel('output.xlsx')

Mot