entityMap|blocks|key|8jgdu|text|要打开文件，请尝试执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|75jov|objexcel.Workbooks.Open(@"C:\YourPath\YourExcelFile.xls",
++++missing,+missing,+missing,+missing,+missing,+missing,+missing,
++++missing,+missing,+missing,+missing,+missing,missing,+missing);|code-block|syntax|javascript|ekq7u|你必须提供那些愚蠢的看起来“缺失”的论点。如果您用VB.Net编写相同的代码，就不需要它们了，但是在C#中您无法避免它们。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|K|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|L|9|@]|A|@]|B|$]]]]

For opening a file, try this:

<pre><code>objexcel.Workbooks.Open(@"C:\YourPath\YourExcelFile.xls",
 missing, missing, missing, missing, missing, missing, missing,
 missing, missing, missing, missing, missing,missing, missing);
</code></pre>

You must supply those stupid looking 'missing' arguments. If you were writing the same code in VB.Net you wouldn't have needed them, but you can't avoid them in C#.

entityMap|blocks|key|6n4oq|text|如果你也说出了哪里出了问题，或者在你运行它的时候什么地方失败了，那么帮助你就更容易了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|e1s5h|但快速浏览一下，您会混淆一些事情。|7vorp|由于几个问题，下面的代码不起作用。|1vjp5|if+(Directory("C:\\csharp\\error+report1.xls")+=+"")|code-block|syntax|javascript|3g35f|您要做的是创建一个新的Directory对象，该对象应该指向一个文件，然后检查是否有任何错误。|4utm2|您实际要做的是尝试调用一个名为Directory()的函数，然后将一个字符串分配给结果。这将不起作用，因为1/您没有名为Directory(string+str)的函数，并且您不能将来自函数的结果赋值(您只能为变量赋值)。|7vq3q|您应该做的事情(至少对于这一行)如下所示|9c9hj|FileInfo+fi+=+new+FileInfo("C:\\csharp\\error+report1.xls");
if(!fi.Exists)
{
++++//+Create+the+xl+file+here
}
else
{
++++//+Open+file+here
}|9opdu|至于为什么Excel代码不起作用，你必须查看google应该能够为你提供的Excel库的文档。^0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|V|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|W|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|X|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|Y|9|@]|A|@]|B|$J|K]]|$2|L|4|M|6|7|8|Z|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|10|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|11|9|@]|A|@]|B|$]]|$2|R|4|S|6|I|8|12|9|@]|A|@]|B|$J|K]]|$2|T|4|U|6|7|8|13|9|@]|A|@]|B|$]]]]

It's easier to help you if you say what's wrong as well, or what fails when you run it.

But from a quick glance you've confused a few things.

The following doesn't work because of a couple of issues.

<pre><code>if (Directory("C:\\csharp\\error report1.xls") = "")
</code></pre>

What you are trying to do is creating a new Directory object that should point to a file and then check if there was any errors. 

What you are actually doing is trying to call a function named Directory() and then assign a string to the result. This won't work since 1/ you don't have a function named Directory(string str) and you cannot assign to the result from a function (you can only assign a value to a variable).

What you should do (for this line at least) is the following

<pre><code>FileInfo fi = new FileInfo("C:\\csharp\\error report1.xls");
if(!fi.Exists)
{
 // Create the xl file here
}
else
{
 // Open file here
}
</code></pre>

As to why the Excel code doesn't work, you have to check the documentation for the Excel library which google should be able to provide for you.

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/438d80590fbbd541d8fa525261117cfe.png|imageAlt|blocks|key|18lgv|text|您需要安装Microsoft+Visual+Studio+Tools+for+Office+(VSTO)。|unstyled|depth|inlineStyleRanges|entityRanges|alqfa|可以在Visual+Studio安装程序中的工作负载>+Web+&+Cloud+>+Office/SharePoint开发下选择VSTO。|5oiqt|之后，创建一个通用的.NET项目并添加对Microsoft.Office.Interop.Excel通过'Add+Reference...+>+Assemblies‘对话框。|1kq38|Application+excel+=+new+Application();
Workbook+wb+=+excel.Workbooks.Open(path);|code-block|syntax|javascript|bcqr1|Missing.Value是一个特殊的反射结构，用于替换不必要的参数。|f59st|7jo6l|在较新的版本中，所需的程序集引用称为Microsoft+Excel+16.0+Object+Library..。如果您没有安装最新版本，您可能已经安装了|7epnb|Microsoft+Excel+15.0+Object+Library，或更早的版本，但包含的过程是相同的。|6l5u7|​|28he8|4stnv|?|atomic|offset|length|e5vhb|7p2nk^0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|19|H|@]|I|@]|6|$]]|$B|J|D|K|2|F|G|1A|H|@]|I|@]|6|$]]|$B|L|D|M|2|F|G|1B|H|@]|I|@]|6|$]]|$B|N|D|O|2|P|G|1C|H|@]|I|@]|6|$Q|R]]|$B|S|D|T|2|F|G|1D|H|@]|I|@]|6|$]]|$B|U|D|-4|2|F|G|1E|H|@]|I|@]|6|$]]|$B|V|D|W|2|F|G|1F|H|@]|I|@]|6|$]]|$B|X|D|Y|2|F|G|1G|H|@]|I|@]|6|$]]|$B|Z|D|10|2|F|G|1H|H|@]|I|@]|6|$]]|$B|11|D|-4|2|F|G|1I|H|@]|I|@]|6|$]]|$B|12|D|13|2|14|G|1J|H|@]|I|@$15|1K|16|1L|B|1M]]|6|$]]|$B|17|D|-4|2|F|G|1N|H|@]|I|@]|6|$]]|$B|18|D|10|2|F|G|1O|H|@]|I|@]|6|$]]]]

