没有使用Microsoft.ACE.OLEDB.12.0写入excel文件 [英] Nothing written to excel file using Microsoft.ACE.OLEDB.12.0

问题描述

您好，我是b $ b我们使用Microsoft Access数据库引擎（Microsoft.ACE.OLEDB.12.0）连接到excel 2010宏

$ b来自vb.net的$ b文件，并将值插入到excel文件中定义的命名范围。

我们对excel 2003 xls文件执行相同操作，但使用Microsoft.Jet.OLEDB.4.0提供程序，这很好用。

Hello,
we are using the Microsoft Access database engine (Microsoft.ACE.OLEDB.12.0) to connect to an excel 2010 macro
file from vb.net and insert values into defined named ranges into the excel file.
We do the same for a excel 2003 xls file, but with the Microsoft.Jet.OLEDB.4.0 provider, and this works perfectly fine.

但是当我们尝试在excel 2010宏文件中插入大量行时，一切似乎都运行正常，


但excel文件最后是空的。写入更少的行可以正常工作并将值插入到文件中（大约5100行是可以的）。

But when we are trying to insert a big number of rows into the excel 2010 macro file everything seems to work fine,
but excel file is empty at the end. Writing a fewer number of rows works fine and values are inserted into file (about 5100 rows is ok).

我们发现如果我们在运行Web站点的IIS中配置应用程序池在
左右运行
本地系统帐户，然后一切正常，每行都插入到excel文件中。 

We have discovered that if we configure the application pool in IIS that runs the web site to run under
Local System account, then everything works fine and every row is inserted into excel file. 

我们还发现了写入excel文件使用visual studio的内部网络服务器工作正常。

We have also discovered that writing to excel file works fine using visual studio's internal webserver.

某些缓冲区大小是否有问题或者这是什么问题？如何解决这个问题？

任何关于如何解决这个问题的想法都值得赞赏！

Is there a problem with some buffer size or what is this about? How to solve this?
Any ideas about how to solve this is appreciated!

BR / Siri

BR/Siri

 

推荐答案

Sir Siri，

Hi Siri,

谢谢发布。

我认为可能是缓冲区大小设置，在传输大数据时，你应该求助于IIS中的应用程序池。

I think it could be the buffer size settings that when transferring large data, you should resort to the application pool in IIS.

但我没有遇到过这个问题，所以我会帮助你让别人帮助你。响应可能会有一些延迟。感谢您的耐心等待。

But I am haven't encountered this problem, so I will help you involve others to help you. There might be some delay about the response. Appreciate your patience.

最诚挚的问候，

这篇关于没有使用Microsoft.ACE.OLEDB.12.0写入excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！