[Solved] Export to Excel

[Ro]

Hi,

I want to export the data of the grid to excel.

my data is displayed from right to left,
how can I export it rtl?

Thanks!

[Atanas Korchev]

Hello Ro,

 

Here is a demo which shows how to customize the Excel sheet for RTL languages: http://dojo.telerik.com/@korchev/obUlI

 

The important code is the excelExport handler:

 

        excelExport: function(e) {
          var sheet = e.workbook.sheets[0];
          for (var i = 0; i < sheet.rows.length; i++) {
            sheet.rows[i].cells.reverse();    
            for (var ci = 0; ci < sheet.rows[i].cells.length; ci++) {
              sheet.rows[i].cells[ci].hAlign = "right";
            }
          }
        }

 

Regards,
Atanas Korchev
Telerik

 

 

[Ro]

Thanks a lot, it works perfectly!