Hi Everyone,

I am trying to write excel file with huge data, and for reducing time I have enabled "Stream XLSX Data" option.
But after doing so format of cells are lost.

In my transformation I am getting data from mysql db and using Excel Write Step I am creating a output excel file (using a template which have proper format). If I do not select "Stream XLSX Data" option then format of cells (border, alignment, etc) comes properly. But once I select "Stream XLSX Data" in out file format of cells are lost (cells where data is being written by Excel Write step).

Is there any way I can maintain format of cells even-though "Stream XLSX Data" option is enabled?

Thank you.
Kishan Gupta