This is a migrated thread and some comments may be shown as answers.

Export to excel problem...

2 Answers 150 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Krzysztof
Top achievements
Rank 1
Krzysztof asked on 19 Jan 2010, 08:00 AM
  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.

2 Answers, 1 is accepted

Sort by
0
Martin Vasilev
Telerik team
answered on 21 Jan 2010, 08:32 AM
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.
0
bradley baker
Top achievements
Rank 1
answered on 22 Jan 2010, 08:42 PM
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"))
Tags
GridView
Asked by
Krzysztof
Top achievements
Rank 1
Answers by
Martin Vasilev
Telerik team
bradley baker
Top achievements
Rank 1
Share this question
or