How to set Record List To Excel without header?
Application Type
Traditional Web

Hi all,

I would like to export the table list in an excel file, I create a function as following example:

Start -> ListAppendAll  -> RecordListToExcel -> Download

The excel file then I download is including the header title, I want to know how can I export the excel without the header title(first row).

Thanks 

Solution

Hi @Jack Wong,

Since RecordListToExcel won't do it for you, just FYI if exporting to a CSV file is an option for you, then the CSVUtil forge component is pretty handy too. You could remove the header by setting the 'IsShowHeader' property to false:


Happy coding,

AJ

mvp_badge
MVP

That seems to be a much easier to implement solution than that I suggested

Thank you for your suggestion
mvp_badge
MVP

Hi Jack,

With the OutSystems RecordListToExcel that is not possible.

With Forge component like https://www.outsystems.com/forge/component-overview/355/advanced-excel it is.

Regards,

Daniel


Thank you for your suggestion
Solution

Hi @Jack Wong,

Since RecordListToExcel won't do it for you, just FYI if exporting to a CSV file is an option for you, then the CSVUtil forge component is pretty handy too. You could remove the header by setting the 'IsShowHeader' property to false:


Happy coding,

AJ

mvp_badge
MVP

That seems to be a much easier to implement solution than that I suggested

Thank you for your suggestion
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.