Export DataGrid View To Excel/PDF

Question

I would like to implement a feature to export a datagrid view with grouped items, like this:

I'd like to create an Excel spreadsheet (and possibly PDF) that also maintains the groupings appear.

Have any of you ever done something like that or know tell me a way forward? Thanks.

P.S. For Excel document generation thought to use the EPPlus library.