exporting the hidden columns

5 posts, 0 answers
  1. Gopinath
    Gopinath avatar
    63 posts
    Member since:
    Sep 2011

    Posted 14 Jan 2013 Link to this post

    Hi,

    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. 
  2.
  3. Yoan
    Admin
    Yoan avatar
    1214 posts

    Posted 14 Jan 2013 Link to this post

    Hello Gopinath,

    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.


    Kind regards,
    Yoan
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  5. Gopinath
    Gopinath avatar
    63 posts
    Member since:
    Sep 2011

    Posted 14 Jan 2013 Link to this post

    Thank you Yoan ....

    It's working as expected.

    can you please let me know how to provide the active sheet name while exporting
  7. Yoan
    Admin
    Yoan avatar
    1214 posts

    Posted 16 Jan 2013 Link to this post

    Hello Gopinath,

    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.


    All the best,
    Yoan
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  8.
  9. Gopinath
    Gopinath avatar
    63 posts
    Member since:
    Sep 2011

    Posted 16 Jan 2013 Link to this post

    Thank you Yoan ....

    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
Back to Top