You need to have installed Microsoft Visual Studio Tools for Office (VSTO).
VSTO can be selected in the Visual Studio installer under Workloads &gt; Web &amp; Cloud &gt; Office/SharePoint Development.
After that create a generic .NET project and add a reference to <code>Microsoft.Office.Interop.Excel</code> via 'Add Reference... &gt; Assemblies' dialog.
<pre><code>Application excel = new Application();
Workbook wb = excel.Workbooks.Open(path);
</code></pre>
<code>Missing.Value</code> is a special reflection struct for unnecessary parameters replacement
<hr />
In newer versions, the assembly reference required is called <code>Microsoft Excel 16.0 Object Library</code>. If you do not have the latest version installed you might have <code>Microsoft Excel 15.0 Object Library</code>, or an older version, but it is the same process to include.
<a href="https://i.stack.imgur.com/J6wmd.png" rel="noreferrer"><img src="https://i.stack.imgur.com/J6wmd.png" alt="enter image description here" /></a>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-and-java/default.aspx|blocks|key|3533j|text|这是一个商业应用程序还是一些业余爱好者/开源软件？|unstyled|depth|inlineStyleRanges|entityRanges|77kr5|我之所以这样问，是因为根据我的经验，由于不同的原因，所有免费的.NET+Excel处理替代方案都有严重的问题。对于业余爱好者来说，我通常最终会将jExcelApi从Java移植到C#并使用它。|c8abb|但如果这是一个商业应用程序，那么您可以购买第三方库，比如|akupu|Aspose.Cells..。相信我，这绝对是值得的，因为它节省了很多时间，而且时间不是免费的。|offset|length|style|UNDERLINE^0|0|0|0|0|C|0|C|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|S|G|@]|H|@]|6|$]]|$A|I|C|J|2|E|F|T|G|@]|H|@]|6|$]]|$A|K|C|L|2|E|F|U|G|@]|H|@]|6|$]]|$A|M|C|N|2|E|F|V|G|@$O|W|P|X|Q|R]]|H|@$O|Y|P|Z|A|10]]|6|$]]]]

Is this a commercial application or some hobbyist / open source software?

I'm asking this because in my experience, all free .NET Excel handling alternatives have serious problems, for different reasons. For hobbyist things, I usually end up porting jExcelApi from Java to C# and using it.

But if this is a commercial application, you would be better off by purchasing a third party library, like <a href="http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-and-java/default.aspx" rel="nofollow noreferrer">Aspose.Cells</a>. Believe me, it totally worths it as it saves a lot of time and time ain't free.

entityMap|blocks|key|lnrr|text|Microsoft.Office.Interop.Excel.Application+excapp;

excapp+=+new+Microsoft.Office.Interop.Excel.Application();

object+misval=System.Reflection.Missing.Value;

Workbook+wrkbuk+=+new+Workbook();

Worksheet+wrksht+=+new+Worksheet();

wrkbuk+=+excapp.Workbooks._Open(@"C:\Users\...\..._template_v1.0.xlsx",+misval,+misval,+
misval,+misval,+misval,+misval,+misval,+misval,+misval,+misval,+misval,+misval);

wrksht+=+(Microsoft.Office.Interop.Excel.Worksheet)wrkbuk.Worksheets.get_Item(2);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript^0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$C|D]]]]

<pre><code>Microsoft.Office.Interop.Excel.Application excapp;

excapp = new Microsoft.Office.Interop.Excel.Application();

object misval=System.Reflection.Missing.Value;

Workbook wrkbuk = new Workbook();

Worksheet wrksht = new Worksheet();

