Import an Excel spreadsheet

Michael audax at wideband.net.au
Thu May 29 02:23:50 PDT 2008


Denise

Do you have MS Word?  If no Excel, then probably no Word.  If not,  
what WP or text apps do you have?

michael

On 29/05/2008, at 5:23 PM, Kurt J. Meyer wrote:

>
> 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
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna



More information about the Qna mailing list