automatic date detection

you'll have to manually detect it by calling the function rowsEx , where you can see the type as 'd'

abhishe,

Thanks for the suggestion. Can you give me an example of the code?

ok so I have changed the example3 to this just to check it and its working

<?php

if (isset($_FILES['file'])) {

require_once "simplexlsx.class.php";

$xlsx = new SimpleXLSX( $_FILES['file']['tmp_name'] );
echo "<pre>".print_r( $xlsx->rowsEx(), true )."</pre>";
echo "<pre>".print_r( $xlsx->rows(), true )."</pre>";
$rows_type = $xlsx->rowsEx() ;
echo '<h1>Parsing Result</h1>';
echo '<table border="1" cellpadding="3" style="border-collapse: collapse">';

list($cols,) = $xlsx->dimension();
$i = 0;

foreach( $xlsx->rows() as $k => $r) {
// if ($k == 0) continue; // skip first row
$j = 0;
echo '<tr>';
for( $i = 0; $i < $cols; $i++){
if( isset($rows_type[$i][$j]['type'])?($rows_type[$i][$j]['type'] != 'd'):true){

echo '<td>'.( (isset($r[$i])) ? $r[$i] : '&nbsp;' ).'</td>';
}else if(isset($rows_type[$i][$j]['type']) && $rows_type[$i][$j]['type'] == 'd' && is_numeric($r[$i])){

echo '<td>'.( (isset($r[$i])) ? date("F j, Y",$xlsx->unixstamp($r[$i])) : '&nbsp;' ).'</td>';
}else{
echo '<td>'.( (isset($r[$i])) ? $r[$i] : '&nbsp;' ).'</td>';
}
$j++ ;
}
echo '</tr>';
$i++ ;
}
echo '</table>';
}

?>
<h1>Upload</h1>
<form method="post" enctype="multipart/form-data">
*.XLSX <input type="file" name="file" />&nbsp;&nbsp;<input type="submit" value="Parse" />
</form>

Thanks,

I tried your code and I get an internal server error. I modified mine and it still fails to work: I still get date strings like 41237, etc. Below is my code.


<?php


require_once "simplexlsx.class.php";

$xlsx = new SimpleXLSX( "rschedule.xlsx" );

echo '<h1>Work Schedule</h1>';
echo '<table border="1" cellpadding="3" style="border-collapse: collapse">';

list($cols,) = $xlsx->dimension();

foreach( $xlsx->rows() as $k => $r) {
// if ($k == 0) continue; // skip first row
$j = 0;
echo '<tr>';
for( $i = 0; $i < $cols; $i++){
if( isset($rows_type[$i][$j]['type'])?($rows_type[$i][$j]['type'] != 'd'):true){

echo '<td>'.( (isset($r[$i])) ? $r[$i] : '&nbsp;' ).'</td>';
}else if(isset($rows_type[$i][$j]['type']) && $rows_type[$i][$j]['type'] == 'd' && is_numeric($r[$i])){

echo '<td>'.( (isset($r[$i])) ? date("F j, Y",$xlsx->unixstamp($r[$i])) : '&nbsp;' ).'</td>';
}else{
echo '<td>'.( (isset($r[$i])) ? $r[$i] : '&nbsp;' ).'</td>';
}
$j++ ;
}
echo '</tr>';
$i++ ;
}
echo '</table>';

you forgot this line
$rows_type = $xlsx->rowsEx() ;
you have not defined the variable before using it

Thanks, I still get internal server error on both your code and then mine without or with that particular line, but when I use the example3 provided as part of the package that works. I am not sure what is going on.

then I think u have to debug it line by line , because my code is working fine on my system.

Abhishek,
I was able to get your sample script to work. It had to do with some permissions of files on the shared server I was using and your date script mods worked well. I changed them a bit to use 2 digit format.

Now it seems as though the path references to the file to load seem a bit tricky. Thanks for your help!
-M

Actually, the math seems to be off by one day with xlsx being one day before the xlsx date, so there may be an error in the transformation used.