Export to Excel

Jim Ault JimAultWins at yahoo.com
Sat Dec 17 12:20:45 EST 2005


On 12/16/05 11:13 PM, "Bill Vlahos" <bvlahos at mac.com> wrote:
> I've seen some programs export it directly into Excel without going
> through a file on disk. How is that done? I assume on the Mac I could
> use AppleScript but how would I do it on Windows?

Your task seems rather uncomplicated as you have described it (below).  I
can build a quick demo stack to show one technique I use, but it will be Mac
only since it uses Applescript.

If doing this in Windows, I would build a workbook (or template) with at
least one Visual Basic script that would read the tab-delimited text data
file and do the fancy work.  Most likely, I would also do the fancy work in
VBA on the Mac rather than learn all the Applescript equivalents.  Rev would
'trigger' the running of the XL script using Applescript and the magic would
commence.

If the destination workbook required more than one option for which VBA
script to run, I would make the first line of the data file a value that
would tell the workbook which to execute.

I am sure there is a Visual Basic option in Windows to do this, but I have
not done this in over 5 years and cannot remember how I did it.  The major
difference to note is that there is VBA (for applications like Excel) and
there is VB that works in Windows between apps.

Hope this helps.

Jim Ault
Las Vegas


On 12/16/05 11:13 PM, "Bill Vlahos" <bvlahos at mac.com> wrote:

> 
> On Dec 14, 2005, at 9:02 AM, Jim Ault wrote:
> 
>> Couple of questions:
>> 1) is this one table, or several?
> One table. I might do several but if I can do one then I can do several.
>> 2) is is continuously updated, or a one-time publish?
> One-time publish.
>> 3) does the format vary each/several times?
> Not really. Essentially tab delimited fields.
>> 4) does the dimension of the table change?
> It might.
> 
> Bill Vlahos
> 
>> 
>> Jim Ault
>> Las Vegas
>> 
>> On 12/13/05 5:20 PM, "Bill Vlahos" <bvlahos at mac.com> wrote:
>> 
>>> I have a table in an appliation which I want to export to Excel. I
>>> can fake it out by simply saving it as a text file with the .xls
>>> extension and when the user double-clicks it, Excel will open it up.
>>> 
>>> That will fake it out but won't do any fancy Excel things like set up
>>> tabbed categories, etc.
>>> 
>>> Is there a better way to do this export?
>>> 
>>> I've seen some programs export it directly into Excel without going
>>> through a file on disk. How is that done? I assume on the Mac I could
>>> use AppleScript but how would I do it on Windows?
>>> 
>>> Bill Vlahos





More information about the use-livecode mailing list