VBA也可以
[Visual Basic] 纯文本查看 复制代码 Sub GenerateBarcodeWithName()
' 声明变量
Dim bc As Barcode
Dim ws As Worksheet
Dim cell As Range
Dim barcodeName As String
Dim barcodeValue As String
Dim barcodeImage As Picture
' 设置工作表
Set ws = ThisWorkbook.Worksheets("Sheet1")
' 遍历每个单元格,生成条形码
For Each cell In ws.Range("A2:A" & ws.Cells(ws.Rows.Count, "A").End(xlUp).Row)
' 条形码名称和值
barcodeName = cell.Offset(0, 1).Value ' 假设名称在相邻列
barcodeValue = cell.Value
' 创建条形码对象
Set bc = Barcode(barcodeValue, "Code128") ' 假设条形码类型为Code128
' 在单元格下方插入条形码图片
Set barcodeImage = ws.Pictures.Insert(bc.Picture, cell.Offset(1, 0).Left, cell.Offset(1, 0).Top)
' 重设图片大小
barcodeImage.ShapeRange.LockAspectRatio = msoFalse ' 解锁纵横比
barcodeImage.Width = 300 ' 设置宽度
barcodeImage.Height = 50 ' 设置高度
' 清理对象
Set bc = Nothing
Next cell
End Sub |