Read an Excel file

xiaoxiao2021-03-06  19

/ * * CREATED ON 2005-3-25 Author Tailborn * * Copyright (c) 2003-2005 by Hodesoft * All Rights Reserved. * / Package Excel; import java.io.file; import java.io.fileInputStream; Import java.io.InputStream; import jxl.Cell; import jxl.CellType; import jxl.Sheet; import jxl.Workbook; public class readExcel {public void readExcel () {try {// Construction Workbook object, Workbook object // read-only Create Workbook File File from the local file // from the input stream ("e: /temp/hodeoa_2005/book1.xls"); InputStream is = new fileinputstream (file); Workbook RWB = Workbook.getWorkbook (IS ); // Number of worksheets (SHEET) in Workbook // int shop = rwb.getNumberOfsheets (); // Return to Workbook Worksheet (Sheet) Object Architecture Sheet [] Sheets = rwb.getsheets (); for (int i = 0; i

转载请注明原文地址:https://www.9cbs.com/read-42477.html

New Post(0)