How to freeze excel header row

Am using CSV Util plugin how to freeze the header row in excel after file extraction 

Hi,

to get more effective help on the component you are using, you should ask the question right on the component's forge page. It appears the same here, but the component owners are alerted and more quickly you will be able to get help you need.

Cheers

Hello Robert.

From what I saw in the demo, this plugin only works with the CSV format.

The freeze column/row is an Excel file functionality. It is available in files .xls, .xlsx, .ods ...

CSV is just a text file with specific formatting rules.

In the Forge you have at least two components to do CsvToExcel. Look into those. They may work with freeze.

https://www.outsystems.com/forge/Component_Search.aspx?q=Excel 


Nuno Reis wrote:

Hello Robert.

From what I saw in the demo, this plugin only works with the CSV format.

The freeze column/row is an Excel file functionality. It is available in files .xls, .xlsx, .ods ...

CSV is just a text file with specific formatting rules.

In the Forge you have at least two components to do CsvToExcel. Look into those. They may work with freeze.

https://www.outsystems.com/forge/Component_Search.aspx?q=Excel 


Hello Nuno,


Apologize delay in response, I have imported excel package component how to free the header row in excel

Package.


Any solutions?

Hi Robert,

Forge component Advanced Excel uses EPPlus to generate and modify the Excel files. It's easy to extend using Integration Studio. This exact question was asked before on the component's Forge page. I think this answer is in this post:
https://www.outsystems.com/forums/discussion/53572/freeze-header-row-functionality/#Post200819

Does this help you further?

Regards,
Lennart