我基本上从我的数据库中获取行并将它们作为行粘贴到我的excel文件中。这很容易,因为没有任何数据转换。这里是我的代码(最重要的一部分):Java POI - 插入行作为列
XSSFSheet chart1_sheet = wb.createSheet("Chart1");
String strss_chart[] = {"dataa", "inn", "closed", "application"};
hed_row = chart1_sheet.createRow(0);
for_each_header(hed_row, strss_chart);
sql = "select dataa, inn, closed, application from Chart1";
statement = conn.prepareStatement(sql);
resultSet = statement.executeQuery();
row = 1;
while(resultSet.next())
{
Row dataRow = chart1_sheet.createRow(row);
for_each_row_func(dataRow, resultSet, strss_chart);
row = row + 1;
}
和我的两个功能:
public static void for_each_row_func(Row dataRow, ResultSet resultSet, String [] strs) throws Exception
{
int i = 0;
for(String str : strs)
{
dataRow.createCell(i).setCellValue(resultSet.getString(str));
i += 1;
}
}
public static void for_each_header(Row dataRow, String [] strs) throws Exception
{
int i = 0;
for(String str : strs)
{
//dataRow.createCell(i).setCellValue(resultSet.getString(str));
dataRow.createCell(i).setCellValue(str);
i += 1;
}
}
我的最终目标是从这些数据创建图表,但做到这一点,我需要的数据不这样的:
Column1 Column2 Column3
Data1 Data2 Data3
Data4 Data5 Data6
但是这样的:
Column1 Data1 Data4
Column2 Data2 Data5
Column3 Data3 Data6
在Java Poi中有没有办法做到这一点?