Hi, I don't seem to get column width in Excel writer to work with a number other than zero. Too big a number gives an error, zero works to adjust the width to cell contents, but it does net seem to react to smaller numbers. Does anybody have an idea?
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@amk Can you attach a small example? A small workspace that reproduces the issue and any sample data.
Hi Safer,
Thank you for looking into it. Can only see 1 file attached? Tell me if you need the Excel.
@amk without the example data it's hard to tell what the problem is. But I think the issue is that you have your attribute concatenation in parallel instead of in series. So in your workspace you'll get alternate rows of APIvijfhonderd & APIduizend values, instead of the values on the same row. So you workspace probably should look something like:
have disabled the parts that I think are redundant. I've also illustrated how you might replace the StringConcatenator with Text Editor in the AtributeManager
If I've misinterpreted your issue, please include a sample dataset and an example of the output data you need.
Hi Safer,
I see how you make my workspace simpeler, but the outcome does not seem to change, and the columns still have the same width. I don't understand what you mean with parallel or series. Have included the input file. Hope you can help set the column widths to a different value.
Hi Safer,
I see how you make my workspace simpeler, but the outcome does not seem to change, and the columns still have the same width. I don't understand what you mean with parallel or series. Have included the input file. Hope you can help set the column widths to a different value.
@amk without any sample data I can't actually run the workspace. My workspace was just some ideas that you might take into consideration.
@amk without any sample data I can't actually run the workspace. My workspace was just some ideas that you might take into consideration.
@Mark Stoakes Can I attach more than 1 file at a time?
@amk without any sample data I can't actually run the workspace. My workspace was just some ideas that you might take into consideration.
I think you can attach a zip file that contains several files.
Hi @Mark Stoakes , try to upload a file, but it locks Chrome. Just updated laptop. But with workspace, input and output as above, you have all the files.
Hi @Mark Stoakes , try to upload a file, but it locks Chrome. Just updated laptop. But with workspace, input and output as above, you have all the files.
@amk Those are images you have attached so they can't be used as source data for the Excel reader. However, I have simulated the input using the RandomNumberGenerator. I've attached the example workspace as well as the results (zip file). I hope this helps.
Parallel vs Series. we we refer to transformers in series, the are connected one after the other. In parallel, the connectors branch and the converge.
when transformers are in parallel, you'll be making copies or clones of each record - check the feature counts
@Mark Stoakes I'm sorry, don't know how it became pictures when uplloading. Seem to have some issues with laptop, cannot open or upload zip (and other). Hope service desk of work can solve my problems tomorrow.