[Solved] GridView Excel export issue

[Florent]

Hi,

I manage to export a GridView into an Excel file (.xlsx).

But when I am trying to insert an excel graphic with the exported data, all the predefined styles are empty

If I start from a blank new excel file, typing values and inserting a graphic, it is ok

Please look attachments to see what I mean.

Is it an Excel template issue ?

My code looks like :

Dim dialog = New SaveFileDialog() With {
                 .DefaultExt = "xlsx",
                 .Filter = [String].Format("(*.{0})|*.{1}", "xlsx", "xlsx")
            }
dialog.ShowDialog()

Dim exportOptions = New GridViewDocumentExportOptions() With {
                           .AutoFitColumnsWidth = True,
                           .ExportDefaultStyles = False,
                            .ShowColumnFooters = grid.ShowColumnFooters,
                            .ShowColumnHeaders = grid.ShowColumnHeaders,
                            .ShowGroupFooters = grid.ShowGroupFooters
                          }

Using stream = dialog.OpenFile()
                    grid.ExportToXlsx(stream, exportOptions)
End Using

 

Regards

[Dilyan Traykov]

Hello Florent,

The issue you've described seems to be related to this bug report we have logged in our feedback portal.

As I'm unable to reproduce it with Excel 2016, could you please try applying the workaround suggested in the feedback item (manually change the theme for the document) and let me know how it goes?

I look forward to your reply.

Regards,
Dilyan Traykov
Progress Telerik