wrkbuk = excapp.Workbooks._Open(@"C:\Users\...\..._template_v1.0.xlsx", misval, misval, 
misval, misval, misval, misval, misval, misval, misval, misval, misval, misval);

wrksht = (Microsoft.Office.Interop.Excel.Worksheet)wrkbuk.Worksheets.get_Item(2);
</code></pre>

entityMap|blocks|key|cql9h|text|FileInfo+fi+=+new+FileInfo("C:\\test\\report.xlsx");
if(fi.Exists)
{
++++System.Diagnostics.Process.Start(@"C:\test\report.xlsx");
}
else
{
++++//file+doesn't+exist
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript^0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$C|D]]]]

<pre><code>FileInfo fi = new FileInfo("C:\\test\\report.xlsx");
if(fi.Exists)
{
 System.Diagnostics.Process.Start(@"C:\test\report.xlsx");
}
else
{
 //file doesn't exist
}
</code></pre>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://github.com/tonyqus/npoi|blocks|key|cabnk|text|为了在C#应用程序中编辑Excel文件，我最近开始使用NPOI..。我对它非常满意。|unstyled|depth|inlineStyleRanges|offset|length|style|UNDERLINE|entityRanges^0|R|4|R|4|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|M|G|@$H|N|I|O|J|K]]|L|@$H|P|I|Q|A|R]]|6|$]]]]

For editing Excel files from within a C# application, I recently started using <a href="https://github.com/tonyqus/npoi" rel="nofollow noreferrer">NPOI</a>.
I'm very satisfied with it.

entityMap|blocks|key|8grqc|text|你应该像这样打开|type|unstyled|depth|inlineStyleRanges|entityRanges|data|doc1v|Excel.Application+xlApp+;
++++++++Excel.Workbook+xlWorkBook+;
++++++++Excel.Worksheet+xlWorkSheet+;
++++++++object+misValue+=+System.Reflection.Missing.Value;

++++++++xlApp+=+new+Excel.ApplicationClass();
++++++++xlWorkBook+=+xlApp.Workbooks.Open("csharp.net-informations.xls",+0,+true,+5,+"",+"",+true,+Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,+"\t",+false,+false,+0,+true,+1,+0);
++++++++xlWorkSheet+=+(Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);|code-block|syntax|javascript|femrp|来源：http://csharp.net-informations.com/excel/csharp-open-excel.htm|c59s|鲁登^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|O|9|@]|A|@]|B|$]]]]

you should open like this

<pre><code> Excel.Application xlApp ;
 Excel.Workbook xlWorkBook ;
 Excel.Worksheet xlWorkSheet ;
 object misValue = System.Reflection.Missing.Value;

 xlApp = new Excel.ApplicationClass();
 xlWorkBook = xlApp.Workbooks.Open("csharp.net-informations.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
 xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
</code></pre>

source : <a href="http://csharp.net-informations.com/excel/csharp-open-excel.htm" rel="nofollow">http://csharp.net-informations.com/excel/csharp-open-excel.htm</a>

ruden

entityMap|blocks|key|6akre|text|private+void+btnChoose2_Click(object+sender,+EventArgs+e)
{
++OpenFileDialog+openfileDialog1+=+new+OpenFileDialog();
++if+(openfileDialog1.ShowDialog()+==+System.Windows.Forms.DialogResult.OK)
++{
++++this.btnChoose2.Text+=+openfileDialog1.FileName;
++++String+filename+=+DialogResult.ToString();

++++var+excelApp+=+new+Excel.Application();
++++excelApp.Visible+=+true;
++++excelApp.Workbooks.Open(btnChoose2.Text);
++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript^0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$C|D]]]]

