EPPlus support for sheet right to left alignment

Question

Excel right to left alignment

what is the equivalent in EPPlus to using sheet right to left alignment in Excel , the only thing that comes close to that is ExcelReadingOrder.RightToLeft but it doesn't seem to set the alignment for the whole sheet

Answer 1

I think you want to set the View object of the worksheet:

using (var package = new ExcelPackage(fileinfo))
{
    var workbook = package.Workbook;
    var worksheet = workbook.Worksheets.Add("RightToLeft");

    //Set the worksheet right-to-left
    worksheet.View.RightToLeft = true;

    package.Save();
}