Skip to main content

Hello, unfortunately I have repeatedly problem with exporting to Excel in Workspace. I checked log, there is following message: 2016-11-24 10:05:57| 67.6| 0.2|ERROR |Excel Writer: Failed to save changes to the spreadsheet 'D:\\XXX\\XXX\\XXX\\new.xlsx'. 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.'

It looks, that there is error on Excel side, right? I just want to create new Excel file...

Does the directory already exist? If not, create it manually.

Does the file exist? If yes, try to delete or rename it.


Another tip, check the task manager to see if the xls process is still running.


Does the directory already exist? If not, create it manually.

Does the file exist? If yes, try to delete or rename it.

Directory exists, there is not a problem. File doesnt exist. And Log still throws the same message...

 

 


Another tip, check the task manager to see if the xls process is still running.

Unfortunately - XLS process is not running and problem is still there...

 

 


That is a strange error. Have you tried rebooting?

Obligatory:


That is a strange error. Have you tried rebooting?

Obligatory:

Yep sounds like the workspace needs restarting since it's holding on to some old definition

 

 

via GIPHY

 

 


That is a strange error. Have you tried rebooting?

Obligatory:

Even when I reboot workbench, problem is still there 😞 I feel little bit hopeless

 

 


Even when I reboot workbench, problem is still there 😞 I feel little bit hopeless

 

 

Try rebooting your pc as well.

 

 


Try rebooting your pc as well.

 

 

Still the dame problem, even after rebooting my laptop 😞

 

 


Still the dame problem, even after rebooting my laptop 😞

 

 

Do you have any weird or accented characters in the path or filename? Can you create the file manually using Excel? How about changing or simplifying the filename, does that work?

@david_r path is ok, take a look: D:\\projekty_CS\\AC_SK\\dfsda.xlsx. There is no problem with characters or something else. I can create and save Excel (using MS Excel) without problem.


@david_r path is ok, take a look: D:\\projekty_CS\\AC_SK\\dfsda.xlsx. There is no problem with characters or something else. I can create and save Excel (using MS Excel) without problem.

Sounds like a case for Safe support to me.

 

 


I'd also suggest writing to CSV in the same place and make sure that works. Please do send in all the info to support@safe.com -- logs and workspaces -- and then we can examine.


Hi,

Just try in different path and file name.


Hi,

Just try in different path and file name.

That's what I was thinking. Maybe there is a permissions limitation to stop you writing to that directory. Try a different path and see if the error occurs (or write to CSV to the same folder as Dale suggests).

 

Also, are you running this on FME Server or FME Desktop? I'm guessing it's not Server, but if it was then that's a likely place to check too.

 


I have had this issue before as well. I have found that sometimes it won't overwrite the existing file if there is one. Also, I have seen this error pop up if you have excel open (not the specific file you are saving but excel itself). I either do one of the following.

1. You may have the file you are trying to save open. Close it and try again.

2. This sometimes occurs if the Microsoft Excel program is open. Close all instances of Microsoft Excel and try again.

3. If you are trying to overwrite a file and it is not open, try deleting or renaming the original export through windows explorer and try exporting the data again.


I have had this issue before as well. I have found that sometimes it won't overwrite the existing file if there is one. Also, I have seen this error pop up if you have excel open (not the specific file you are saving but excel itself). I either do one of the following.

1. You may have the file you are trying to save open. Close it and try again.

2. This sometimes occurs if the Microsoft Excel program is open. Close all instances of Microsoft Excel and try again.

3. If you are trying to overwrite a file and it is not open, try deleting or renaming the original export through windows explorer and try exporting the data again.

@gmbutler2 Thank You for tip! Problem is probably on my OS in laptop... Even if I try use your tricks, it fails... Anyway, I use exporting to CSV file and then I open it in Excel and save in xls.

 


I'd also suggest writing to CSV in the same place and make sure that works. Please do send in all the info to support@safe.com -- logs and workspaces -- and then we can examine.

@daleatsafe I have contacted my supplier of FME and we will try to solve this problem :-)

 


not writing tabs with spaces in tabnames? (feature_type) that will cause write-fail.


If the output network drive is not mapped, or you don’t have access to the output location, you will get that error.

 


Reply