How do I set column filters on and freeze the top row in my Excel worksheet created from X++?

(0) Share

Report

Posted on by Community Member

I am using X++ to write results to an Excel worksheet and for a nice finishing touch I have made bold the top row. How do I put column filters on and freeze the top row?

I have lucked out searching for an answer so perhaps someone here can help me.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Johnkrish 781 on at

Like (0)

Report

Hi ,

Please refer these articles

https://dynamicsuser.net/ax/f/developers/65634/creates-excel-file-in-x

translate.google.co.in/translate;sl=ru&u=axforum.info/.../showthread.php%3Ft%3D32407&prev=search

i hope it will be useful.

Regards,

Johnkrish

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Second link doesn't work but first gave me the answer I was looking for - thank you John.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Correction, the question is only partly answered. I still need to apply column filters. Another pointer please.

Was this reply helpful? Yes No