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).
+20
- Contributor
- 564 replies
-
3 March 2023
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.
+20
- Contributor
- 564 replies
-
3 March 2023
After removing them in AttributeManager check to see if they get removed in the writer. If not, remove them manually.
I don't see them in the writers to begin with, is the odd thing.
Recreating indeed solves the problem, thanks! Only now have to do it for 10 different writers...
Userlevel 5
+29
- Celebrity
- 1109 replies
-
6 March 2023
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.