The Google Spreadsheet works, but I'm looking for a solution using just the Excel file because not everyone has a Google account(surprising, I know) and since I'm not editing the data itself(it's just an export from a desktop application) there's no reason to have data in three places.
I think maybe the reason the original columns that render as numbers have to be removed is that they contain spaces in their title and the word before the space is the same word as the column header containing the text() formula, but that's fixable, I just haven't gotten around to messing with it, and it's not the real problem. The real problem is that they render as numbers in the first place. -----Original Message----- From: Michael K. Bergman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 5:08 PM To: General List Subject: Re: Excel, Exhibit, and Dates Hi William, 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 have been using dates for quite some time with no problems in either version 1x or 2x of Exhibit. Granted, this is a hosted Google spreadsheet and not a direct conversion to JSON, but the Google hosted option works well and is easy to maintain. Make sure and label your columns with {var:date}; I also used the mm/dd/year format, e.g., 10/17/2007. You can see this working at my Sweet Tools listing (http://www.mkbergman.com/?page_id=325) for the Posted and Updated facets. Thanks, Mike _______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
