Get row based on TextSelection

[twindberg]

Hi,

I'm using Spire.office (8.3.2).
I want to delete a row based on a searched text.

Code: Select all

            Document document = new Document(true);
            document.LoadFromFile(contentRootPath + "/Files/invoice.docx");
            TextSelection selection = document.FindString("[Name]", true, true);


How can I get the cell/column the found text contains?

Thanks

[Triste.Dai]

Thanks for your inquiry.
Please refer to the following code.

Code: Select all

            Document document = new Document("sample.docx");
            // Find all instances of "text_to_find" in the document
            TextSelection[] selections = document.FindAllString("text_to_find", false, true);
            foreach (TextSelection selection in selections)
            {
               
                Spire.Doc.Fields.TextRange textRange = selection.GetAsOneRange();
                Paragraph paragraph = textRange.Owner as Paragraph;
                // get the owner of the paragraph
                DocumentObject owner = paragraph.Owner;
                if (owner.DocumentObjectType.Equals(DocumentObjectType.TableCell))
                {
                    // get the tableCell
                    TableCell tableCell = owner as TableCell;

                    // Get the row that the cell is in
                    TableRow tableRow = tableCell.Owner as TableRow;

                    // Remove the entire row from the table
                    Table table = tableRow.Owner as Table;
                    table.Rows.Remove(tableRow);
                }
            }

If the code does not meet your requirement or you have any other questions, just feel free to contact us.

Best regards,
Triste
E-iceblue support team

[twindberg]

Hi Triste,

thank you very much. The code is exactly what i was looking for!

[Triste.Dai]

Hi,

Glad to hear that my code works for your issue. If you have any other questions related to our products, just feel free contact us, we are always glad to assist you.
Have a nice day!

Best regards,
Triste
E-iceblue support team