Link Search Menu Expand Document

SSpread.ImportExcelSheet Method

Explanation Imports the specified sheet in an Excel file.

Files that can be imported are in Excel 2003 format (BIFF8 format).

The Reset method is called before importing and SSpread is initialized.

The number of sheets and sheet name of the Excel file to be imported can be checked with the GetExcelSheetList method. In addition to specifying the sheet name in the argument sheet, a sheet number starting from 0 also can be specified.
Call format ImportExcelSheet(URL or Reader, sheet)
Return value None
Arguments URL or Reader Excel file URL or Reader Object

The file will be cached on local computer for faster loading from the next time onwards when the URL is specified. The latest files from the server can be acquired by specifying an HttpResponse object.
sheet Sheet number or sheet name
Exception EXT-24 No valid Reader object specified
EXT-28 An error occurred in the ImportExcelSheet method
Example of use
    var session = findHttpSession("http://example.com");
    var res = session.Get("/excelfile.xls");
    ImportExcelSheet(res, "Sheet 1");
    
Related item ExportExcelBook, ExportExcelBookEx, ExportToExcel, ExportToExcelEx, GetExcelSheetList methods
HttpResponse class