Excel：取消打开大文件 [英] Excel: Cancel Opening of a Large File

问题描述

我经常需要通过VB.net（Visual Studio 2015）打开非常大的Excel文件。 我试图弄清楚用户可以取消的方式。 我能够在后台工作者中打开文件，但我无法弄清楚如何告诉
Excel应用程序对象取消开放。 有人知道吗？  TIA！

I often need to open very large Excel files via VB.net (Visual Studio 2015).  I am trying to figure out a way the user can hit cancel.  I was able to get the opening of the file to happen in a backgroundworker, but I can't figure out how to tell the Excel application object to cancel the opening.  Anyone know?  TIA!

推荐答案

有很多方法可以与Excel交互，也许您可​​以与我们分享您如何与Excel交互，例如Excel自动化并具体说明如何执行打开和读取（如果编辑也包括此内容），还有OleDb，
OpenXML是使用Excel的三种主要方式。

Well there are a great many ways to interact with Excel, perhaps you could share with us how you are interacting with Excel e.g. Excel automation and be specific on how you are performing the open and read (and if edits include this too), there is also OleDb, OpenXML are the three main ways to work with Excel.

记住较少的细节意味着我们需要提出更多问题而更多细节问题。

Remember less details means we need to ask more questions while more details less questions.

这篇关于Excel：取消打开大文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！