Excel export

David Thompson dthmpsn1 at uiuc.edu
Mon Mar 3 08:18:26 PST 2008


>In order to use the Excel export wizard I had to open a blank
>spreadsheet in Excel and then select enough cells to accommodate my
>data; otherwise Panorama gave me an alert saying the Excel selection
>wasn't big enough to fit my data and the extra data would be truncated.
>Is this expected behavior?

Yes. This procedure puts the exported data into the selected cells in 
the spreadsheet. The selected cells don't have to include the one in 
the upper left. It's up to you to determine which contiguous block of 
cells it should use, and which spreadsheet should receive the data.

The spreadsheet does not have to be blank, and this feature makes 
more sense when it's not.

For what you seem to be doing, it might be simpler to export a text 
file, and then use Excel to open the text file.

Dave


More information about the Qna mailing list