Excel外观和要实现的功能 [英] Excel look n feel and functionality to be achieved

问题描述

以下是要求:

很抱歉提供的信息较少:
我正在使用vb.net作为语言在 FORMS 上实现上述任务，并且我使用了Microsoft.Office.作为执行所有与excel相关的工作和后端的参考，Interop.Excel是SQL.


我需要在我要更新的项目中使用Excel工作表的外观(意味着网格状外观)，添加一些候选者的新记录，并从Excel导入到我的sql数据库中，然后从应用程序导出到Excel工作表. br/> 我达到了上述要求，但是我使用了datagridview，现在数据已经增加并且面临很多问题.有时应用程序甚至挂起.
我使用了datagridview的多个事件，可能是导致问题的原因，最后我决定更改方法并从头开始.
谁能建议任何其他控制或任何其他方式来实现上述要求.

只有Guidance才能提供帮助..

Here are the requirements:

I M SORRY FOR PROVIDING LESS INFORMATION:
I am implementing the above task on FORMS using vb.net as language and i have used Microsoft.Office.Interop.Excel as reference for doing all the excel related stuff and backend is SQL.


I need a look and feel of excel sheet(means grid like look and feel) in my project where I want to Update,add new records of some candidates and also import from excel to my sql database n export from application to excel sheet.
I achieved the above requirements but i used datagridview,now the data has increased and much problems are faced..At times the application even hangs.
I have used multiple events of datagridview and may be that is causing the problem and finally i have decided to change the approach and start from scratch.
Can any1 suggest any other control or any other way of achieving the above mentioned requirement.

Only Guidance will also help..

推荐答案

不，我认为此控件最适合您的目的(但是为什么还要制作另一个电子表格呢?).是的，您应该从根本上解决处理大量数据的性能.我已成功使用虚拟模式，请参见 http://msdn.microsoft.com /en-us/library/system.windows.forms.datagridview.virtualmode.aspx [

No, I think this control is the best for your purposes (but why doing another spreadsheet though?). Yes, you should fundamentally address the performance for handling a lot of data. I successfully used virtual mode, see http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.virtualmode.aspx[^].

—SA

这篇关于Excel外观和要实现的功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！