
用类似这样的代码就可以了
List<String> strs=new ArrayList<String>()
String str1="hello"
String str2="world"
strs.add(str1)//通过add方法
strs.add(str2)
Javascript具有的数据类型。
有5种基本数据类型:number(整形和浮点型)、string、null、boolean和undefined。此外还有一种复杂的数据类型-Object,Object本质上是由一组无序的名值对象组成的,如Date对象是一个日期和时间类型。
说明:字符串,用一对单引号(' ')或双引号(" ")及引号内的字符构成,引号中间的部分可以任意多个,也可以是没有字符的空字符串。字符串中如果字符包含了双引号,则其外部应该由单引号标示,反之相同。
例如:"This's test","Welcome 'to' you'"等。
String对象是动态对象,需要创建对象实例后才能引用它的属性和方法。在创建一个String对象变量时,可以使用new运算符来创建,也可以直接将字符串赋给变量。例如:strValue="Hello"与strVal=new String("hello")是等价的。
首先,你要有poi库,这是 *** 作office文档的
然后,给你贴一个excel *** 作类,你读一下,应该就可以自己写调用了
import java.io.FileInputStreamimport java.io.IOException
import java.io.InputStream
import java.util.ArrayList
import java.util.List
import org.apache.poi.hssf.usermodel.HSSFCell
import org.apache.poi.hssf.usermodel.HSSFRow
import org.apache.poi.hssf.usermodel.HSSFSheet
import org.apache.poi.hssf.usermodel.HSSFWorkbook
import org.apache.poi.xssf.usermodel.XSSFCell
import org.apache.poi.xssf.usermodel.XSSFRow
import org.apache.poi.xssf.usermodel.XSSFSheet
import org.apache.poi.xssf.usermodel.XSSFWorkbook
import com.b510.common.Common
import com.b510.excel.util.Util
import com.b510.excel.vo.Student
/**
* @author Hongten
* @created 2014-5-20
*/
public class ReadExcel {
/**
* read the Excel file
* @param path the path of the Excel file
* @return
* @throws IOException
*/
public List<Student> readExcel(String path) throws IOException {
if (path == null || Common.EMPTY.equals(path)) {
return null
} else {
String postfix = Util.getPostfix(path)
if (!Common.EMPTY.equals(postfix)) {
if (Common.OFFICE_EXCEL_2003_POSTFIX.equals(postfix)) {
return readXls(path)
} else if (Common.OFFICE_EXCEL_2010_POSTFIX.equals(postfix)) {
return readXlsx(path)
}
} else {
System.out.println(path + Common.NOT_EXCEL_FILE)
}
}
return null
}
/**
* Read the Excel 2010
* @param path the path of the excel file
* @return
* @throws IOException
*/
public List<Student> readXlsx(String path) throws IOException {
System.out.println(Common.PROCESSING + path)
InputStream is = new FileInputStream(path)
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is)
Student student = null
List<Student> list = new ArrayList<Student>()
// Read the Sheet
for (int numSheet = 0 numSheet < xssfWorkbook.getNumberOfSheets() numSheet++) {
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet)
if (xssfSheet == null) {
continue
}
// Read the Row
for (int rowNum = 1 rowNum <= xssfSheet.getLastRowNum() rowNum++) {
XSSFRow xssfRow = xssfSheet.getRow(rowNum)
if (xssfRow != null) {
student = new Student()
XSSFCell no = xssfRow.getCell(0)
XSSFCell name = xssfRow.getCell(1)
XSSFCell age = xssfRow.getCell(2)
XSSFCell score = xssfRow.getCell(3)
student.setNo(getValue(no))
student.setName(getValue(name))
student.setAge(getValue(age))
student.setScore(Float.valueOf(getValue(score)))
list.add(student)
}
}
}
return list
}
/**
* Read the Excel 2003-2007
* @param path the path of the Excel
* @return
* @throws IOException
*/
public List<Student> readXls(String path) throws IOException {
System.out.println(Common.PROCESSING + path)
InputStream is = new FileInputStream(path)
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is)
Student student = null
List<Student> list = new ArrayList<Student>()
// Read the Sheet
for (int numSheet = 0 numSheet < hssfWorkbook.getNumberOfSheets() numSheet++) {
HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet)
if (hssfSheet == null) {
continue
}
// Read the Row
for (int rowNum = 1 rowNum <= hssfSheet.getLastRowNum() rowNum++) {
HSSFRow hssfRow = hssfSheet.getRow(rowNum)
if (hssfRow != null) {
student = new Student()
HSSFCell no = hssfRow.getCell(0)
HSSFCell name = hssfRow.getCell(1)
HSSFCell age = hssfRow.getCell(2)
HSSFCell score = hssfRow.getCell(3)
student.setNo(getValue(no))
student.setName(getValue(name))
student.setAge(getValue(age))
student.setScore(Float.valueOf(getValue(score)))
list.add(student)
}
}
}
return list
}
@SuppressWarnings("static-access")
private String getValue(XSSFCell xssfRow) {
if (xssfRow.getCellType() == xssfRow.CELL_TYPE_BOOLEAN) {
return String.valueOf(xssfRow.getBooleanCellValue())
} else if (xssfRow.getCellType() == xssfRow.CELL_TYPE_NUMERIC) {
return String.valueOf(xssfRow.getNumericCellValue())
} else {
return String.valueOf(xssfRow.getStringCellValue())
}
}
@SuppressWarnings("static-access")
private String getValue(HSSFCell hssfCell) {
if (hssfCell.getCellType() == hssfCell.CELL_TYPE_BOOLEAN) {
return String.valueOf(hssfCell.getBooleanCellValue())
} else if (hssfCell.getCellType() == hssfCell.CELL_TYPE_NUMERIC) {
return String.valueOf(hssfCell.getNumericCellValue())
} else {
return String.valueOf(hssfCell.getStringCellValue())
}
}
}
百度关键字是:java的poi技术读取Excel[2003-2007,2010],这个帖子下面甚至提供了代码下载。
List<String> list = Arrays.asList(str)//数组直接转成集合!或者一步到位:
List<String> list = Arrays.asList(new String[]{ "a", "b", "c" })
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)