> On Fri, Nov 6, 2009 at 3:09 AM, Malcolm Fitzgerald > <[email protected]> wrote: >> I'm receiving files from a web site that are supposed to be in excel >> 97-2000 >> format. When I'm on a windows platform OO calc opens the file as a >> spreadsheet. When I try to open the same files on my Mac they open in OO >> Write, even though I've specified that I want to open an MS excel .xls >> file. >> >> I've opened the files in a text editor and inspected them. They contain >> nothing but an HTML table so I'm a little annoyed that anyone even >> pretends >> that they are excel files. However, MS excel opens them and utilises the >> HTML code to format the cells. OO Calc on windows opens them and I need >> the >> same functionality on the mac. Can anyone suggest anything? > > You probably need the Developer Tools installed to have this command > available > SetFile -c XCEL -t XLS8 filenameToOpenInExcel > assuming here that you don't actually have Excel on that Mac. > > Or, what happens when you change the filename to .ods? > > Oddly, GetFileInfo on an .ods file shows no creator or type info - > does anyone know why they that is?
SetFile works, that is, it changes creator code and file type attributes and the icon looks like an excel spreadsheet. It doesn't change the fact that it opens in web/writer Same result when I change the file name extension to .ods I'll attach the file so you can see what I'm dealing with thanks Malcolm
ProductExport.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
