Hi Chip, I get these from time to time as well. PITA. The ones I get have some weird formatting at the beginning. If you look at it in your text editor you'll probably see some style tag ( <style> ... </style>) followed by two tables. The first one probably has the column headers and the second one the data. After screwing around with trying to do it elegantly I resorted to quick brute force:
Delete the style tag. Delete the first </table><table> pair so that you've got a single table. Save the file. Open it in a browser. Copy and paste back into your text editor. Save. No you've got the contents as a tab delimited plain file. On Fri, Dec 15, 2017 at 12:57 PM, Chip Scheide via 4D_Tech < [email protected]> wrote: > Got a file which claims to be an excel file (.xls) but will not open as > an excel spreadsheet (Mac Office 2011 Excel) > When the file opens in excel, it is opened as if it was a plain text > file, when opened in Windows Office 2010 Excel it opens, and opens as a > spread sheet. > -- Kirk Brooks San Francisco, CA ======================= *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
