Thanks!
> 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. >> ------------ Hell is other people Jean-Paul Sartre ********************************************************************** 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] **********************************************************************
