> -----Original Message----- > From: David Huynh [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 20, 2007 01:28 PM > To: General List > Subject: Re: Excel, Exhibit, and Dates > > william gunn wrote: > > I'm having an issue with dates converting from Excel to > JSON for Exhibit. > > I'm converting from an Excel file, and the only way I can get the > > dates to show up as dates and not numbers in Exhibit is by > using the > > text() Excel function to make a new column converting the original > > dates to text as shown > > here: http://www.pcmag.com/article2/0,1895,1927710,00.asp, > then doing > > "paste-special-values" into a new spreadsheet, omitting the > original > > date columns. > > > > If I leave in the original columns, the dates show up as 0 > in Exhibit, > > and if I try to format the original columns using the format cells > > menu option, the dates turn into numbers. > > > > I know David's been working on this, but I don't know if it's been > > worked out yet. It's not a big deal, really, but has > anyone figured > > out a workaround that doesn't involve copying and pasting? > > > I haven't gotten to the bottom of this yet. I used some > external .jar to access Excel files and I'll need to see how > to retrieve dates properly.
Thanks, David. > > On a related note, I'm converting my file on-the-fly, > because I don't > > think it'll see too many pageloads, and it just seemed like > overkill > > to check out babel for one little table, but does anyone have some > > code to write the on the fly babel output to a file so that > the next > > pageload could check for the existence of the converted > file and use that if present? > > > You could do this > > <link href="your-file.xls" > rel="exhibit/data" > type="application/msexcel" /> > > Given that your .xls file is publically accessible at a URL, > that code will bounce the Excel file through > http://simile.mit.edu/babel/ automatically. This is what I'm doing now, but I was thinking of some kind of convert on first load, creating a .js from the .xls, then using the .js on subsequent pageloads thing, because my application would involve deleting and re-uploading the .xls instead of editing it in place. _______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
