The Construction And Realization Of An Electronic Book Acquisition Assistant System Based On VBA

With the rapid development of e-book publishing industry and the increasing number of e-books,the demand for individualized services in university libraries is increasing.The acquisition function design of Huiwen system and the acquisition function design of e-book supplier's system are also very deficient.The difficulties faced by the acquisition staff are getting bigger and bigger.Therefore,according to the characteristics of the library's own work Point,to design a set of procedures can work to simplify and improve efficiency.With computer technology as good helper,is the only way to solve the current dilemma.Thus,it can be seen that it is necessary to construct an electronic book acquisition assistant system.Through investigation and research,this paper analyses all kinds of difficulties encountered in the acquisition of electronic books.In view of the difficulties encountered in the author's own work,this paper uses VBA language to redevelop Excel.By using Dictionary,Array,Replace and Hash table methods,it designs three algorithms such as data comparison,data Replacement and data extraction.This method simulates the manual process and carries out checking,collating and personalized extraction of e-book lists,which improves the efficiency of the program,shortens the calculation time and improves the work efficiency.On this basis,an e-book acquisition assistant system with rich functions and simple operation is constructed.The system plan mainly consists of five functional modules:condition-validating module,order-filtering module,collection-comparing module,order-generating module and one-click subscription modulue.It mainly implements the following three algorithms:Firstly,in order-filtering module,combining the functions of Dictionary and Array,an initial order cycle decision algorithm is designed.This module mainly realizes the determination of book price,publishing time,special characters and renamed books.In the process of programming,according to the analysis,the flow chart is exported.Then,according to the flow chart,a circular decision algorithm is designed to complete four decisions.Firstly,Set dictionaries and Arrays,define the data,then use the "if" statement to write price determination code,then use nested "if" statement to write publication date determination code.Next,we use Instr function and Array Array function to write special character determination code.Then the function of "Dictionary" is used to complete the screening of duplicate titles.Finally,the undetermined bibliography is formed by Countif function and find function.The module is designed and the experimental data is accurate and the system works wellSecondly,in the collection-comparing module,it mainly solves the checking between bookseller's orders and the collection of the library.In this module,first of all,import the collection data,then use a "Replace" command to Replace the special characters in the collection,use "hash table" to calculate the number of duplicate books,and finally combine "hash table","Array" and "Replace" to design a duplicate books searching algorithm.After the design is completed,the test results show that the data is correct and put into use with good results.Thirdly,in the one-click subscription modulue,"hash table" and "nested loop" are used to design the classification algorithm of class number extraction.The librarian organize the curriculum of each college to form a reference classification table for book purchasing.Then the Hash table is used to extract the classification number of booksellers' orders,establish the class number warehouse,and memorize the first line and the number of repetitive lines.Then,the classification extraction algorithm is designed by using compound loop.In this loop,four For...Next" and three "Do...Loop" loop statements are used,.With function nested together,the loop plays a more powerful role,making the program more useful.The first layer is used to control the cycle of row number "m" in the class number warehouse.The second layer is used to control the cycle of column number "k" in the class number warehouse.The third layer is used to control the cycle of College classification number "l".And the fourth layer is used to control the cycle of College "i".The module uses "hash table" and" nested loop" to design the classification algorithm.After the internal operation is completed,the e-books related to the six majors in our school are screened out from the sample book list.And the librarian can directly export the forms and send them to the college for subscription.