Convert HTML String to Datatable

Help Activities
, , ,
1

Hi all,

I have a HTML string which contains table data ,I want to Convert html table to datatable with out using .html or .mht format files.

Please giude me how can we convert HTML string to datatble using any ling query or any other method?

2

Hi,

If you can use custom activities package, the following may help you.

Regards,

4

Can you share the Example of the html string

6

Hi,

Can you try the following sample?

image
image761Ă—1781 47 KB

Sample
Sample20240227-1a.zip (5.6 KB)

Regards,

7

Where is this string coming from?

Technically HTML is XML so you may be able to parse it with the various XML activities/expressions.

8

image
image693Ă—254 8.2 KB

I am facing the error, Please guide me.

9

Hi,

For now, can you try to save the project, then restart Studio and reopen the project? Automatic recovery function may run.

If it doesn’t run, can you temporarily try to remove “System.Web.HttpUtility.HtmlDecode” ? (remain just strResult) . DataTable will be created but html encoded such as   will be displayed.

Regards,

12

Hi,

Did you modify any other property of WriteRange or GenerateDataTable?

In my environment, headers are displayed as the following even if remove htmldecode method.

image
image957Ă—176 6.41 KB

Regards,

13

I did not changed anything,Please check the screenshot below

image
image891Ă—505 22.3 KB

image
image846Ă—478 8.59 KB

14

HI,

Can you also check AddHeaders option of WriteRange activity?

Regards,

15

I have unchecked the add header in writerange.now i checked.

Thank you it worked.

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.