请问我的如下代码出现什么问题,为什么不能打开Excel文件,请解救,不甚感激。class Program
{
static void Main(string[] args)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook workbook = null;
string str = @"E:\test.xlsx"; try
{
workbook = xlApp.Workbooks.Open(str);
Console.WriteLine("Succeed");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
xlApp.Quit();
if (workbook != null)
{
workbook.Close(null, null, null);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
}
if (xlApp != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
xlApp = null;
}
GC.Collect();
}
Console.ReadLine();
}
}结果出现如下问题:
{
static void Main(string[] args)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook workbook = null;
string str = @"E:\test.xlsx"; try
{
workbook = xlApp.Workbooks.Open(str);
Console.WriteLine("Succeed");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
xlApp.Quit();
if (workbook != null)
{
workbook.Close(null, null, null);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
}
if (xlApp != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
xlApp = null;
}
GC.Collect();
}
Console.ReadLine();
}
}结果出现如下问题:
解决方案 »
- 错在哪里了为什么读取出来打开word里面只显示:System.Byte[]这几个字
- Javascript 怎么调用CS中查到数据,并且怎么实现循环??
- 请帮忙解释一下这句C#代码是什么意思.
- 求助为将对象引用设置到对象实例
- winform validation
- 救助:“/FileUpLoad”应用程序中的服务器错误。已经选中文件了。如何调试?
- wpf中,如何用若干点动态组成一个bitmap?
- axWebBrowser VS HttpWebRequest的挑战(高手过招)
- 这个你会吗?
- C# 引用VC++编的 .lib .dll
- DockPanel的贴边隐藏问题
- WPF怎么实现ListBox中的数据循环滚动
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Workbook wBook = null;
Worksheet wSheet = null;
object oMissiong = System.Reflection.Missing.Value;
wBook = app.Workbooks.Open(excelFileName, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong,
oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong);
wSheet = wBook.Worksheets.get_Item(1);//读取第一张表
Workbook wBook = null;
Worksheet wSheet = null;
object oMissiong = System.Reflection.Missing.Value;
wBook = app.Workbooks.Open(excelFileName, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong,
oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong);
wSheet = wBook.Worksheets.get_Item(1);//读取第一张表 我在执行到app.Workbooks.Open时就报错,报错提示是服务器出现意外情况。 (异常来自 HRESULT:0x80010105 (RPC_E_SERVERFAULT))。。求解!!!谢谢
把Microsoft.Office.Interop.Excel的Visible设置为true,我之前也没遇到这个问题。但win10升级到红石版本后就这样了,必须可见才能打开,不知是否有更好的解决办法
把Microsoft.Office.Interop.Excel的Visible设置为true,我之前也没遇到这个问题。但win10升级到红石版本后就这样了,必须可见才能打开,不知是否有更好的解决办法将Microsoft.Office.Interop.Excel的Visible设置为true能解决问题,奇怪的是后来重新设为false也能正常运行,不知根源在哪里
(另外当时我是用PB通过OLE操作excle)