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
