急!请教如何将数据库中的数据导入到excel文件中?谢谢!今天结贴!
将数字导入到excel文件中是已经实现了,源代码如下:
我想请教的问题是:当我把数据库中的数据提取后导入excel文件中,该如何处理??
谢谢大家。
简单的将数字导入到excel的源代码如下:
import org.apache.poi.hssf.usermodel.*;
import java.io.FileOutputStream;
import java.sql.*;
// code run against the jakarta-poi-1.5.0-FINAL-20020506.jar.
// and commons-logging-1.0.jar
public class PoiTest {
static public void main(String[] args) throws Exception {
DB_Connection db = new DB_Connection();
ResultSet rs = null;
rs = db.getRS("select * from users");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
FileOutputStream fos = new FileOutputStream("d:\\foo.xls");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName(0, "Matrix");
for(short i=0; i<numberOfColumns; i++) {
HSSFRow row = s.getRow(i);
HSSFCell hssfCell = row.getCell(i);
if (hssfCell==null){
hssfCell = row.createCell(i);
}
while (rs.next())
{
for (short j = 0; j < 1; j++) {
String test=rs.getString(j);
hssfCell.setCellValue(j);
}
}
}
rs.close();
wb.write(fos);
fos.close();
}
}
请各位大侠赐教!!!