shuchkin/simplexlsx

Hyperlinks

Ondrashek opened this issue · 3 comments

Ondrashek commented

if ( $xlsx = SimpleXLSX::parse('book.xlsx') ) {
print_r( $xlsx->rows() );
} else {
echo SimpleXLSX::parseError();
}

$xlsx->rows won't show hyperlink but only plain text.

Can you add option to enable hyperlinks with url instead of plain text in classic parsing?

Thanks :-)

Ondrashek commented

Yes. This is working, but I must search value in array by string (url plain text) because I used columns as keys so I can't find exact cell by id from ->rows().

shuchkin commented 
foreach ($xlsx->rowsEx() as $r) {
   echo $r[1] . PHP_EOL; // out second column
}