excel

Converting Excel Dates to UNIX Timestamps

Dec 7, 2011 · 1 min read · microsoft · excel ·

A previous article showed how to convert a UNIX Timestamp to an Excel Date. It’s also possible to do the reverse- convert an Excel Date value to a UNIX formatted Timestamp.

Converting UNIX Timestamps to Excel Dates

Oct 10, 2011 · 1 min read · microsoft · excel ·

Share on:

Converting UNIX Timestamps to Excel Dates

Faced with analysing a proprietary log file from a Linux system I turned to Excel to look at the data. The dates in this log file were stored in the standard UNIX timestamp format (number of seconds since midnight on the 1st January 1970) so I needed a formula to convert this into something readable. This is what I …

Outputting CSV from an ASP page

Mar 16, 2011 · 1 min read · microsoft · visualbasic · vb.net · excel · asp.net ·

Share on:

I’ve recently had the need to write an ASP page which reads a SQL database and outputs into Microsoft Excel- a user clicks on a link to this ASP page and Excel opens up with a new spreadsheet of the data. This is how I did it