importing word table to excel

[Walter Martin]

I'm browsing a Word document using DocIO library in a blazor server application and as soon as i found a Wtable element, I have to import it in a Excel document using XlsIO library.

The WTable in made up of merged header cells horizontally and vertically so I don't find a function to import it as it is in an Excel document.

I found the way to import a datatable to excel but I don't know in case how to convert the Wtable to a datatable

Is there any solution for this job ?

Thanks

[Gopinath Natesan]

Hi Walter Martin,
Upon checking, we have attached a sample for your reference that demonstrates how to export a table with horizontally and vertically merged cells form word document to excel sheet.

Steps to how to convert the WTable to a data table in Excel:
1. In DocIO, Using FindAllItemsByProperty API to get all tables form the word document.
2. Convert the Word table by reading each cell and detecting its horizontal and vertical merged cells.
3. Recreate the same structure in Excel by merging the corresponding cell ranges.
4. Finally, write the text into the top‑left cell of each merged range and apply formatting as needed.

Kindly refer to the following user guide for find items in a word document:
https://help.syncfusion.com/document-processing/word/word-library/net/find-item-in-word-document

Kindly refer to the following user guide for working with tables in Word document:
https://help.syncfusion.com/document-processing/word/word-library/net/working-with-tables

Kindly refer to the following user guide for working with tables in Excel:
https://help.syncfusion.com/document-processing/excel/excel-library/net/working-with-excel-tables

Regards,
Gopinath.

Attachment: Tableto_DataTable_5c373d19.zip