注意每个方法结束都要关闭workbook;
还有getIdbyname()方法中字符串flag与name的比较,一定要用equals()方法!!!;
剩下的不多解释,注释都在代码中:
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class DnsTest {
public static void main(String[] args) throws IOException{
getIdbyname("株洲");
getNamebyid(6) ;
}
public static void getIdbyname(String name)throws IOException {
//通过name获得id
String filePath="D://dns.xls";
InputStream i