Extract filtered rows to an html table

#get list of filtered rows
dataTable = Document.ActiveDataTableReference
rows = Document.ActiveFilteringSelectionReference.GetSelection(dataTable).AsIndexSet()

#generate html table
#generate html head

html = " <TABLE id='myTable'>\n"

html += " <THEAD>\n"
html += "  <TR>"

#generate html header

for column in dataTable.Columns:

   html += "<TH>" + column.Name + "</TH>"
html += "  </TR>\n"
html += " </THEAD>\n"

#generate html rows
html += " <TBODY>\n"

for r in rows:

   html+="  <TR>"
   for column in dataTable.Columns:
      html += "<TD>" + column.RowValues.GetFormattedValue(r) + "</TD>"
   html+="  </TR>\n"

#finish html

html += " </TBODY>\n"

html += "</TABLE>\n"

#show results
print html

• Tweet
• Share
• Share
• Share
• Share

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post