tFileOutputExcel with xlsx problem

Hello,

I have a problem with the writing of some tables into xlsx format by the tFileOutputExcel component.

Generally it works, but the empty cells that should also be contained in the Output-table are not there. But, all the following values in the raws are skipped left into the gaps of the missed empty cells. The result of this is useless, because a lot of values are in the wrong columns.

I did the same in normal xls format and there it works fine. But, I need them in xlsx format and don`t want to use a converter. In sense of automatisation this should also be possible with the ETL-Tool.

Does anybody know how to solve this problem?

flam's picture
1
Joined: Sep 1 2011 - 1:42am
Last seen: 12 years 1 month ago

0 Answers:

No answers yet
Feedback
randomness