Unicode Encoding

[ahmad1]

I want to read the hyperlink text from an excel sheet but the link is a path with UNICODE Character ( Persian language) ساحات پولیس ملی" when I try using string

Code: Select all

 per= sheet.HyperLinks[0].Address

the variable

Code: Select all

per

not showing the exact text but instead it is showing ??????????????????. is there any work around with this?

I appreciate your help.

thanks

[amy.zhao]

Dear Nazeefa,

Thanks for your inquiry.
I did the test and had reproduced this issue. Sorry for the inconvenience. Our dev team is working on it.
Would you please send us your excel file? So that we will use the new fix to do a test with your file to ensure that the fix really fixes your issue.

Thanks and Regards,
Amy
E-iceblue support team

[ahmad1]

Hello, I send the sheet to your email. I just keep one cell with data and that is it.

thanks,
N

Dear Nazeefa,

Thanks for your inquiry.
I did the test and had reproduced this issue. Sorry for the inconvenience. Our dev team is working on it.
Would you please send us your excel file? So that we will use the new fix to do a test with your file to ensure that the fix really fixes your issue.

Thanks and Regards,
Amy
E-iceblue support team

[amy.zhao]

Dear Nazeefa,

Thanks for your reply.
I have receieved your excel file from e-mail.
Our dev team has got some progresses. We plan to release the new version of Spire.Xls which fixes this issue within next week.
Once the new version has been released, we will inform you.

Regards,
Amy
E-iceblue support team

[amy.zhao]

Dear Nazeefa,

Thanks for your waiting.
We have fixed this issue. Please download Spire.XLS Pack Hotfix Version:7.0.35(http://www.e-iceblue.com/Download/download-excel-for-net-now/spirexls-pack-hotfix7-0-35.html?Itemid=0) and test the code snippet below.

Code: Select all

 workbook.LoadFromFile(inputFile, ExcelVersion.Version97to2003);
    var link = workbook.Worksheets[0].Range[1, 1].Hyperlinks[0] as HyperLink;
    String path = link.UnicodePath;


There is any issue, please feel free to contact us.

Regards,
Amy
E-iceblue support team

[ashishgehlot95@gmail.com]

Hi,
I have similar issue while exporting excel to PDF. I tried you solution but didn't helped.
I am using FreeSpire.XLS 12.2.0.
I have no issue on windows but after publish to CentOs. PDF is generated with squre boxes instead unicode characters.

[Annika.Zhou]

Hello ashishgehlot95@gmail.com,

Thanks for your inquiry.
Based on your description, I guess that the issue you mentioned is caused by CentOs not having the relevant fonts installed. Thus, please first check if your CentOs system installed tall the fonts used in your Excel fileand ensure that your project has the permission to visit the installed fonts.
Meanwhile, you can use the following sample code to specify the fonts. Look forward to your further testing result.

Code: Select all

 Workbook workbook = new Workbook();
workbook.LoadFromFile("input.xls");
workbook.ConverterSetting.SheetFitToPage = true;
PdfDocument.SetCustomFontsFolders("fonts path");
 workbook.SaveToFile("result.pdf", FileFormat.PDF);

Sincerely,
Annika
E-iceblue support team

[baszsisz]

Hello ashishgehlot95@gmail.com,

Thanks for your inquiry.
Based on your description, I guess that the issue you mentioned is caused by CentOs not having the relevant fonts installed. Thus, please first check if your CentOs system installed tall the fonts used in your Excel fileand ensure that your project has the permission to visit the installed fonts.
Meanwhile, you can use the following sample code to specify the fonts. Look forward to your further testing result.

Code: Select all

 Workbook workbook = new Workbook();
workbook.LoadFromFile("input.xls");
workbook.ConverterSetting.SheetFitToPage = true;
PdfDocument.SetCustomFontsFolders("fonts path");
 workbook.SaveToFile("result.pdf", FileFormat.PDF);

Sincerely,
Annika
E-iceblue support team

Hi.
Can you provide a step-by-step guide how to install fonts on Android OS.
Thanks in advance!

[William.Zhang]

Hello,

Thanks for your inquiry.
Here, I have listed the general steps for installing fonts on Android systems. Additionally, you can learn more about installation methods through Google.

1.Download Fonts:
Download font files (usually in TTF or OTF format) from a reputable source.

2.Transfer Fonts to Your Device:
Connect your Android device to your computer via USB.
Copy the downloaded font files to the "Fonts" or "Download" folder on your Android device.

3.Install Fonts:
Open a file manager app on your Android device.
Navigate to the folder where you copied the font files.
Tap on a font file to open it. Your device should prompt you to install the font.

4.Activate the Font:
After installation, go to your device's settings.
Look for the "Display" or "Screen" section.
Depending on your device, there might be an option called "Font" or "Font Style." Select it.

5.Choose the Installed Font:
In the font settings, you should see a list of installed fonts. Choose the one you want to use.

6.Restart Your Device:
Some devices may require a restart for the new font to take effect.

Sincerely,
William
E-iceblue support team

[baszsisz]

Hello,

Thanks for your inquiry.
Here, I have listed the general steps for installing fonts on Android systems. Additionally, you can learn more about installation methods through Google.

1.Download Fonts:
Download font files (usually in TTF or OTF format) from a reputable source.

2.Transfer Fonts to Your Device:
Connect your Android device to your computer via USB.
Copy the downloaded font files to the "Fonts" or "Download" folder on your Android device.

3.Install Fonts:
Open a file manager app on your Android device.
Navigate to the folder where you copied the font files.
Tap on a font file to open it. Your device should prompt you to install the font.

4.Activate the Font:
After installation, go to your device's settings.
Look for the "Display" or "Screen" section.
Depending on your device, there might be an option called "Font" or "Font Style." Select it.

5.Choose the Installed Font:
In the font settings, you should see a list of installed fonts. Choose the one you want to use.

6.Restart Your Device:
Some devices may require a restart for the new font to take effect.

Sincerely,
William
E-iceblue support team

Thanks a lot!
I was able to set up the desired fonts!

[William.Zhang]

Hello,

Thanks for your feedback.
Glad to hear that, if you have any further questions, please feel free to write to me at any time.

Sincerely,
William
E-iceblue support team