Have you tried simply opening your spreadsheet in TBC (by double clicking on it)?
Irene -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Karen Wright Sent: Monday, August 01, 2011 1:40 PM To: TopBraid Suite Users Subject: [topbraid-users] How best to process spreadsheet cells in SPARQLMotion (TBC ME Version: 3.5.1.v20110629-1105R)? What recommendations are there for processing through a 31 column spreadsheet and pulling out the data properties? I have an imported xls file with 31 columns of data and the ss: properties of cell, column, row, cellContents, etc. The first column, zero, contains the Department Name, the next column contains the Department ID, etc. SELECT * WHERE { ?ColumnHeading a ss:Cell . ?ColumnHeading ss:column ?col . ?ColumnHeading ss:cellContents ?ColumnValue . FILTER (?col = "0"^^xsd:integer) . } Sample triple from the above SPARQL: ColumnHeading = <@b549fb5:131851e0c2d:-101a> Col = 0 ColumnValue = PKPD SELECT * WHERE { ?ColumnHeading a ss:Cell . ?ColumnHeading ss:column ?col . ?ColumnHeading ss:cellContents ?ColumnValue . FILTER (?col = "1"^^xsd:integer) . } Sample triple from the above SPARQL: ColumnHeading = <@b549fb5:131851e0c2d:-1012> Col = 1 ColumnValue = 345 Here's part of my SPARQLMotion construct module. I'm looking for an iterative way to process the spreadsheet so I don't have to build 31 construct modules. CONSTRUCT { :Dept a owl:Class . :hasDeptName a owl:DatatypeProperty . :hasDeptName rdfs:domain :Dept . :hasDeptName rds:range xsd:string . ?deptUri a :Dept . ?deptUri rdfs:label ?deptLabel . ?deptUri :hasDeptName ?deptName . } WHERE { ?ColumnHeading a ss:Cell . ?ColumnHeading ss:column ?col . ?ColumnHeading ss:cellContents ?deptName . FILTER (?col = "0"^^xsd:integer) . BIND (smf:buildURI("http://example.com/data#dept-{?1}";, ?deptName) AS ?deptUri) . BIND (smf:cast(fn:concat("Department ", ?deptName), xsd:string) AS ?deptLabel) . } Thanks, Karen -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
