CODEWITHSUNDEEP
c#excelgembox-spreadsheet
Erez Konforti
Erez Konforti

Reputation: 253

C# GemBox-SpreadSheet Right To Left

I'm using a C# WebApi 2, stored on Azure server without office installed.

I need to create an excel file, and know that GemBox Spreadsheet does not require office to be installed on the machine.

The issue is that I need the file to be right to left, and could not find how to do it.

Is it even possible with GemBox Spreadsheet?

If no, is there another library that does not require office that support RTL?

Upvotes: 1

Views: 277

Answers (1)

Mario Z
Mario Z

Reputation: 4381

Try this:

ExcelFile file = new ExcelFile();
ExcelWorksheet sheet = file.Worksheets.Add("Sheet1");
ExcelViewOptions viewOptions = sheet.ViewOptions;

viewOptions.ShowColumnsFromRightToLeft = true;

I hope it helps.

Upvotes: 2

Related Questions