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
