I have binded the 10 columns to the grid and made 5 columns to visible false (IsVisible=False) , so that i can only show the 5 columns in the UI (as per requirement).
But while exporting i need the 10 columns to be exported (as per requirement). But this is not happening. I can export only the UI visible columns.
can any you please help me in this.
4 Answers, 1 is accepted
Indeed, you are right, if a column is hidden it will not be exported or printed. I have prepared an example project that handles such a scenario. Please, refer to it and let me know if this approach meets your requirements.
Yoan
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Rank 2
It's working as expected.
can you please let me know how to provide the active sheet name while exporting
You can achieve this by manipulating the exported stream. Please note that, it depends on which Export engine you use. It is possible to change the worksheet name for ExcelML only. MS Excel automatically sets the worksheet name (equal to the file name) when using the HTML format.
For your convenience, I have prepared a sample project showing you the approach. Please find it attached.
I hope this helps.
Yoan
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Rank 2
It's working great..
If you dont mind can you please let me know, how can i access the full path of the Filename from SaveFileDialog.
Thanks
Gopinath