2

The following code allows me to save a text file with .xls extension in Python. When I open it, I receive the following warning:

The file you are trying to open, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

def saveExcel (layer,name):
  # get the path
  pathSave=getDirectoryPath()
  chdir(pathSave)
  filename=name+".xls"
  f=open(filename,"w")
  # Save fields'names
  for field in layer.fields():
    f.write(field.name()+ "\t")
  f.write("\n")
  # Save attributes
  for element in layer.getFeatures():
    for field in layer.fields():
      f.write(str(element.attribute(field.name()))+ "\t")
    f.write("\n")
  f.close()
2

1 Answer 1

7

If you are in QGIS environment you could make a QgsVectorLayer with your data and export that as xlsx:

QgsVectorFileWriter.writeAsVectorFormat(layer, path, "utf-8", layer.crs(), 'xlsx')
1
  • this command seems to not work any idea why? I have already made the QgsVectorLayer Jan 12, 2022 at 7:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.