[Solved] Export to excel problem...

[Krzysztof]

  Dim sfd As New SaveFileDialog
        Dim exporter As ExportToExcelML = New ExportToExcelML(Me.gv_urzadzenia)
        sfd.DefaultExt = ".xls"
        sfd.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"
        If sfd.ShowDialog() = System.Windows.Forms.DialogResult.OK Then

            Try
                exporter.SheetName = "urzadzenia"
                exporter.SheetMaxRows = ExcelMaxRows._1048576
                exporter.ExportVisualSettings = True
                exporter.RunExport(sfd.FileName)
                MsgBox(lng.zwroc_napis_z_nazwy_elementu("usr_planowanie_zostalo_poprawnie_wyeksportowane"), MsgBoxStyle.Information, lng.zwroc_napis_z_nazwy_elementu("okno"))

            Catch ex As Exception
                MsgBox(lng.zwroc_napis_z_nazwy_elementu("usr_planowanie_niezostalo_wyeksportowane"), MsgBoxStyle.Critical, lng.zwroc_napis_z_nazwy_elementu("okno"))

            End Try

        End If

Hello. I have a problem with national characters. In grid they look properly but after export to excel  they are converted into question marks. Does anyone know how to solve this problem? Thank you.

[Martin Vasilev]

Hello Krzysztof,

Thank you for writing. The described issue is because the older versions of ExportToExcelML class uses ASCII encoding. Fortunately, this has been already changed and now it uses UTF-8. I highly recommend you download the latest release Q3 2009 SP1 and give it a try.

Best wishes,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[bradley baker]

What do the two message boxes translate to in english?  I have the SaveFileDialog working and everything but I think these msg boxes are for if they succed/fail correct?

MsgBox(lng.zwroc_napis_z_nazwy_elementu("usr_planowanie_zostalo_poprawnie_wyeksportowane"), MsgBoxStyle.Information, lng.zwroc_napis_z_nazwy_elementu("okno"))