Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
80
Is it possible that exporting a ultragrid to excel without hidden cell?
posted

Hi, I've read some articles(KB010038 and your ans. in this forum) about hidden cell when exporting to excel.

The point is changing the "hidden" property.

But, I want to export to excel without columns' cell which unbounded and LabelPosition is LabelOnly.

(The header is necessary but cells are not)

For example, there's simple grid.

the column "operands" is unbounded and its LabelPosition is LabelOnly.(this column has no meaning cells and only header is necessary)

But after exporting to excel I found that the column "operands"'s cells(or spaced) were exported and hidden.

Check this out.(I cancelled hidden cells in excel)

How can I remove that cells perfectly? I think treating "hidden" property is not adequate.

Also, is there anyway that preventing hidden cells in the ultragrid from being exported?

(or preventing some column from being exported? - not hidden but filtered out)

Thanks in advance.