Can REV create Excel files?

[Martin Blackman]

I've had good results working with Excel 2002 XML format.
You can get a comprehensive definition somewhere, but all I did was
'save as' from Excel on a few files into XML format and grok the
resulting XML files.  You can take the basics from one of those files
as a template for your file.

So what you need to do is write out your XML file from Rev but give
the file a '.xls' name, and then launch the document, works a charm.
One drawback to this method is that the file format doesn't cater for
images, charts or other objects. Hopefully the 2007 format will make
it easier to keep those features.

regards
Martin

On 03/03/07, Jim Ault <JimAultWins at yahoo.com> wrote:
> On 3/2/07 11:58 AM, "Richard Gaskin" <ambassador at fourthworld.com> wrote:
>
> > Jim Ault wrote:
> >> As far as I know, there is nothing in Rev that would easily allow an xls
> >> format to be written, even with "binary" capability.
> >
> > I thought MS was using XML for Office formats these day, no?
>
> I think the original question is how to distribute a file that the user does
> not have to do an extra step of importing, thus distribute a spreadsheet
> format containing the data.  You are correct about XML being used,
> especially working with address book entries where tags allow field, style,
> format, etc to be included in the data file.
>
> Text files( like CSV or tab delim, etc) can contain the raw data values and
> possibly headers, but no formatting, etc.
>
> Excel workbooks are saved as "myAccountingData.xls" and thus the XLS format
> is the actual workbook (containing worksheets, macros, charts, pivot tables,
> etc).  Rev does not have a way of creating an Excel workbook file.
>
> I distribute web-extracted data (using Rev) to a text file that gets
> imported into various workbooks, and I designed the workbooks to import and
> format the data properly with one user click on the toolbar button "Refresh
> All" on the external data tool bar.  The setup is a little tricky, but works
> for the client.  I could go a bit further and make a VBA script that would
> handle the import of the text file.
>
> I hope this answers the original question, but I may have gotten the wrong
> idea.
>
> Jim Ault
> Las Vegas
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>