
The Black Box Toolkit Page 69 of 98
Copyright © 2004 The Black Box Toolkit Ltd. All rights reserved.
8.11. Exporting the spreadsheet to Microsoft Excel or an HTML file
You can export the lower spreadsheet to a Microsoft Excel file (.XLS) by selecting
“File|Export|To Excel File…” then choose the appropriate location and filename. Excel files
will be exported in the BIFF 8 format, which is the format used by Excel 97. All current
versions of Excel can read this format directly.
Alternatively you can highlight the range of cells you are interested in, copy them to the
clipboard (CTRL+C) and paste them into Excel (CTRL+V).
To export as standard HTML select “File|Export|To HTML File…” then choose the
appropriate location and filename.
You should bear in mind that both files will be quite large as you are exporting all 32,000
rows and 25 columns. This equates to 800,000 cells!
Comentarios a estos manuales