英文:
Fill xlsx file empty cell with results from a map using Java and Apache POI
问题
private static void writeFile(Map<String, String> products) throws IOException {
File file = new File("./data/stock_zonder_imageurls.xlsx");
FileInputStream fis = new FileInputStream(file);
Workbook workbook = new XSSFWorkbook(fis);
Sheet datatypeSheet = workbook.getSheetAt(0);
Iterator<Row> iterator = datatypeSheet.iterator();
while (iterator.hasNext()) {
Row currentRow = iterator.next();
Iterator<Cell> cellIterator = currentRow.iterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
if (cell != null && cell.getCellTypeEnum().equals(CellType.STRING)) {
if (cell.getColumnIndex() == 2) {
String val = cell.getStringCellValue();
if (products.containsKey(val)) {
String image_url = products.get(val);
Cell firstColumnCell = currentRow.createCell(0); // Create a new cell in the first column
firstColumnCell.setCellValue(image_url); // Set the image URL value in the newly created cell
}
}
}
}
}
fis.close(); // Close the FileInputStream before writing to the file
// Write the updated content back to the file
FileOutputStream fos = new FileOutputStream(file);
workbook.write(fos);
fos.close(); // Close the FileOutputStream after writing
}
英文:
I basically have 2 xlsx files, one with image url's and a product id, and one with a empty image url's and a product id.
I already load the contents I need to parse in the other file correctly, the parameter with the map contains all the info required.
So my question is, how can I write in the new file with the results from the mappings? I basically need to put the image url on the first column's index which contains the image urls for all the products.
Here is some sample code,
private static void writeFile(Map<String, String> products) throws IOException {
File file = new File("./data/stock_zonder_imageurls.xlsx");
FileInputStream fis = new FileInputStream(file);
Workbook workbook = new XSSFWorkbook(fis);
Sheet datatypeSheet = workbook.getSheetAt(0);
Iterator<Row> iterator = datatypeSheet.iterator();
while (iterator.hasNext()) {
Row currentRow = iterator.next();
Iterator<Cell> cellIterator = currentRow.iterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
if(cell != null && cell.getCellTypeEnum().equals(CellType.STRING)) {
if(cell.getColumnIndex() == 2) {
String val = cell.getStringCellValue();
if(products.containsKey(val)) {
String image_url = products.get(val);
//here I need to write to the file the image url on column 0 of the specified $file with the $image_url
}
}
}
}
}
}
答案1
得分: 1
根据问题，您的要求是更新现有的 Excel 文件。
请尝试以下步骤。
// 创建行 ID 并初始化
int rowId = 0;
while (iterator.hasNext()) {
---- //另一段代码
rowId++;
if (products.containsKey(val)) {
String image_url = products.get(val);
// 假设第一行是标题
Cell cell = datatypeSheet.getRow(rowId).getCell(0); // 从相关行（rowId）和第一列（列索引为 0）获取单元格
cell.setCellValue(image_url); // 将 image_url 设置到单元格中
}
---- //另一段代码
}
注意：上述代码是根据您提供的内容进行的翻译，可能需要根据上下文和实际情况进行微调。
英文:
as per the question, your requirement is a update the existing excel file.
try with following steps.
//create a row id and initialized
int rowId = 0;
while (iterator.hasNext()) {
---- //another code
rowId++;
if(products.containsKey(val)) {
String image_url = products.get(val);
//assumed as first row is header
Cell cell = datatypeSheet.getRow(rowId).getCell(0); //get the cell from relevant row (rowId) and first column (column index is a 0)
cell.setCellValue(image_url); //set image_url into cell
}
---- //another code
}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论