8

I am using closedXML to generate a XML file(in arabic) and i need this file to be in right to left layout how can it do this in closedXML.

XLWorkbook wb = new XLWorkbook();
var ws = wb.Worksheets.add("Sheet1");
ws.Cell(1,1).Value = "مرحبا";
ws.Style.Alignment.ReadingOrder = XLAlignmentReadingOrderValues.RightToLeft;
Thomas Bormans
  • 5,156
  • 6
  • 34
  • 51
Asanka Madushan
  • 463
  • 8
  • 17

1 Answers1

15

Both the XLWorkbook and XLWorksheet objects have a RightToLeft property. You can either set it to true for the entire workbook or for each individual sheet.

var workbook = new XLWorkbook {RightToLeft = true}; // <-- Workbook default RTL
var worksheet = workbook.Worksheets.Add("Sample Sheet");
worksheet.Cell("A1").Value = "Hello World!";
// worksheet.RightToLeft = true;  <-- To set RightToLeft for individual worksheets
workbook.SaveAs("HelloWorld.xlsx");
Paul-Jan
  • 16,746
  • 1
  • 63
  • 95