Excel Interop right to left document

Question

I created a new Excel file with C #.

When I open the document, all sheets are aligned from right to left.

How can I align the worksheet / book / window to display left and right grammatically?

Answer 1

Sub leftToRight() Application.DefaultSheetDirection = xlLTR ActiveSheet.DisplayRightToLeft = False End Sub 

You can also change the setting using Tools-> Options-> International. Please note that you need to check / uncheck the "View current sheet from right to left" box to change the sheets currently open.

Edit: Sorry, I accidentally interpreted your question as VBA.

Here is the C # Solution:

 Excel.Application xlApp = new Excel.Application(); xlApp.Visible = true; xlApp.Workbooks.Add(System.Type.Missing); Excel.Worksheet active = (Excel.Worksheet)xlApp.ActiveSheet; xlApp.DefaultSheetDirection = (int)Excel.Constants.xlLTR; //or xlRTL active.DisplayRightToLeft = false; 

Answer 2

I would like to introduce my implementation of this function after I used the concept of marg and changed it to the correct syntax for me:

 public void SetWorksheetDirection(Application excel, bool isRTL) { Worksheet active = (Worksheet)excel.ActiveSheet; if (isRTL) excel.DefaultSheetDirection = (int)XlDirection.xlToRight; else excel.DefaultSheetDirection = (int)XlDirection.xlToLeft; active.DisplayRightToLeft = isRTL; } 

Answer 3

If you just want to organize some of the columns, you can use the following line:

 oWS.Range["A1:B2000"].HorizontalAlignment = Microsoft.Office.Interop.Excel.Constants.xlLeft; 

Answer 4

Do this once to change the default direction:

• Alt + F11 to open VBA editor
• Ctrl + G to open the Immediate window
• in the View Immediate window Application.DefaultSheetDirection = xlLTR and press Enter
• Alt + Q to close the VBA editor
• create a new workbook for testing.