entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://github.com/closedxml/closedxml|blocks|key|4vo4q|text|我推荐使用Closed+XML|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|e06ga|您可以直接写入文件，而不需要Excel。它需要是Excel文件的最新版本才能工作(开放的xml标准)。|2h219^0|5|A|0|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|N|G|@]|H|@$I|O|J|P|A|Q]]|6|$]]|$A|K|C|L|2|E|F|R|G|@]|H|@]|6|$]]|$A|M|C|-4|2|E|F|S|G|@]|H|@]|6|$]]]]

I recommend using <a href="https://github.com/closedxml/closedxml" rel="nofollow noreferrer">Closed XML</a> 

You write to the file directly and don't need Excel. It will need to be the latest version of an Excel file to work (The open xml standard).

entityMap|blocks|key|aa7fs|text|Epplus.dll或npoi.dll也可以读/写不带excel的excel文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|cgr3k^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|D|9|@]|A|@]|B|$]]|$2|C|4|-4|6|7|8|E|9|@]|A|@]|B|$]]]]

Epplus.dll or npoi.dll will also read/write to excel files w/o excel.

entityMap|blocks|key|6bg5s|text|我没有专门通过wpf做到这一点，但是您可以通过.net访问powershell+cmdlet，powershell具有检索和写入Excel数据的命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8i90t|也就是说，我的经验是它非常单调乏味，而且与bug不一致。我要告诉您的客户，使用Excel文件作为数据库是不可能的，而且在实践中肯定容易失败。|5l4u5|首先，如果它被其他东西使用，你会遇到读/写限制。|1bm8t^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|I|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|J|9|@]|A|@]|B|$]]|$2|G|4|-4|6|7|8|K|9|@]|A|@]|B|$]]]]

I haven't done this specifically through wpf, but you can access powershell cmdlets through .net and powershell has commands for retrieving and writing Excel data.

That said, my experience has been it's very tedious and inconsistent with bugs. I would tell your client that using an Excel file as a database is impossible and certainly prone to failure in practice.

For one thing you will run into read/write restrictions if it is used by anything else.

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://docs.aspose.com/display/cellsnet/Home|blocks|key|a3l65|text|如果你不介意使用商业类库，你可以尝试使用Aspose.Cells。它具有丰富的cells+API，并且能够在没有Excel互操作API的情况下工作。|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|a3i5i^0|K|C|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|L|G|@]|H|@$I|M|J|N|A|O]]|6|$]]|$A|K|C|-4|2|E|F|P|G|@]|H|@]|6|$]]]]

If you don't mind to use comercial libraries, you can try to use <a href="https://docs.aspose.com/display/cellsnet/Home" rel="nofollow noreferrer">Aspose.Cells</a>. It has rich cells API and able to work without Excel interop API.

entityMap|blocks|key|32voc|text|将数据保存在XML或JSON文件中，然后当您想要可视化它们时，您可以从这些数据创建excel文件，因此您将拥有一个非常轻量级的文件，并且如果您愿意，可以轻松地读取和更新。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7drgf^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|D|9|@]|A|@]|B|$]]|$2|C|4|-4|6|7|8|E|9|@]|A|@]|B|$]]]]

Save the data in an XML or JSON file, then when you want to visualize them you create the excel file from these data, so you will have a very light file and easy to read and update if you wish.

This Question might be repeated, But I couldn't get solution regarding my problem so far. I'm new to Interop. I'm using excel file (as a database). 
Here is data presentation in excel file

<a href="https://i.stack.imgur.com/Eoqdb.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Eoqdb.jpg" alt="enter image description here"></a>

in my data If Card ID repeated then I need to increment '1' in Counter in the same row, similarly I need to fetch IP address of same row..

I'm using Interop Excel approach to insert data in excel file..
Kindly tell me how can I perform that update operation to that excel file through C# (WPF)

Sorry for bad English.. 

Thanks

How to update data in excel File using C#?

数据库

JSON

 这个问题可能会重复，但到目前为止，我还没有得到关于我的问题的解决方案。我是Interop的新手。我使用的是excel文件(作为数据库)。以下是excel文件中的数据演示 ​ ? ​ 在我的数据中，如果Card ID重复，那么我需要在同一行的计数器中增加'1‘，类似地，我需要获取同一行的IP地址。 我正在使用Inter...

问如何用C#更新excel文件中的数据？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用C#更新excel文件中的数据？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用C#更新excel文件中的数据？
EN