1. Home
  2. Forum
  3. WPF
  4. Extract images and paragraphs of text in correct order of display from an Excel cell

Extract images and paragraphs of text in correct order of display from an Excel cell

Hi everyone,

I am reading an Excel worksheet in a .xlsx file which contains some images and some paragraphs of text in a specific cell (See attached .xlsx file - Cell address: E6, column E & F are merged):

Image_4842_1713319828945

The problem is that I cannot extract/parse content of this specific cell (including its images and paragraphs of text in their correct order of display) to a C# object.

What I want to have is maybe the exact physical location of the texts & images in their correct display order OR something that let me know their order of display.

Any suggestions?

Many thanks,



Attachment: test_de331b6b.zip

3 Replies
KM Kurmitha Manickhaperumal Syncfusion Team April 17, 2024 01:48 PM UTC

Hi,

 

In the mentioned specific cells, we can not read text and images in the correct display order. You can read pictures on the worksheet based on their positions, and read text by specifying row and column ranges. Please refer to the code snippet below for reading text and pictures in the worksheet.

 

//Code snippet

IPictures pictures = worksheet.Pictures;

IPictureShape picture = pictures[0];

 

//Read text value

string name = worksheet["E5"].Text;

 

Regards,
kurmitha M.


Ð? Ð?ng replied to Kurmitha Manickhaperumal April 19, 2024 04:27 AM UTC

Hi Kurmitha Manickhaperumal,

Does Syncfusion Team have any plan to support this feature?

Thank you,

KM Kurmitha Manickhaperumal Syncfusion Team April 23, 2024 05:15 AM UTC

Hi,


It is a Microsoft Excel behavior. XlsIO follows the same behavior.  Therefore, we can't provide support for reading images and text in correct order of display for the specified cells. 


Regards,

kurmitha M.


Loader.
Up arrow icon