{'feed'}->{'entry'}; // Get worksheet data $row_count = 1; foreach ($rows as $row) { if ($row_count == 1) { // First row are column headers $contents = explode(",", $row->{'content'}->{'$t'}); for ($x = 0; $x < count($contents); $x++) { $contents_elements = explode(": ", $contents[$x]); $content_columns[] = trim($contents_elements[0]); $content_headers[] = trim($contents_elements[1]); } } else { // Second row is column data foreach ($content_columns as $var) { $column_data[] = nl2br($row->{'gsx$' . $var}->{'$t'}); } } $row_count++; } // Populate data arrays $all_headers = $content_headers; $all_texts = $column_data; for ($z = 0; $z <= count($all_headers); $z++) { echo "
$all_headers[$z]
\n"; echo "
" . strip_tags($all_texts[$z], '
') . "
\n"; } ?>