PageLayout -> Sheet Right-to-Left ?

Jul 22, 2010 at 5:59 AM

Greetings,

I would like to know if it is possible to generate an excel document having the right to left layout set using EPPlus library.

FYI: You may go to Page Layout menu then click on Sheet Right-to-Left button to simulate what i am asking for using your library.

Thank you in advance for your cooperation.

Jul 22, 2010 at 10:18 AM

Solution:

The following property appended to ExcelWorksheetView class:

 public bool RightToLeft
        {
            get
            {
                return GetXmlNodeBool("@rightToLeft");
            }
            set
            {
                SetXmlNode("@rightToLeft", value == true?"1":"0");                
            }
        }

Cheers )

Coordinator
Jul 25, 2010 at 1:19 PM

Thanks, i'll add that :)

/Jan