Development Technology of Excel Data Server Application with DELPHI ADO + RemObjectcs Combined (Part 1: The Server Side)

Abstract:

Microsoft office Excel is an important part of the Microsoft Office suite of software that can be processed, statistical analysis of various data, with its quick style and rich functionality has been generally welcomed, but with the database networking and sharing trends deepening, Excel application bottlenecks in stand-alone mode began to appear, and the network is the computer information technology in today's inevitable end, I imagine combining ADO technology developed by Delphi Excel data server in order to break this limitation, changes in non-network applications Excel mode.Excel Data Server is a set of services and client program, the server deployed on the server, the client is retrieved by the query language SQL, Excel data file can perform various operations and customer interface directly to form a Web-based application systems, customer service not only to support the application at both ends of the LAN, you can also support the application on the Internet. In this paper, Delphi7.0 support, using ADO and RemObjects SDK tools to develop an Excel data server. RemObjects referred to RO. RO version a lot, but it is recommended to use RemObjects Data Abstract 6.0.43.801, Delphi's experience in the development of it appear to be more stable, server-side and client-side data connections and programming efficiency, data manipulation more convenient.

• Periodical: Applied Mechanics and Materials (Volumes 727-728)
• Pages: 959-964
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.727-728.959
• Online since: January 2015
• Authors: Hai Zhong Yan
• Keywords: Client/Server, Excel Data Services, RemObjects SDK

References

[1] SU zhihua, YANG dongqing, TANG shiwei, WANG tengjiao.  Entity Recognition based on structural analysis and information integration [J]. Computer Research and Development. 2004(10).

[2] LIU yi. Delphi object-oriented programming ideas [M]. Machinery Industry Press：2003. 9.

[3] http: /pan. baidu. com/share/link?shareid=362747&uk=990036834&fid=2713565019.

[4] http: /www. pudn. com/downloads180/sourcecode/middleware/detail836752. html.

[5] YAN haizhong. Multi-tier distributed database development, supported by Socket Connection component with DELPHI(series lecture) [J]. Computer programming and maintenance tips. 2011. 23.

[6] YAN haizhong. With Delphi + IntraWeb development of dynamic web technology (series lecture). Computer programming and maintenance tips [J]. 2008. 1-2.

[7] SUN qi, CHENG hongmei. Structured Query Language and application examples [J]. Computer Knowledge and Technology. 2003 (35).

[8] LIU rong, CHENG hongmei. Structured Query Language practical tips [J]. Computer Knowledge and Technology. 2004 (02).

[9] ZHANG erfeng, WANG xiapeng. Methods to use Structured Query Language (SQL) [J]. Journal of Kaifeng University. 2001 (02).

[10] ZHANG danian, LIAO zhiyong, LIU jianfeng ect. [M]. Borland Delphi database application development technology and examples. Tsinghua University Press: 2002. 3.

[11] JIANG fangshuang. Borland Delphi programming [M]. Tsinghua University Press ：2002. 4.

[12] PU xiaoyan. Based EXCEL data reporting system research and implementation [J]. Information and Technology. 2010. 12.

[13] CHENG li. Application about EXCEL in data processing [J]. Computer Knowledge and Technology. 2008. 17.