XLS Writer Auto Hides a Column

CloverDX Platform
1

Hello -

I have a simple graph that runs sql statements against mysql db, then out put the results to an xls file using XLS writer. However, when I open the output file, column C is hidden. I have to manually unhide it after the file is generated. I am not sure why this is happening.

The column C is generated by using

 group_concat

. Not sure if that is causing the hidden?

Thanks,
Perri

2

Hi Perri,

Can you please provide sample graph? As far as I know there is no functionality for hiding column in XLS in XLSDataWriter.

Anyway, XLSDataWriter is now depreciated component, in commercial versions is available http://doc.cloveretl.com/documentation/ … riter.html

3

I am using community version. I solved the issue by using xlsx as the file extension. Thanks!