Skip to main content
Solved

Failure of the XLSX writer when exporting

arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • Contributor

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?
View original
Did this help you find an answer to your question?

6 replies

courtney_m
Contributor
Forum|alt.badge.img+5
  • courtney_mContributor
  • Contributor
  • 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
  • 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+5
  • courtney_mContributor
  • Contributor
  • 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+5
  • courtney_mContributor
  • Contributor
  • August 8, 2017
arthy wrote:

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
  • August 8, 2017
courtney_m wrote:
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+5
  • courtney_mContributor
  • Contributor
  • August 8, 2017
arthy wrote:
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!

 

 

Reply


Helpful Members This Week

Community Stats

30,896
Posts
117,088
Replies
38,701
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.