Skip to main content
  • EN

I have been getting this error a lot:

 

Excel Writer: Failed to open the dataset 'FILEPATH\\FILENAME.xlsx'. Error message was 'No such file or directory.'

XLSXW writer: An error has occurred. Check the logfile above for details

Excel Writer: Dataset 'FILEPATH\\FILENAME.xlsx' contains no data and is therefore not a valid Excel file. No file will be created

XLSXW writer: An error has occurred. Check the logfile above for details

 

It will happen a few times and then the workspace will run as normal. This occurs in any Workspace I use that has an Excel Writer. In the Task Manager, if there was a process I could end, I would do that. It still happens.

 

Any Ideas?

Thanks,

-Loren

 

 

Hi @lorenrouth​ 

 

Please, could you share your Workspace and log file?

 

 

Thanks in Advance,

danilo

Hi @danilo_fme​ ,

Thanks for getting back to me. Here is a log file I just generated. Before I send you a Workspace, have you ever had an error message like this?

If so, did it turn out to be FME, or Excel?

Best,

@lorenrouth​ 

Hi @danilo_fme​ ,

Thanks for getting back to me. Here is a log file I just generated. Before I send you a Workspace, have you ever had an error message like this?

If so, did it turn out to be FME, or Excel?

Best,

@lorenrouth​ 

Here is the log file.

Here is the log file.

Here is a log file of the same workspace, but it processed fine.  What I think needs to be looked at is this part in the log that errored:

2023-11-25 13:39:01|  45.7|  0.1|INFORM|Excel Writer: Deleted existing destination file 'C:\Users\LorenERouth\Documents\CADtoBIM\CA0295\CA0295_11252023b.xlsx'
2023-11-25 13:39:01|  45.7|  0.0|INFORM|Excel Writer: Opening dataset 'C:\Users\LorenERouth\Documents\CADtoBIM\CA0295\CA0295_11252023b.xlsx'...
2023-11-25 13:39:01|  45.7|  0.0|ERROR |Excel Writer: Failed to open the dataset 'C:\Users\LorenERouth\Documents\CADtoBIM\CA0295\CA0295_11252023b.xlsx'.  Error message was 'No such file or directory.'
2023-11-25 13:39:01|  45.7|  0.0|ERROR |XLSXW writer: An error has occurred. Check the logfile above for details
2023-11-25 13:39:01|  45.7|  0.0|INFORM|Excel Writer: Saving changes to dataset 'C:\Users\LorenERouth\Documents\CADtoBIM\CA0295\CA0295_11252023b.xlsx'
2023-11-25 13:39:01|  45.7|  0.0|INFORM|Excel Writer: Workbook contains 5 fonts and 21 cell formats after writing
2023-11-25 13:39:01|  45.7|  0.0|ERROR |Excel Writer: Dataset 'C:\Users\LorenERouth\Documents\CADtoBIM\CA0295\CA0295_11252023b.xlsx' contains no data and is therefore not a valid Excel file. No file will be created
2023-11-25 13:39:01|  45.7|  0.0|ERROR |XLSXW writer: An error has occurred. Check the logfile above for details
2023-11-25 13:39:01|  45.9|  0.2|INFORM|Translation FAILED with 4 error(s) and 82 warning(s) (0 feature(s) output)

On the run that errored, it deleted the Excel file instead of just overwriting.  The run that had no error does not show deleting the file.  So my question is:  Why does it sometimes delete the existing Excel file instead of overwriting?

 

I just took a look at the known issues for FME Form, and... it was fixed in v2023.01! Unfortunately, I currently have v2023.0.01, but will be upgrading soon.

 

-L

 

FMEENGINE-78316

Excel Writer currently deletes the existing file, when 'overwrite existing' is enabled in the writer parameters. Workaround: Disable overwrite existing file.

2022.2.6

Resolved in 2023.0.1

Reply


Community Stats

30,627
Posts
116,051
Replies
38,261
Members
Terms & ConditionsCookie 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.