I am trying to import the grid to Excel through X++ (not the default Export to Excel feature) and want to know how to create a check box when ever i encounter a yesNo field which is a check box in the gird. Your suggestions are greatly appreciated.
user Excel objecct in your code
how to add check box ?
if your value is Yes then
if No ActiveSheet.CheckBoxes.Add()
hope this is helpful.
I have been using
these objects for Export to Excel . How i can use Excel object in X++ ?
Also i want to add only check box to a specific column. How does ActiveSheet relate to a specific column?
Thanks in advance,