Tag Archives: PHPExcel
Excel stores dates internally as number of days since January 1, 1900. For example: "June 9th, 2011 10:30 AM" would be stored as "40703.4375". 40703 is the number of full days since 01/01/1900 and 0.4375 represents the time (10.5/24 = 0.4375). When you process dates read from an Excel spreadsheet (e.g. using PHPExcel) you often want to convert them into a UNIX timestamp i.e. a number of seconds elapsed since midnight of January 1, 1970 UTC. Here is a PHP code to do that: Although the code above is written in PHP the function should be very similar in any other language e.g. C# or java. If the provided date is earlier than 1/1/1970 then the minimal timestamp value will be returned. Alternative…
Calendar
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
Recent Posts
Categories
Tags
Boosting
Byte Array
C++
CDN
CodeIgniter
Consolas
Crack
Decision Tree
Email Template
Error 404
friend
Git
GitHub
Gmail
Hadoop
IPv6
Jenkins
Mac
Machine Learning
MFC
OpenWRT
Parellels Desktop
PHP
PHPExcel
PHPUnit
Pinyin
Qt
Regular Expression
Reset Password
Spring MVC
SQLite
String
template
TideSDK
TimeStamp
Ubuntu
Unit Testing
Upload
Vim
WhiteList
WingIDE
WordPress
Workspace
Zend Framework
拼音