<pre><code>private void btnChoose2_Click(object sender, EventArgs e)
{
 OpenFileDialog openfileDialog1 = new OpenFileDialog();
 if (openfileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
 {
 this.btnChoose2.Text = openfileDialog1.FileName;
 String filename = DialogResult.ToString();

 var excelApp = new Excel.Application();
 excelApp.Visible = true;
 excelApp.Workbooks.Open(btnChoose2.Text);
 }
}
</code></pre>

entityMap|blocks|key|3u2k1|text|代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7fb2p|private+void+button1_Click(object+sender,+EventArgs+e)
+++++{

++++++++textBox1.Enabled=false;

++++++++++++OpenFileDialog+ofd+=+new+OpenFileDialog();
++++++++++++ofd.Filter+=+"Excell+File+%7C*.xlsx;*,xlsx";
++++++++++++if+(ofd.ShowDialog()+==+DialogResult.OK)
++++++++++++{
++++++++++++++++string+extn+=+Path.GetExtension(ofd.FileName);
++++++++++++++++if+(extn.Equals(".xls")+%7C%7C+extn.Equals(".xlsx"))
++++++++++++++++{
++++++++++++++++++++filename+=+ofd.FileName;

++++++++++++++++++++if+(filename+!=+"")
++++++++++++++++++++{
++++++++++++++++++++++++try
++++++++++++++++++++++++{
++++++++++++++++++++++++++++string+excelfilename+=+Path.GetFileName(filename);


++++++++++++++++++++++++}
++++++++++++++++++++++++catch+(Exception+ew)
++++++++++++++++++++++++{
++++++++++++++++++++++++++++MessageBox.Show("Errror:"+%2B+ew.ToString());
++++++++++++++++++++++++}
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

Code :

<pre><code> private void button1_Click(object sender, EventArgs e)
 {

 textBox1.Enabled=false;

 OpenFileDialog ofd = new OpenFileDialog();
 ofd.Filter = "Excell File |*.xlsx;*,xlsx";
 if (ofd.ShowDialog() == DialogResult.OK)
 {
 string extn = Path.GetExtension(ofd.FileName);
 if (extn.Equals(".xls") || extn.Equals(".xlsx"))
 {
 filename = ofd.FileName;

 if (filename != "")
 {
 try
 {
 string excelfilename = Path.GetFileName(filename);


 }
 catch (Exception ew)
 {
 MessageBox.Show("Errror:" + ew.ToString());
 }
 }
 }
 }
</code></pre>

entityMap|blocks|key|68e7b|text|导入|type|unstyled|depth|inlineStyleRanges|entityRanges|data|e7153|using+Excel=+Microsoft.Office.Interop.Excel;
+using+Microsoft.VisualStudio.Tools.Applications.Runtime;|code-block|syntax|javascript|6vp7i|下面是使用C#打开excel工作表的代码。|pira|Microsoft.Office.Interop.Excel.Application+excel+=+new+Microsoft.Office.Interop.Excel.Application();
++++Microsoft.Office.Interop.Excel.Workbook+wbv+=+excel.Workbooks.Open("C:\\YourExcelSheet.xlsx");
++++Microsoft.Office.Interop.Excel.Worksheet+wx+=+excel.ActiveSheet+as+Microsoft.Office.Interop.Excel.Worksheet;

++++wbv.Close(true,+Type.Missing,+Type.Missing);
++++excel.Quit();|apare|下面是关于如何使用C#打开excel工作表的视频伙伴|cbft8|https://www.youtube.com/watch?v=O5Dnv0tfGv4^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|P|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|Q|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|R|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|S|9|@]|A|@]|B|$F|G]]|$2|L|4|M|6|7|8|T|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|U|9|@]|A|@]|B|$]]]]

Imports

<pre><code> using Excel= Microsoft.Office.Interop.Excel;
 using Microsoft.VisualStudio.Tools.Applications.Runtime;
</code></pre>

Here is the code to open an excel sheet using C#.

<pre><code> Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
 Microsoft.Office.Interop.Excel.Workbook wbv = excel.Workbooks.Open("C:\\YourExcelSheet.xlsx");
 Microsoft.Office.Interop.Excel.Worksheet wx = excel.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet;

 wbv.Close(true, Type.Missing, Type.Missing);
 excel.Quit();
</code></pre>

Here is a video mate on how to open an excel worksheet using C# <a href="https://www.youtube.com/watch?v=O5Dnv0tfGv4" rel="nofollow">https://www.youtube.com/watch?v=O5Dnv0tfGv4</a>

I am trying to convert some <a href="http://en.wikipedia.org/wiki/Visual_Basic_for_Applications" rel="noreferrer">VBA</a> code to C#. I am new to C#. Currently I am trying to open an Excel file from a folder and if it does not exist then create it. I am trying something like the following. How can I make it work?

<pre><code>Excel.Application objexcel;
Excel.Workbook wbexcel;
bool wbexists;
Excel.Worksheet objsht;
Excel.Range objrange;

objexcel = new Excel.Application();
if (Directory("C:\\csharp\\error report1.xls") = "")
{
 wbexcel.NewSheet();
}

else
{
 wbexcel.Open("C:\\csharp\\error report1.xls");
 objsht = ("sheet1");
}
objsht.Activate();
</code></pre>

How to open an Excel file in C#?

Visual Studio

Windows

Java

 我正在试着转换一些VBA  C#的代码。我是C#的新手。目前，我正在尝试打开文件夹中的Excel文件，如果该文件不存在，则创建它。我正在尝试下面这样的东西。我怎么才能让它工作呢？ Excel.Application objexcel;Excel.Workbook wbexcel;bool wbexists;Excel...

问如何在C#中打开Excel文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在C#中打开Excel文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在C#中打开Excel文件？
EN