android操作excel
厳密には転載して、書き直して、readXLSXとwriteXLSはテストを経て
import java.io.File;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;
import android.util.Xml;
import org.xmlpull.v1.XmlPullParser;
import jxl.Cell;
import jxl.CellType;
import jxl.DateCell;
import jxl.NumberCell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class UtilXlsParser {
private static final int DEFAULT_SHEET = 0;
public static String readXLS(String path) {
String str = "";
try {
Workbook workbook = Workbook.getWorkbook(new File(path));
Sheet sheet = workbook.getSheet(0);
int columnCount = sheet.getColumns();
int rowCount = sheet.getRows();
Cell cell = null;
for (int i = 0; i < rowCount; i++) {
for (int j = 0; j < columnCount; j++) {
cell = sheet.getCell(j, i);
String temp2 = "";
if (cell.getType() == CellType.NUMBER) {
temp2 = ((NumberCell) cell).getValue() + "";
} else if (cell.getType() == CellType.DATE) {
temp2 = "" + ((DateCell) cell).getDate();
} else {
temp2 = "" + cell.getContents();
}
str = str + " " + temp2;
}
str += "
";
}
workbook.close();
} catch (Exception e) {
}
return str;
}
public static List<ArrayList<String>> readXLSX(String path) {
String v = null;
List<String> list = new ArrayList<String>();
List<ArrayList<String>> table = new ArrayList<ArrayList<String>>();
try {
ZipFile file = new ZipFile(new File(path));
ZipEntry sharedStringXML = file.getEntry("xl/sharedStrings.xml");
InputStream inputStream = file.getInputStream(sharedStringXML);
XmlPullParser parser = Xml.newPullParser();
parser.setInput(inputStream, "utf-8");
int event = parser.getEventType();
while (event != XmlPullParser.END_DOCUMENT) {
switch (event) {
case XmlPullParser.START_TAG:
String tag = parser.getName();
if (tag.equalsIgnoreCase("t")) {
list.add(parser.nextText());
}
break;
case XmlPullParser.END_TAG:
break;
default:
break;
}
event = parser.next();
}
ZipEntry sheetXML = file.getEntry("xl/worksheets/sheet1.xml");
InputStream inputStreamsheet = file.getInputStream(sheetXML);
parser = Xml.newPullParser();
parser.setInput(inputStreamsheet, "utf-8");
event = parser.getEventType();
ArrayList<String> row = null;
boolean isText = false;
while (event != XmlPullParser.END_DOCUMENT) {
switch (event) {
case XmlPullParser.START_TAG:
String tag = parser.getName();
if (tag.equalsIgnoreCase("row")) {
row = new ArrayList<String>();
table.add(row);
} else if (tag.equalsIgnoreCase("c")) {
String t = parser.getAttributeValue(null, "t");
if (t != null) {
isText = true;
} else {
isText = false;
}
} else if (tag.equalsIgnoreCase("v")) {
String cell = parser.nextText();
if (cell != null) {
if (isText) {
row.add(list.get(Integer.parseInt(cell)));
} else {
row.add(cell);
}
}
}
break;
case XmlPullParser.END_TAG:
if (parser.getName().equalsIgnoreCase("row") && v != null) {
}
break;
}
event = parser.next();
}
} catch (Exception e) {
e.printStackTrace();
}
return table;
}
public static int writeXLS( String path, List<ArrayList<String>> table ) {
File file = createXLS(path);
if ( file==null ) {
return CREATE_FAIL;
} else {
return addData( file,table );
}
}
private static File createXLS(String path) {
File file = null;
try {
file=new File(path);
WritableWorkbook book = Workbook.createWorkbook(file);
WritableSheet sheet = book.createSheet("task", DEFAULT_SHEET);
book.write();
book.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
return file;
}
}
private static int addData( File file, List<ArrayList<String>> table ){
try {
Workbook wb = Workbook.getWorkbook(file);
WritableWorkbook book= Workbook.createWorkbook(file,wb);
WritableSheet sheet = book.getSheet(DEFAULT_SHEET);
for(int task=0; task<table.size(); task++) {
List<String> attrs = table.get(task);
for(int attr=0; attr<attrs.size(); attr++) {
Label label = new Label( attr, task, attrs.get(attr) );
sheet.addCell(label);
}
}
book.write();
book.close();
return 0;
} catch (Exception e) {
e.printStackTrace();
return ADD_DATA_FAIL;
}
}
public static final int CREATE_FAIL = -1;
public static final int ADD_DATA_FAIL = -2;
}