Render Arabic text in Excel spreadsheet using Aspose.Cells in .NET

Aspose.Cells Product Family
1

Hi,

Does Aspose.Cells support Arabic text (reading and writing)?

Please find attached screen shots with issues highlighted and the excel file I am using.

My C# Code:

Workbook book = new Workbook("c:\\القوائم المالية.xlsx");

Worksheet sheet = book.Worksheets[1];

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();

imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;

imgOptions.OnePagePerSheet = true;

SheetRender sr = new SheetRender(sheet, imgOptions);

Bitmap bitmap = sr.ToImage(0);

bitmap.Save("c:\\Preview.gif");

Thanks

Staggga

2

Hi,


Yes, it is supported. But, I could find your mentioned issue using your sample code with template file. The Arabic text’s alphabets are not well directed / rendered fine. I have logged a ticket for it with an id: CELLSNET-30519. We will look into the issue soon.

Thank you.
3

Hi,

Can you please update me on this issue. We urgently need this sorted.

Thanks

Stagga

4

Hi,


I have requested the concerned developer of the module to update me, or provide eta for it. Once I get some update from the developer, I will let you know here immediately.

Thank you.
5

Good day,


Has there been an ETA provided as yet, (been 10 days), also experiencing the same issue.

Many thanks
6

Hi,

I got the below image with the latest version:
Aspose.Cells for .NET v7.0.1.3

Please see if it is ok. I was not able to open your xlsx file though.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\القوائم المالية.xlsx”;


Workbook book = new Workbook(filePath);


Worksheet sheet = book.Worksheets[1];


ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();


imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;


imgOptions.OnePagePerSheet = true;


SheetRender sr = new SheetRender(sheet, imgOptions);


Bitmap bitmap = sr.ToImage(0);


bitmap.Save(filePath + “.out.Preview.gif”);


Output Image:
7

Hi,


Thank you for this, there are still some slight formatting issues, but all text is now going the correct way so it seems.

Will provide detail on the other small text alignment issue asap.

Many thanks Aspose!!!
8

Hi,

Thanks for testing and finding out issues.

If you encounter any other issues, then please report with your sample code, source files and screenshots. We will look into it and fix it asap.