Skip to main content
Solved

Error writing to Excel using Feature Writer

  • November 21, 2023
  • 5 replies
  • 201 views

lorenrouth
Contributor
Forum|alt.badge.img+8

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

 

 

Best answer by lorenrouth

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

View original
Did this help you find an answer to your question?

5 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • November 25, 2023

Hi @lorenrouth​ 

 

Please, could you share your Workspace and log file?

 

 

Thanks in Advance,

danilo


lorenrouth
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 25, 2023

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​ 


lorenrouth
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 25, 2023
lorenrouth wrote:

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.


lorenrouth
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 25, 2023
lorenrouth wrote:

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?

 


lorenrouth
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • Best Answer
  • November 27, 2023

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


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