It works now, directly converting from Excel. Thanks David! I'll update the wiki.
> -----Original Message----- > From: David Huynh [mailto:[EMAIL PROTECTED] > Sent: Monday, October 22, 2007 03:48 PM > To: General List > Subject: Re: Excel, Exhibit, and Dates > > I think I've fixed this problem. Let me know if it works for you now. > > David > > 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? > > > > 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? > > > > > > Thanks for any suggestions, > > > > William Gunn > > > > > > _______________________________________________ > > General mailing list > > [email protected] > > http://simile.mit.edu/mailman/listinfo/general > > > > > _______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
