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.

Fri Jan 05, 2018 2:42 pm

Hello.

We need to retreive AlternativeText of a Shape.

We tried this:

AlternativeText.png
AlternativeText.png (82.45 KiB) Viewed 2223 times


Code: Select all
            string path = Chemin + "Classeur1.xlsx";

            var workbook = new Workbook();
            workbook.LoadFromFile(path);
            var worksheet = workbook.Worksheets["Feuil1"];
           
            foreach (var shape in worksheet.Charts.OfType<Chart>())
            {
                if (!String.IsNullOrEmpty(shape.AlternativeText))
                    MessageBox.Show(shape.AlternativeText, "AlternativeText");
            }


What's wrong in our code ?

Regards.

Vincent
Attachments
Classeur1.zip
(11.74 KiB) Downloaded 257 times

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Mon Jan 08, 2018 3:16 am

Hello,

Thanks for your inquiry.
I have noticed the issue and referred it to our dev team. Once there's any update, I will let you know.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Fri Jan 12, 2018 8:17 am

Hello,

Good day!
Glad to inform that the issue has been resolved and the hotfix(Spire.XLS Pack(Hotfix) Version:7.12.144) is available now.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Mon Jan 15, 2018 1:23 pm

Hello,

It's work !
Thanks.

Regards,
Vincent

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Jan 16, 2018 1:24 am

Hi VincentB,

Thanks for your feedback.
Please feel free to contact us if you need any assistance.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS