Re: Open wo rendered page in excel
Re: Open wo rendered page in excel
- Subject: Re: Open wo rendered page in excel
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 8 Jan 2004 19:51:44 -0500
If you take any text file and give it a ".xls" extension, it
immediately gets an Excel icon in both Windows and OS X and
double-clicking it opens it in Excel.
In a FileMaker Pro app that I had, the Excel export did not output the
field names in the first row, so I output the data as HTML format,
saving with a ".xls" extension and it opened correctly in Excel on any
platform. You only noticed if you went to save it (in which case Excel
popd up the 'Save As.." dialog, which happens for .csv files opened in
Excel anyway)
-K
____________________________________
OS X 10.3.2 / WO 5.2.2 / MySQL 4.0.16
On Jan 8, 2004, at 4:20 PM, Denis Stanton wrote:
Hi Ray
On Friday, January 9, 2004, at 09:41 AM, Ray Ackland wrote:
Try doing what you just did (always open with & change all like this)
but do it in one step on a new file (that you haven't done the always
open part with).
I am guessing that when you say "always open with" it sets the
creator codes. When you later say to change all, it looks for all
files with that creator code and extension. If you do it in one hit,
it may just look for all files with that extension.
If I create a new .csv file it shows a generic icon. I believe this
indicates that it has no creator code
If I do Get Info it shows that the file is set to open with Excel.
"Change all" is greyed out, probably because I haven't changed
anything. If I switch the Opens With to something else, and then back
to Excel the "Change All" is enabled. Setting Opens with Excel and
Change All gets me to where I was already. All .csv files will open
in Excel if double-clicked, but they have generic icons and if I drag
them over the Excel icon in the dock it does not acknowledge them.
This leads me to the following assumptions:
Setting the headers in WebObjects does NOT set a creator code
Setting Opens With, with or without Change All, in the Finder does NOT
set a creator code
OS X's Opens With mechanism works with file suffixes, in the absence
of creator codes.
The Open dialog, and the Dock do NOT recognise suffixes and look only
for creator codes
So I am able to make .csv files that open with Excel if clicked.
That's good enough, particularly as these files are likely to be read
on a Windows system which wouldn't know a creator code anyway.
It would be even better/more elegant if I was able to set a creator
code in WebObjects so that the files would show an Excel icon and be
recognised by (Mac) Excel's Open dialog
Denis Stanton
email@hidden
Home: +64 9 533 0391
mobile: +64 21 1433622
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.