Read 2007 excel Date field

Topics: Developer Forum, Project Management Forum, User Forum
Sep 16, 2011 at 6:28 AM

How can i read a date field from excelsheet ?

Sep 16, 2011 at 12:08 PM

I have been using something like this...

$date = PHPExcel_Style_NumberFormat::toFormattedString(round($data), "M/D/YYYY");

Sep 16, 2011 at 1:36 PM
Dear brother ScottMSanders
I have no idea that which column is number and which coumn is date
field.So how can i distinguish where this code is applied.All number
and date field datatype in cell class is 'n' .Please sovle my problem.

On Fri, Sep 16, 2011 at 5:38 PM, ScottMSanders
<notifications@codeplex.com> wrote:
> From: ScottMSanders
>
> I have been using something like this...
>
> $date = PHPExcel_Style_NumberFormat::toFormattedString(round($data),
> "M/D/YYYY");
>
> Read the full discussion online.
>
> To add a post to this discussion, reply to this email
> ([email removed])
>
> To start a new discussion for this project, email
> [email removed]
>
> You are receiving this email because you subscribed to this discussion on
> CodePlex. You can unsubscribe on CodePlex.com.
>
> Please note: Images and attachments will be removed from emails. Any posts
> to this discussion will also be available online at CodePlex.com



--
With Regards
Manab Rout