Thread: conversions and excel

i'm a noob, i know but here's my situation

so i have an excel document with one column dedicated to dates and the next column dedicated to times. anyway i wanted to write up a java app that can read the excel document and create a new excel document with the dates and times as a standard java milliseconds date

i have no clue how to go about this and have very little java background so here are my questions

1) is it possible?
2) how should i go about doing this?

i would gladly pay for someone to write this up for me, but i would also like to learn how to do this, if anyone has advice/comments pm me or reply

If you plan on doing this a lot, I'd recommend looking into something like JExcelApi (JExcelApi). If you are only going to do this a few times, it may be more efficient to just save the excel file to a tab delim format, then use java to read that file, make changes, and write to another tab delim which can be read in by Excel.

JExcelApi can resolve you problem. You can read the tutorial.html, there is a simple case about dates conversions