Auf Thema antworten

Nachricht

Vielen Dank, wie immer bekomme ich von Ihnen sehr hilfreichen Hinweisen.

Ich habe das so gelöst
[CODE=java] int currentLine = 1;
for (int i = 0; i < list.size(); i++) {
int temp = 0;
currentLine--;
if (i > 0) {
temp = 1;
}
for (int k = temp; k <= list.get(i).getPhysicalNumberOfRows(); k++, currentLine++) {
row = outputSheet.createRow(currentLine);
for (int j = 0; j < 14; j++) {
cell = row.createCell(j);
if (list.get(k).getRow(k) == null) {
cell.setCellValue("");
} else {
cell.setCellValue(workBookClass.getDataFormatter().formatCellValue(list.get(i).getRow(k).getCell(j)));
}
}
}
}
[/CODE]

<blockquote data-quote="Adriano10" data-source="post: 1301682" data-attributes="member: 59370">Vielen Dank, wie immer bekomme ich von Ihnen sehr hilfreichen Hinweisen.Ich habe das so gelöst[CODE=java]&nbsp; int currentLine = 1;&nbsp; &nbsp; &nbsp; &nbsp; for (int i = 0; i &lt; list.size(); i++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int temp = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; currentLine--;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (i &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; temp = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int k = temp; k &lt;= list.get(i).getPhysicalNumberOfRows(); k++, currentLine++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; row = outputSheet.createRow(currentLine);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int j = 0; j &lt; 14; j++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cell = row.createCell(j);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (list.get(k).getRow(k) == null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cell.setCellValue(&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cell.setCellValue(workBookClass.getDataFormatter().formatCellValue(list.get(i).getRow(k).getCell(j)));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]</blockquote>

[QUOTE="Adriano10, post: 1301682, member: 59370"] Vielen Dank, wie immer bekomme ich von Ihnen sehr hilfreichen Hinweisen. Ich habe das so gelöst [CODE=java] int currentLine = 1; for (int i = 0; i < list.size(); i++) { int temp = 0; currentLine--; if (i > 0) { temp = 1; } for (int k = temp; k <= list.get(i).getPhysicalNumberOfRows(); k++, currentLine++) { row = outputSheet.createRow(currentLine); for (int j = 0; j < 14; j++) { cell = row.createCell(j); if (list.get(k).getRow(k) == null) { cell.setCellValue(""); } else { cell.setCellValue(workBookClass.getDataFormatter().formatCellValue(list.get(i).getRow(k).getCell(j))); } } } } [/CODE] [/QUOTE]

Verifizierung