I'm generating an excel in ruby which each line represents the results of an nmap scan.
An example of a line could look like that: ip, yes (because port is 22 open), no (because port 80 is not open), etc.
I would like to be able to create a header line with a drop down list for each port that allow me to select if that port is open or not.
So i can filter my results to see for example all hosts that have both port 22 and 80 open.
Is there a way to do that with WIN32OLE.new("Excel.Application")? (or something else; html would be better because Linux does not support win32ole).