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
Thanks,
Perri
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
-
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 -
I am using community version. I solved the issue by using xlsx as the file extension. Thanks!
Please sign in to leave a comment.
Comments 2