Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed May 08, 2013 9:26 pm

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

ahmad1
 
Posts: 2
Joined: Wed May 08, 2013 4:39 pm

Thu May 09, 2013 3:31 am

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
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Thu May 09, 2013 12:47 pm

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

thanks,
N
amy.zhao wrote: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
 
Posts: 2
Joined: Wed May 08, 2013 4:39 pm

Fri May 10, 2013 8:53 am

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
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Thu May 16, 2013 8:23 am

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
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Feb 21, 2022 10:03 am

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.

ashishgehlot95@gmail.com
 
Posts: 1
Joined: Wed Jul 18, 2018 4:53 pm

Tue Feb 22, 2022 2:11 am

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
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Tue Feb 13, 2024 3:36 pm

Annika.Zhou wrote: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!

baszsisz
 
Posts: 4
Joined: Tue Feb 13, 2024 1:38 pm

Wed Feb 14, 2024 2:23 am

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
User avatar

William.Zhang
 
Posts: 194
Joined: Mon Dec 27, 2021 2:23 am

Wed Feb 14, 2024 9:01 am

William.Zhang wrote: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!

baszsisz
 
Posts: 4
Joined: Tue Feb 13, 2024 1:38 pm

Thu Feb 15, 2024 1:34 am

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
User avatar

William.Zhang
 
Posts: 194
Joined: Mon Dec 27, 2021 2:23 am

Return to Spire.XLS

cron