复杂的Excel导入导出 [英] Complex excel import export

问题描述

我想在Datagridview中导入和导出Complex excel，并且根据那个excel进行一些计算，就像已经存在的数量一样，如果我导入新的excel而不是那个数量，根据他们的产品和价格以及执行的总数进行添加它自我。我怎样才能在C＃widnows应用中做到这一点？



我尝试过的方法：



我尝试了自己，但我找到了我们使用的具体事情并执行了这些事情

解决方案

参见使用MS Excel（xls / xlsx）使用MDAC和Oledb [< a href =http://www.codeproject.com/Articles/37055/Working-with-MS-Excel-xls-xlsx-Using-MDAC-and-Oledtarget =_ blanktitle =New Window> ^ ]。

I Want to import and export Complex excel in Datagridview and as per that excel some calculation happening like already existing quantity and if i import new excel than that quantity make addition as per their product and its price as well as total that also perform it self. How can i does this things in C# widnows applicatation?

What I have tried:

I tried my self but i kind find out specific things which we used and perform this things

解决方案

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^].

这篇关于复杂的Excel导入导出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！