Description: Excel表格是输入输出经常需要涉及到的。操作Excel表格的方式也多种多样。比如，通过调用Excel程序的COM组件对Excel进行操作。但是，这种方式限制较多，且实现难度比较大。但是，用于访问数据库的组件ADO，是支持多种数据源的，其中就包括Excel文件。我们可以通过ADO组件对Excel文件进行读写访问。当然，在.NET平台上对应ADO数据访问组件的是ADO.NET组件。我编写的这个类就是通过ADO.NET实现了Excel文件的读写。由于时间仓促，功能还不是很完善，会在以后有时间的时候进行版本升级。也请各位高手多多批评指正。
-Excel spreadsheet input and output is often of the need to address. Operation Excel variety of ways. For example, by calling the Excel COM procedures for the operation of Excel. However, this approach is more limited and more difficult to achieve. However, for access to the database components ADO, is to support multiple data sources, including Excel file. We can ADO components to read and write Excel files visit. Of course,.NET platform counterparts ADO data access components of ADO.NET components. I prepared this category is achieved through ADO.NET read and write Excel files. Because time is so short, the function is still not perfect, will in future have the time for version upgrades. Members also criticized many experts correct. Platform: |
Size: 12983 |
Author:冷寒 |
Hits:
Description: 在DELPHI中使用ADO控件连接MS EXCEL的简单例子，比较简单，挺好用的，有兴趣可以试试。-used in Delphi ADO connection MS Excel simple example, relatively simple, very good use, and are interested can try. Platform: |
Size: 321081 |
Author:孙克再 |
Hits:
Description: 用 vsFlexGrid 时，如果用 Add 方法逐个添加数据，跟在 Excel 中用Range()设置单元格的数据一样的慢，所以需要有些技巧，举例来说：在Excel中填写一个数据区域，可以将将要填写进去的数据按单元格的排列事先加入相应的制表符以及回车符号，组合成一个大的字符串，然后帖进去，会很快。
VsFlexGrid 在需要填充的数据多时会比较慢，同样条件的前提下，VB会明显快些！
数据加载速度慢可以通过直接绑定ADO的记录集，那样会很快，只是显得没有个性。比如从后台取回的数据是个数字，在前台需要根据这个数字分情况来显示各种不同的字符，如果用RecordSet我不知道怎么搞了。。
vsFlexGrid 的慢是一个问题，也许还比较好避免，也许这并不是他本身的问题，好像很多的控件只要是逐个ADD的都不会快多少，除非用直接绑定！
更麻烦的还是从vsFlexGrid到vsPrinter的报表显示显得有点牵强~~，不过常规的报表都还可以应付，象我们的工资明细表、汇总表、储备金汇总、储备金明细、计件工资、花名册、考勤报表乃至工资条等都可以用vsFlexGrid解决，而且能做出比较漂亮的效果，尤其那个表格的合并效果，以及所见所得。。。
-with vsFlexGrid, when used individually Add method to add data with Excel using Range () set up the cell for the same data slow, there is a need in some skills, for example : Excel to fill in a data area can be filled out to be of the data into cells with the prior joining the corresponding tabs and carriage return symbols, as a large portfolio of strings, and then into TIE will soon. VsFlexGrid need to fill in the data for some time will be relatively slow and the same conditions, under the premise of VB will be significantly faster! Data loading slow through direct bonding ADO record set, as it will soon, it is not personality. For example, to recover from the background information is in the number of prospects according to the breakdown of the figures to show a variety of characters, i Platform: |
Size: 602351 |
Author:胡先生 |
Hits:
Description: Excel表格是输入输出经常需要涉及到的。操作Excel表格的方式也多种多样。比如，通过调用Excel程序的COM组件对Excel进行操作。但是，这种方式限制较多，且实现难度比较大。但是，用于访问数据库的组件ADO，是支持多种数据源的，其中就包括Excel文件。我们可以通过ADO组件对Excel文件进行读写访问。当然，在.NET平台上对应ADO数据访问组件的是ADO.NET组件。我编写的这个类就是通过ADO.NET实现了Excel文件的读写。由于时间仓促，功能还不是很完善，会在以后有时间的时候进行版本升级。也请各位高手多多批评指正。-Excel spreadsheet input and output is often of the need to address. Operation Excel variety of ways. For example, by calling the Excel COM procedures for the operation of Excel. However, this approach is more limited and more difficult to achieve. However, for access to the database components ADO, is to support multiple data sources, including Excel file. We can ADO components to read and write Excel files visit. Of course,.NET platform counterparts ADO data access components of ADO.NET components. I prepared this category is achieved through ADO.NET read and write Excel files. Because time is so short, the function is still not perfect, will in future have the time for version upgrades. Members also criticized many experts correct. Platform: |
Size: 4863 |
Author:张雪涛 |
Hits:
Description: 演示了在VC中操作ADO的一般方法，给出了一个操作ADO的强大的类以及利用该类实现数据库操作的一个实例.. -demonstrated in VC ADO operation of the general method is a powerful operating ADO class and the use of database operations such an example .. Platform: |
Size: 1877 |
Author:雪 |
Hits:
Description: 演示了在VC中操作ADO的一般方法，给出了一个操作ADO的强大的类以及利用该类实现数据库操作的一个实例.. -demonstrated in VC ADO operation of the general method is a powerful operating ADO class and the use of database operations such an example .. Platform: |
Size: 2048 |
Author:雪 |
Hits:
Description: Excel表格是输入输出经常需要涉及到的。操作Excel表格的方式也多种多样。比如，通过调用Excel程序的COM组件对Excel进行操作。但是，这种方式限制较多，且实现难度比较大。但是，用于访问数据库的组件ADO，是支持多种数据源的，其中就包括Excel文件。我们可以通过ADO组件对Excel文件进行读写访问。当然，在.NET平台上对应ADO数据访问组件的是ADO.NET组件。我编写的这个类就是通过ADO.NET实现了Excel文件的读写。由于时间仓促，功能还不是很完善，会在以后有时间的时候进行版本升级。也请各位高手多多批评指正。
-Excel spreadsheet input and output is often of the need to address. Operation Excel variety of ways. For example, by calling the Excel COM procedures for the operation of Excel. However, this approach is more limited and more difficult to achieve. However, for access to the database components ADO, is to support multiple data sources, including Excel file. We can ADO components to read and write Excel files visit. Of course,.NET platform counterparts ADO data access components of ADO.NET components. I prepared this category is achieved through ADO.NET read and write Excel files. Because time is so short, the function is still not perfect, will in future have the time for version upgrades. Members also criticized many experts correct. Platform: |
Size: 20480 |
Author:冷寒 |
Hits:
Description: 在DELPHI中使用ADO控件连接MS EXCEL的简单例子，比较简单，挺好用的，有兴趣可以试试。-used in Delphi ADO connection MS Excel simple example, relatively simple, very good use, and are interested can try. Platform: |
Size: 320512 |
Author:孙克再 |
Hits:
Description: Visual.C++程序设计技巧与实例--配套光盘
第10章 ACITVEX
本章共有两个实例：
1. RegActiveX编程注册ActiveX控件
2. PJ牌九ActiveX控件制作实例
第11章 调试技术
本章共有两个实例：
1. ConsoleTrace在控制台程序中使用TRACE宏
2. MemLeakCheck内存泄漏的例子
第12章 VC数据库编程
本章共6个实例：
1. MyOdbcSample使用ODBC访问数据库
2. MyOdbcExcel动态加载ODBC数据源
3. Abc使用DAO进行数据库开发
4. MyOLEDBSample使用OLE DB进行数据库编程
5. ADOTEST1使用ADO进行数据库开发
6. MyAdoBlob如何使用VC++存取数据库中的大对象-Visual.C program design techniques and examples-- matching CD Chapter 10 of this chapter ACITVEX Two examples : 1. RegActiveX registered ActiveX Programming 2. PJ Play ActiveX produced examples of Chapter 11 of this chapter debugging techniques were two examples : 1. ConsoleTrace console procedures in the use of TRACE-2. MemLeakCh eck memory leak example Chapter 12 VC Database Programming chapter has six examples : 1. MyOdbcSample use ODBC database 2. Dynamic MyOdbcExcel Add 3 ODBC data source. Abc use DAO for database development 4. MyOLEDBSampl e use OLE DB database programming 5. ADOTEST1 use ADO database development 6. M VC yAdoBlob how to use the database to access large object Platform: |
Size: 1634304 |
Author:xixi |
Hits:
Description: 一个简单明白的使用VB6操作Excel的例子，没有经验的初学者也能看明白的。-Understand the use of a simple operation of Excel VB6 example, inexperienced beginners Nengkanmingbai' s. Platform: |
Size: 1024 |
Author:sicool |
Hits:
Description: 1、后台管理员：admin；密码：admin
2、内有20位学生帐号；帐号：1，密码1；帐号：2，密码2……
3、练习模式也要登陆，但不记录分数。
4、考试模式需在后台设置试卷后，一考试帐号只能参加一次。
5、本系统可批量导入试题，但asp的ADO读取EXCEL数据时同一列数据遇到不同数据类型时中断，并不是以空记录中断，填写导入的EXCEL时请保持相同的数据类型；遇到此问题时可以用ACCESS软件打开数据库，然后在“文件”－》“获取外部数据”－》“导入”，然后选择EXCEL文件导入相应的表。
6、checkbox 的值是一个逗号加一个空格分隔的，因此多选题批量导入时，导入文件的正确答案请按选项的顺序填写，并以逗号加一个空格分隔。
例：答案为ABC，正确格式为“A, B, C”。“A,B,C”，“B, A, C”都为错误格式。
7、本系统修改于网上的考试系统，版权归原作者所有。
8、如需程序定制，如考试内容指定知识点等，请QQ联系171643253.
huahaisoft-1, background admin manager: Password: admin
2, has 20 students account Account: 1, the password 1 Account: 2, the password 2...
3, practise mode will log in, but not recorded scores.
4, examination mode should set in the background, a test paper after examination account could only join again.
5, this system can be batch import questions, but asp ADO data read EXCEL same column data to meet different data types, is not empty when interrupt record interrupt, fill in import EXCEL when please keep the same data types, Encounter this problem can use ACCESS database software, then open the document "- >" obtain external data "- >" induction ", select the EXCEL file keyword corresponding table.
6, checkbox value is a comma add a blank space, so multiple-choice questions, import documents batch import the correct answer please click option order fill in, and with a comma add a blank space.
Example: the answer for ABC, correct format for "A, B, C". "A, B, C", Platform: |
Size: 139264 |
Author:葛冰 |
Hits:
Description: huahaisoft 考试系统v2.0介绍
1、后台管理员：admin；密码：admin
2、2.0增加了多选题、简答题。
3、练习模式也要登陆，但不记录分数。
4、考试模式需在后台设置试卷后，一考试帐号只能参加一次。
5、本系统可批量导入试题，但asp的ADO读取EXCEL数据时同一列数据遇到不同数据类型时中断，并不是以空记录中断，填写导入的EXCEL时请保持相同的数据类型；遇到此问题时可以用ACCESS软件打开数据库，然后在“文件”－》“获取外部数据”－》“导入”，然后选择EXCEL文件导入相应的表。
6、checkbox 的值是一个逗号加一个空格分隔的，因此多选题批量导入时，导入文件的正确答案请按选项的顺序填写，并以逗号加一个空格分隔。
例：答案为ABC，正确格式为“A, B, C”。“A,B,C”，“B, A, C”都为错误格式。
7、本系统程序核心来源于网络，该部分版权归原作者所有。-huahaisoft Test System v2.0 Introduction
1, background administrator: admin Password: admin
2,2.0 increase of multiple choice, short answer questions.
3, also landing practice mode, but does not record scores.
4, the test mode to be set in the background papers, after a test account can only enter once.
5, the system can bulk import item, but the asp of the ADO to read data in EXCEL data encountered the same column with different data types interrupted, the interrupt is not to empty record, fill in EXCEL when imported to maintain the same data type experience This problem can open the database using ACCESS software, and then in the "File"- "" Get External Data "-" "Import", then select the EXCEL file into the appropriate table.
6, checkbox s value is a space separated by a comma, so the multiple choice batch import, the import file the correct answer, please fill out the order by option and a space separated by commas.
Example: The answer to ABC, the correct format for Platform: |
Size: 132096 |
Author:田旭 |
Hits:
Description: VC2005利用ADO读Excel2007文件示例
1建立基于对话框的MFC程序
2引入库文件
3在对话框中的确定按钮上添加响应事件OnBnClickedOk()
4在事件OnBnClickedOk()中写代码
-VC2005 read Excel2007 file using ADO Example 1 MFC dialog-based program established to introduce library 2 3 OK button in the dialog box to add response to events OnBnClickedOk () 4 in the event OnBnClickedOk () to write code Platform: |
Size: 8192 |
Author:ruler |
Hits:
Description: delphi里操作Excel数据导入ListView及ListView导出到Excel，并通过ADO对Mdb及查询并将查询结果反馈到ListView表格内的例子。对于新手学习挺全面的。-delphi import Excel data or operational ListView ListView and export to Excel, and through the ADO Mdb and query and query results back to the ListView table example. For the novice to learn quite comprehensive. Platform: |
Size: 3072 |
Author:MirZhang |
Hits:
Description: Ⅰ）将Excel97或Excel2000生成的XLS文件（book）看成一个数据库，其中的每一个工作表(sheet)看成数据库表
Ⅱ）ADO假设Excel中的第一行为字段名.所以你定义的范围中必须要包括第一行的内容
Ⅲ）Excel中的行标题（即字段名）不能够包含数字. Excel的驱动在遇到这种问题时就会出错的。例如你的行标题名为"F1"
Ⅳ）如果Excel表中某一列同时包含了文本和数字的话,那么Excel的ODBC驱动将不能够正常处理这一行的数据类型，你必须要保证该列的数据类型一致(加入预设符号强制转成文本，后台再作处理)
Ⅴ）日期型时，整列不能有空格，否则读不出- Ⅰ) will Excel97 or Excel2000 generated XLS file (book) as a database, where each worksheet (sheet) as a database table
Ⅱ) ADO assumption Excel field names in the first row, so you define the scope of the contents must include the first row
Ⅲ) Excel in a row heading (ie field names) can not contain numbers. Excel driver in the face of this problem will go wrong. For example, your line entitled "F1"
Ⅳ) If Excel table contains a column of text and numbers, then the Excel ODBC driver will not be able to properly handle this type of data rows, you must ensure that consistent data type of the column (added to the default symbol compulsory transfer into text, the background for further processing)
Ⅴ) Date type, the entire column can not have spaces, otherwise I can not reproduce Platform: |
Size: 9216 |
Author:lintao |
Hits:
Search - excel ado example