More in general: if there are more patterns around for getting the cell contents in some semantics properties for rows/datapoints...that would be very welcome!
First I thought it would be easy but I am struggling a bit extracting via sparql constructs the row data becoming different instances involving “row-1 definitions” just knowing the row and column of a specific cell. Guess I just miss a general pattern walking the rows (as instances f datapoints) and next the columns (as triples for those instances referencing the first row) .... Thx Michel Dr. ir. H.M. (Michel) Böhms Senior Data Scientist T +31888663107 M +31630381220 E [email protected]<mailto:[email protected]> Location<https://www.google.com/maps/place/TNO+-+Locatie+Delft+-+Stieltjesweg/@52.000788,4.3745183,17z/data=!3m1!4b1!4m5!3m4!1s0x47c5b58c52869997:0x56681566be3b8c88!8m2!3d52.000788!4d4.376707> [cid:[email protected]]<http://www.tno.nl/> This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages. Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <[email protected]> Verzonden: Sunday, November 17, 2019 2:31 PM Aan: [email protected] Onderwerp: [topbraid-users] contsruct query question for sheets PREFIX ss: <http://www.topbraidcomposer.org/owl/2006/08/spreadsheets.owl#> PREFIX bsc: <https://w3id.org/def/basicsemantics-owl-complex#> CONSTRUCT { ?uri a bsc:PropertyDef . } WHERE { ?namecell a ss:Cell . ?namecell ss:row 0 . ?namecell ss:cellContents ?name . BIND (iri(concat("http://www.topbraidcomposer.org/owl/2006/08/spreadsheets.owl#",?name)) AS ?uri ) } Works fine for getting more semantic data after xlsx import like: [cid:[email protected]] But if the second and third row are special too like giving (optionally) datatype and unit) how can I best combine? Like to have forinstance as result: ss:shear_modulus bsc:hasUnit Pa Is there some smart way to get to the value of row2/3 or can I make a next query that is sequential to this one? Thx for advice, Michel Dr. ir. H.M. (Michel) Böhms Senior Data Scientist T +31888663107 M +31630381220 E [email protected]<mailto:[email protected]> Location<https://www.google.com/maps/place/TNO+-+Locatie+Delft+-+Stieltjesweg/@52.000788,4.3745183,17z/data=!3m1!4b1!4m5!3m4!1s0x47c5b58c52869997:0x56681566be3b8c88!8m2!3d52.000788!4d4.376707> [cid:[email protected]]<http://www.tno.nl/> This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages. -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/0f3fd26f32ce47ba85ffd41f0abdf41c%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/0f3fd26f32ce47ba85ffd41f0abdf41c%40tno.nl?utm_medium=email&utm_source=footer>. -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/69b04a966a304fa3bbc21214989e7fd7%40tno.nl.
