Skip to main content
Solved

Failure of the XLSX writer when exporting

  • August 8, 2017
  • 6 replies
  • 83 views
arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • Contributor
  • 101 replies

Hi,

I'm trying to export my data to excel. My workbench was working fine and suddenly I can't even run it.

I'm having the following error and I don't know what could be the issue.

I restart my computer and I close all the excel files on my computer but the issue persists.

XLSX Writer: Saving changes to dataset 'folder_name'
XLSX Writer: Failed to save changes to the spreadsheet 'folder_name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'

A fatal error has occurred. Check the logfile above for details

... Last line repeated 2 times ...

Note that folder_name is the localisation path where I want to export the data.

Thanks

Best answer by courtney_m

Okay, thanks. The error message says it is trying to write a spreadsheet called 'folder_name' - make sure your output excel file path points to a file and not a directory. Would you be willing to upload your workspace, please, so I can get more information?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

6 replies

courtney_m
Contributor
Forum|alt.badge.img+19
  • courtney_mContributor
  • Contributor
  • 127 replies
  • August 8, 2017

In Windows Explorer, right-click on the folder you are trying to write to, and select properties. Is "Read-only" checked?

arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • Author
  • Contributor
  • 101 replies
  • August 8, 2017

I I checked that under security and I have the rigth to read and write in the folder.

 

Before the excel writer, I even added a python caller and inside the python, I try to copy a file to that folder and it worked
courtney_m
Contributor
Forum|alt.badge.img+19
  • courtney_mContributor
  • Contributor
  • 127 replies
  • Best Answer
  • August 8, 2017
Okay, thanks. The error message says it is trying to write a spreadsheet called 'folder_name' - make sure your output excel file path points to a file and not a directory. Would you be willing to upload your workspace, please, so I can get more information?
courtney_m
Contributor
Forum|alt.badge.img+19
  • courtney_mContributor
  • Contributor
  • 127 replies
  • August 8, 2017

I I checked that under security and I have the rigth to read and write in the folder.

 

Before the excel writer, I even added a python caller and inside the python, I try to copy a file to that folder and it worked
Okay, thanks. The error message says it is trying to write a spreadsheet called 'folder_name' - make sure your output excel file path points to a file and not a directory. Would you be willing to upload your workspace, please, so I can get more information?
arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • Author
  • Contributor
  • 101 replies
  • August 8, 2017
Okay, thanks. The error message says it is trying to write a spreadsheet called 'folder_name' - make sure your output excel file path points to a file and not a directory. Would you be willing to upload your workspace, please, so I can get more information?
You are right.

 

I scripted the folder name and there was a misspelling.

 

Thanks again for your help.

 

I really appreciate

 

 

courtney_m
Contributor
Forum|alt.badge.img+19
  • courtney_mContributor
  • Contributor
  • 127 replies
  • August 8, 2017
You are right.

 

I scripted the folder name and there was a misspelling.

 

Thanks again for your help.

 

I really appreciate

 

 

You're welcome. I'm glad that worked!

 

 

Community Stats

32,058
Posts
121,723
Replies
39,686
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.