I haven't changed anything to these Excel writers, but after having added some transformers to the workspace they suddenly all start writing to column E instead of A. Even after having disabled the new transformers they still do that. I can't find any setting explaining this (I haven't set a start column, for instance).
+23- Contributor
- 571 replies
Are you using a template .xlsx file in the writer?
Does your data have an xlsx_col_id attribute?
Do the first four attributes you are writing maybe have missing or empty values?
The records are being added to an existing Excel file.
Â
Interestingly, there are four new extra attributes in an attribute manager preceding the writer, but I have the Action set to Remove for those. I wonder if that can have anything to do with it.
Â
There is no xlsx_col_id attribute.
+23- Contributor
- 571 replies
After removing them in AttributeManager check to see if they get removed in the writer. If not, remove them manually.
+63- Celebrity
- 1620 replies
Recreating indeed solves the problem, thanks! Only now have to do it for 10 different writers...
Is your writer attribute definition set to Automatic or Manual?
Is your writer attribute definition set to Automatic or Manual?
I always switched it briefly to automatic to get the right attributes and then switch it back to manual, to be able to edit them if necessary.