How to open .html file in Excel and save it as .xlsx format for further automation

[ppr (Peter Preuss)]

we would recommend to process the file directly as it has schema of e.g. spreadsheet

here we can check following options:

• html/xml parsing and processing
• XML Stylesheet transformations to bring it within tabular data

not far away an example of xml spreadsheet processing:

Need to Process XML Spreadsheet

Quick Prototype result: [grafik] Variables and Namespace Setup: [grafik] [grafik] We are tricking the datatable conversion with the help of LINQ and JSON arrJObjects = (From row In xDoc.Root.Descendants(xnsDefault + "Table").First().Descendants(xnsDefault+"Row") Where row.Elements().Count > 5 Let JPrps = row.Elements(xnsDefault + "Cell").Select(Function (x,i) New JProperty("Col" & i.toString, x.Value)).toArray Select jo = New JObject(JPrps)).toArray We filter for rows having more then 5…