java excel blob,如何在excel单元格中保存blob文件(How to save blob files in excel cells)

I have table consist of column("file as pdf") which stores the bills.

my problem is i want to export that table to excel sheet.

is it possible?

So far i tried this..

Dim xapp As New Microsoft.Office.Interop.Excel.Application

Dim wb As Workbook = xapp.Workbooks.Add

Dim ws As Worksheet = wb.Worksheets(1)

ws.Activate()

'Fill header of the sheet----------------------------------

For i As Integer = 1 To dgvcustomer.Columns.Count

ws.Cells(1, i) = dgvcustomer.Columns(i - 1).HeaderText

Next

'End header------------------------------------------------

Dim Dgrow, Dgcell, Dgcol As Integer

Dgrow = 1

Dgcell = 1

'Fill Sheet -----------------------------------------------------------------------

While (Dgrow <= dgvcustomer.Rows.Count)

Dgcol = 1

While (Dgcol <= ws.UsedRange.Columns().Count)

ws.Cells(Dgrow + 1, Dgcol).value = dgvcustomer.Rows(Dgrow - 1).Cells(ws.Cells(1, Dgcol).value).Value

Dgcol += 1

End While

Dgrow += 1

End While

'End fill sheet--------------------------------------------------------------------

wb.SaveAs(dlgSaveFile.FileName)

wb.Close()

xapp.Quit()

This code works for non blob data type columns but for blob it raises exception.

zNoMH.png

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值