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
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
After removing them in AttributeManager check to see if they get removed in the writer. If not, remove them manually.
+54- Celebrity
laurentbruning wrote:
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?
hkingsbury wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.