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 | | |
| Related item | ExportExcelBook, ExportExcelBookEx, ExportToExcel, ExportToExcelEx, GetExcelSheetList methods HttpResponse class | |