I receive an error when I try to read and write to the same excel file, is there something that I'm missing?
Userlevel 3
+18
- Enthusiast
- 97 replies
-
26 June 2020
hi @rocky12, i've done this before by reading the excelfile and using the same file as a template for the (new) file i write, maybe this helps?
+7
- Contributor
- 95 replies
-
27 June 2020
Hi @rocky12,
It sounds like the excel file is still open for reading when FME attempts to start writing to the same file. One thing you could try is to place a FeatureHolder immediately before the Writer to delay the writing operation enough to finish the reading operation. If that's not quite enough you could also add a Decellerator (probably only a fraction of a second may be required here) before the FeatureHolder to add a further delay.
+2
You most likely have the sheet open in Excel and it's generating a sharing violation.
I typically use a split access database. Access hosts the tables and excel displays through a database connection. It makes it easy to load data and avoids locking.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.