且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

读取.xlsm文件时,外部表未处于预期格式错误

更新时间:2022-12-06 20:13:31

",MyConnection) Dim dsChangedValues As New DataSet() Dim obj As OleDbDataAdapter = 新建 OleDbDataAdapter( MyCommand) obj.Fill(dsChangedValues)
", MyConnection) Dim dsChangedValues As New DataSet() Dim obj As OleDbDataAdapter = New OleDbDataAdapter(MyCommand) obj.Fill(dsChangedValues)




如果我要上传.xlsx文件,则效果很好.但是我必须上传一个.xlsm文件.

中给出了外部表未采用预期格式"的异常 obj.Fill(dsChangedValues)行. :(

有解决方案吗?

提前谢谢..
阿米




It works fine if I am uploading a .xlsx file. But I have to upload a .xlsm file.
Its giving ''External table not in the expected format'' exception in the
obj.Fill(dsChangedValues) line. :(

Any solutions?

Thanks in advance..
Ami