下面是一个使用Apache POI库来获取一个单元格中的超链接,并将其放入新的单元格中的特定字符串的示例代码:
import org.apache.poi.ss.usermodel.*;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
public class HyperlinkExample {
public static void main(String[] args) {
String filePath = "path/to/your/excel/file.xlsx";
String sheetName = "Sheet1";
int sourceRowNum = 0;
int sourceCellNum = 0;
int targetRowNum = 0;
int targetCellNum = 1;
try (Workbook workbook = WorkbookFactory.create(new FileInputStream(filePath))) {
Sheet sheet = workbook.getSheet(sheetName);
Row sourceRow = sheet.getRow(sourceRowNum);
Cell sourceCell = sourceRow.getCell(sourceCellNum);
Hyperlink hyperlink = sourceCell.getHyperlink();
String hyperlinkAddress = "";
if (hyperlink != null) {
hyperlinkAddress = hyperlink.getAddress();
}
Row targetRow = sheet.getRow(targetRowNum);
if (targetRow == null) {
targetRow = sheet.createRow(targetRowNum);
}
Cell targetCell = targetRow.createCell(targetCellNum);
targetCell.setCellValue("Hyperlink: " + hyperlinkAddress);
FileOutputStream fileOut = new FileOutputStream(filePath);
workbook.write(fileOut);
fileOut.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
请确保将filePath
变量设置为您的Excel文件的路径,并根据需要设置sheetName
,sourceRowNum
,sourceCellNum
,targetRowNum
和targetCellNum
的值。
该代码段打开一个Excel文件,获取指定单元格(sourceRowNum
和sourceCellNum
)中的超链接,并将其放入新的单元格(targetRowNum
和targetCellNum
)中的特定字符串。最后,它将更改保存回原始Excel文件。