Import an Excel spreadsheet

[Kurt J. Meyer]

Am 29.05.2008 um 05:31 schrieb Richard J. Kulda:

> A client sent me an .xls spread sheet. My Finder suggests that I
> received it just fine. I do not have Excel. In the past I've had
> difficult but successful episodes getting the client to send me a Text
> format version of the spread sheet. It would be imprudent of me to
> impose this trial on the client. I've tried to use the Excel Import
> Wizard. Nothing works.

The Wizard's instructions say it clearly: You have to have Excel open  
and to make a selection in the Excel spreadsheet in order to import  
these selected cells into a Panorama database. No Excel -- no use for  
the Excel Import Wizard.

> I'm hoping to have my copy of iWork working
> soon. (I think I have a faulty CD.) Since the Finder keeps trying to
> use Numbers to open my Excel document, I'm guessing it will. Then my
> problem will be solved.

Numbers is able to open Excel documents (if formulas are not too  
complicated) and can then export them as .csv files. These are comma- 
separated text files, and you can open them in Panorama just as you  
would do with tab-separated text files.

(Since Numbers contains a lot of complex templates containing several  
tables and charts on one page, you should only export one simple  
table at a time that fits in Panorama's Data Sheet. If your Excel  
document contains more than one spreadsheet, you should export them  
separately.)


-- 
Kurt J. Meyer
Cologne, Germany