VB和Excel项目 [英] vb and excel project

问题描述

嗨

我想制作一个软件来帮助大学教学的东西，以查找有关学科的所有信息，由谁来授课，其中，每个学科的学分不限，...

因此，我的数据已经存在于Excel工作表中，并且我想使用Visual Basic来建立界面，并从Excel工作表中获取数据，因此我需要帮助，在这种情况下如何在VB和Excel之间进行访问，以及对该软件的任何建议以及是否另一个项目看起来像这样

Hi

I want to make a software to help teaching stuff in university to find all info about subjects , who will teach it , where , no of credit hr for each subject,...

So my data already in Excel sheet and I want make interface by using Visual Basic and taken it''s data from Excel sheet, so I want help how I can accessed between VB and Excel in this case and any suggestion for this software and if another project look like this

推荐答案

所以这是一个多用户解决方案，所有用户都应该看到更新的数据?如果正确，我建议扔掉Excel并使用Sql Server.例如，Sql Server Express Edition是免费使用和分发的.请参阅: Microsoft SQL Server Express Edition [

So this is a multi user solution where all of the users should see updated data? If that''s correct, I''d suggest throwing the Excel away and using Sql Server. For example Sql Server Express Edition is free to use and distribute. See: Microsoft SQL Server Express Edition[^]

我想像Mika为此目的，最好使用rdbms，但是如果您确实要使用Excel并且没有共享点服务器，则此库非常有用: ^ ]

最好的问候
Espen Harlinn

Like Mika I think you are probably better off using an rdbms for this purpose, but in case you really want to use Excel and don''t have a sharepoint server then this library is pretty usefull: EPPlus[^]

Best regards
Espen Harlinn

上面给出了很好的建议
但是，如果您别无选择，只能使用Excel和vb6，则可以这样做，但会变得乏味.我相信您会获得一个表格，也许工作人员可以在其中输入他需要的信息，并且可以从excel工作表中获取数据(我希望一旦其中包含数据，此工作表就不会更新).
因此您需要在代码中打开此excel工作表，然后导航到包含数据的确切单元格

参见:

http://www.vbforums.com/showthread.php?t=391665 [ ^ ]

http: //blogs.msdn.com/b/rahulso/archive/2006/12/15/open-excel-file-with-vb6-and-read-the-content.aspx [

excellent advice is given above
but if you have no choice but to use Excel and vb6 only then it can be done but it''ll become tedious. i believe you will have a form maybe where the staff can enter what info he needs and the data can be fetched from the excel sheet (and i hope this sheet is not updated once data is there in it).
so you need to open this excel sheet in your code and navigate to the exact cells which have the data

see:

http://www.vbforums.com/showthread.php?t=391665[^]

http://blogs.msdn.com/b/rahulso/archive/2006/12/15/open-excel-file-with-vb6-and-read-the-content.aspx[^]

these are just pointers to get started you got to google more as you progress or ask it here.

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