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
290
How to Name Tabs in Exported excel file
posted

     Does anyone know how to name the tabs on an exported excel worksheet when exporting multiple grids. 

     For example:  I have an application where I am exporting two and sometimes four grids, where each grid becomes a different worksheet in the excel file.  Because of exporting multiple grids, it would be nice to name each tab with a descriptive title so that users can quickly associate which sheet corresponds to which exported grid.

 

Thanks

 

Dave.

  • 19693
    posted

    Hello Dave,

    Thank you for posting in our forums.

    Please refer to the below thread :

    Exporting to excel from the grid and modifying custom worksheets

    http://news.infragistics.com/forums/p/55900/286800.aspx

    There is sample attached .

    Let us know if you need further assistance.

  • 44743
    posted

    If you have access to the Worksheet instance to which the grid is exporting, it has a Name property which is settable. I am not too familiar with the WebExcelExporter, but maybe it has an event that occurs when the export process begins/ends which has the Worksheet in the event args.