KR100369512B1 - Processing method for providing programmable sheet on the web - Google Patents

Abstract

The present invention relates to a processing method for providing a programmable sheet on a web, wherein a developer designs a business logic page including a sheet by using a terminal connected to the server, and configures each sheet's attributes and the sheet. Defining an attribute for a cell, the first step of generating and storing a file storing information about the cell, and when the user accesses the server using a terminal and requests the business logic page, the server A second step of parsing a file to determine attributes defined by the developer, combining script codes for the file, and inserting the code into the business logic page; Transmitting and outputting the business logic page including the third step; A fourth step of enabling the user to edit the sheet by executing the defined attributes for the sheet and the cells constituting the sheet accordingly; and if the user chooses to store the sheet, the server And receiving a data of the sheet, converting the data into a data manipulation language (DML), and storing the data in a database.

Description

PROCESSING METHOD FOR PROVIDING PROGRAMMABLE SHEET ON THE WEB}

The present invention relates to a processing method for providing a programmable sheet on the web. More specifically, when a developer and a user are connected through a network, and the developer defines a sheet's attributes to develop a work logic page, the server By determining the attributes and generating script code and executing the script in the user's web browser, the developer develops a sheet suitable for the purpose of use, and the user relates to a processing method for providing a programmable sheet on the web that can be used on the web. .

In the early days of Internet dissemination, the Internet was merely a means of transmitting information. That is, the information provider configures a document containing information as a web page, and when a user requests it, sends the stored web page to the user's terminal and outputs it on the web browser.

However, with the development of network technology and the widespread use of the Internet, today's business programs are being implemented on the web so that users can perform their tasks by entering or changing data on the web, instead of simply viewing the information provided. Efforts are being made.

In particular, sheets are used in data processing applications such as Excel, and are very useful for computer-based business processes. In the past, there have been efforts to implement similar functions on the web.

An example of a sheet provided on a conventional web is a table supported by HTML tags. Tables have the advantage that they can be used as long as the default browser is executed. However, tables can only be used as business sheets because they only show stored data without receiving data. In particular, when the frame is determined by the web designer, it is difficult to modify it, and even if the size of the cell is dynamically implemented, the design of the web page may be destroyed due to this.

Conventionally, another method for providing a sheet on the web is a method of storing a sheet program on a hard disk of a user's terminal and using the web browser to recognize the sheet program. This has the advantage of shortening the program development time and providing a friendly interface for both developers and users.

However, it cannot be used where there is no hard disk such as a web terminal, and it is not possible to define the attributes of the sheet freely according to the purpose of use by reflecting the characteristics of the work and reinstall the sheet program according to the user's environment. There is a problem that must be done.

The present invention has been made to solve the above problems, by providing a script by the web browser by providing a script to the web browser using the DHTML and COM + technology, the developer reflects the characteristics of the work, etc. Its purpose is to provide a process for providing a programmable sheet on the web that allows the user to define attributes of the sheet so that the user can enter or change data using the sheet in the web browser.

1 is a block diagram schematically showing an example of a system configuration for implementing the present invention;

2 is a block diagram illustrating a data flow between components according to the present invention;

3 is a flow chart showing the flow of a processing method for providing a programmable sheet on the web according to the present invention;

4 is a block diagram conceptually showing the structure of a sheet according to the present invention.

<Brief Description of Drawings>

10 ... server 12 ... file interpretation component

14 ... Script Generation Components 18 ... DML Generation Components

16 ... Event and Method Definition Function Components

19 ... DB Connection Component 20 ... Developer

22 ... tool 24 ... file

30 ... users 40 ... databases

60 ... Business Logic Page 70 ... Sheets

80 ... array

In order to achieve the above object, a processing method for providing a programmable sheet on the web according to the present invention, the developer and the user is connected to the server via a network, the developer is activated as a component in the terminal connected to the server Using a tool, designing a business logic page including the sheet and defining attributes of the sheet and attributes of each cell constituting the sheet, generating and storing a file storing information about the sheet. In step 1, when the user accesses the server using the terminal and requests the business logic page, the server interprets the file to determine the property defined by the developer, and the script code ( script code), and inserting it into the business logic page; Transmitting and outputting the business logic page including the sheet to a user's terminal; and executing the attributes defined for the sheet and a cell constituting the sheet by the server according to a user's selection. A fourth step of allowing the user to edit the sheet, and when the user selects to store the sheet, the server receives the data of the sheet and converts the data into a data manipulation language (DML), It characterized in that it comprises a fifth step of storing in.

Here, in the second step, the file analysis component of the server interprets the file to determine the property defined by the developer, passes the result to the script generation component, and activates the event and method definition function component. And combining the script code for the property by interworking with the event and method definition function component and inserting the script code into the business logic page. Becomes another feature.

Further, in the third step, when the server sends and outputs the business logic page to the terminal, the server further generates an array having data and attribute information of each cell corresponding to each cell of the sheet. And if the scroll function is defined as an attribute for the sheet, by outputting the data of the array to the cells of the sheet according to the scrolling of the user, the number of cells or the size according to the size of the web browser. It is another feature of the invention that the is not limited.

Specifically, in the fourth step, the server executes a script of an attribute defined for the sheet, and the user selects one or more cells constituting the sheet for entering or changing data or editing a cell. If selected, the server may execute a script of a property defined for the selected cell. However, when the server generates the array in the third step, the attribute information for the cell is read from the array and the corresponding script is executed, and when the data is input or changed, the server reads the attribute information about the cell. You can do this by saving.

In addition, when the server generates the arrangement in the third step, the fifth step includes, when the user selects to store the sheet, the server reads the data from the arrangement and stores the data. After converting to a manipulation word (DML), it may be stored in the database.

Hereinafter, with reference to the accompanying drawings will be described in more detail.

1 is a block diagram schematically showing an example of a system configuration for practicing the present invention.

As shown in FIG. 1, in the system for implementing the present invention, a developer 20 and a user 30 are connected to a server 10 through a network, and the server 10 stores data of a sheet. It is provided with a database 40 for.

The terminal of the developer 20 is provided with a tool for designing a work logic page and defining attributes of a sheet and attributes of a cell constituting the sheet.

Using such a system, the developer 20 designs a work logic page and defines attributes of a suitable sheet in consideration of the characteristics of the work. Then, when the user 30 accesses the server 10 and requests a work logic page developed by the developer 20, the server 10 sends the work logic page and the sheet to the user 30. And the attributes of the sheet defined by the developer 20 and the attributes of the cell constituting the sheet function as the server executes a script related thereto.

The user 30 enters or changes data by using a sheet defined by the developer 20 to use the work. When the user wants to store the data, the server 10 manipulates the data of the sheet. The data is converted into DML and stored in the database 40.

2 is a block diagram illustrating a data flow between components according to the present invention.

As shown in FIG. 2, the developer 20 designs a work logic page using a tool that is started by a component, defines attributes of a sheet included in the work logic page, and then selects a file name and a storage location. When input and stored, the terminal of the developer 20 generates a file 24 in which the information is stored and stores the ASP page in the storage location. At this time, the storage location may be a terminal of the developer 20, or may be a server 10 connected to the network.

Next, when the user 30 accesses the server 10 through a network and requests the business logic page, the server 10 detects the file 24 developed by the developer 20. Then, the work logic page stored in the transmission to the terminal of the user 30 to output. At this time, the server 10 causes the file parsing component 12 to interpret the sheets stored in the file 24 and the attributes of the cells constituting the sheet. That is, it is determined what the attribute is defined by the developer 20.

The file parsing component 12 passes the result of the file parsing (attribute information) to the script generation component 14, and at the same time activates the event and method definition function component 16.

The script generation component 14 refers to the result of the file interpretation received from the file interpretation component 12 and the sheet defined by the developer 20 in association with the event and method definition function component 16 and The script code for the attributes of the cells constituting the sheet are combined and inserted into the business logic page.

When the server 10 outputs a sheet, cells included in the sheet, and data of each cell to the terminal of the user 30, the server 10 generates an arrangement for storing data and attribute information corresponding to each cell of the sheet. Let's do it. The arrangement not only enables the scroll function on the sheet, but also stores data and attribute information for each cell constituting the sheet, thereby allowing the user 30 to enter data into the sheet on the web, or Make it possible to change.

When the user 30 wants to store the data of the sheet, the server 10 causes the DML generation component 18 to convert the data of the sheet into a data manipulation language (DML), and then connects the data to the DB. Stored in database 40 via component 19. At this time, the DML generation component 18 is preferably to increase the compatibility, including synchronous and asynchronous.

In addition, Microsoft's MSMQ technology is applied to the COM + system, which further includes COM + MSMQ components and MSMQ stacks on the server, and transmits data from the user when the developer does not need to store data in a database immediately. Receives it into a sentence, and the DML generating component converts it to DML and delivers it to the COM + MSMQ component, which causes the COM + MSMQ component to store it in the MSMQ stack. The DB connection component may be stored in a database according to a request of the COM + MSMQ component according to a system situation.

3 is a flowchart illustrating a processing method for providing a programmable sheet on the web according to the present invention. Hereinafter, the flow will be described step by step with reference to this.

First, a developer designs a work logic page, and defines a sheet included therein and attributes of a cell constituting the sheet (S10).

To this end, the developer is provided with an interface of a graphical environment, and the execution program of the sheet including events and methods is installed as an OCX in the developer's terminal.

Next, when the development is completed, receives a file name and a storage location from the developer, and generates a file in which information such as the design of the work logic page and the sheet of the design is stored and stored in the storage location (S20).

Next, after the user accesses the server through the network using a terminal, the user requests the business logic page (S30).

Then, the server detects the file stored in the step S20, activates the file analysis component, and determines the property defined by the developer (S40).

The attribute information determined in step S40 is transferred to a script generation component, and the script generation component combines script code in conjunction with an event and method definition function component and inserts it into the business logic page (S50).

Next, the server transmits and outputs the business logic page to the user's terminal, and executes a script defined for the sheet at step S60.

Then, the user can edit the data by inputting or changing data using the sheet on the web. If a cell is selected for this purpose, the server executes an attribute script for the cell (S70).

When the user selects to store the data, the data of the sheet is first converted into a data manipulation language (DML) by the DML generating component (S80).

Then, the data converted into DML is transferred to the DB connection component, and the DB connection component stores it in the database (S90).

Here, the attributes of the sheet and the cells constituting the sheet include various functions of sheets supported by an application program such as Excel, which is generally used for business processing. It means functions, data sorting functions, inter-cell operations, and scrolling. However, the present invention is not limited thereto, and various functions may be provided through software processing. Accordingly, the developer can easily develop a sheet suitable for the characteristics of the job by selecting a function corresponding to the intended use.

Figure 4 is a schematic diagram showing the structure of a sheet according to the present invention, which is intended to solve the spatial constraints in displaying the sheet on a web browser, and to enable data processing by a script.

Specifically, as shown in FIG. 4, in outputting the work logic page 60 to the user's terminal and displaying the sheet 70 included therein, the frame of the sheet is limited. When the number of cells constituting the 70 increases, it becomes difficult to display all of them.

Thus, further forming an arrangement 80 corresponding to a substantial cell of the sheet. The attributes and other data of each cell are then written into a string and stored in the array 80 together with the data of the cell (eg in the form of textbox.value). The portion displayed in the web browser of the user in the arrangement 80 is displayed as a text box.

Therefore, when a user selects a cell for editing a sheet, the array 80 determines attribute information about the cell and executes a script for the cell, and even when data is input or changed, the array 80 By entering or changing data for the cell, substantial data processing is accomplished by the arrangement 80.

Further, by providing a scroll function, when the user operates the scroll bar or moves the selection of a cell by pressing a keyboard, the data corresponding to the scroll is evicted from the arrangement and displayed on a sheet of the work logic page of the user. .

In this case, if the user chooses to store the data, the server detects the data of each cell in the array 80, converts it to DML, and stores it in the database.

As described above, in the case of using the processing method for providing the programmable sheet on the web according to the present invention, the user can use the sheet on the web by implementing the function of the sheet using DHTML and a scripting language in a web browser. It is possible to perform business processing, and if only a web browser is installed, there is an effect that can be used without being limited to the user's terminal model or the operating system.

In addition, the developer can easily develop a business program by defining a function of a sheet suitable for a characteristic of a job by using a tool including a graphic interface and events and methods.

Claims (6)

In a processing method for providing a programmable sheet on a web by connecting a developer and a user to a server through a wired or wireless network, The developer designes a business logic page including the sheet using a tool that is activated as a component in a terminal connected to the server, and defines an attribute of the sheet and an attribute of each cell constituting the sheet. A first step of generating and storing a file having stored therein information; After the user accesses the server using a terminal and requests the business logic page, the server interprets the file to determine the property defined by the developer and generates a script code for it. In combination, inserting it into the business logic page; A third step of sending, by the server, the business logic page including the sheet to the terminal of the user; A fourth step of allowing the user to edit the sheet by the server executing attributes defined for the sheet and cells constituting the sheet according to the user's selection; And when the user selects to store the sheet, the server receives the data of the sheet, converts the data into a data manipulation language (DML), and stores the data in a database. Workaround to provide programmable sheets on Windows. The method of claim 1, The second step, The file analysis component of the server interprets the file to determine an attribute defined by the developer, and then passes the result to a script generation component and activates an event and method definition function component, and the script generation component. Combines the script code for the property by interworking with the event and method definition function component, and inserts the script code into the business logic page. Way. The method according to claim 1 or 2, In the third step, when the server sends and outputs the business logic page to the terminal, the server further generates an array having data and attribute information of each cell corresponding to each cell of the sheet, A method for providing a programmable sheet on the web, wherein if the scroll function is defined as an attribute for the sheet, data of the array is output to a cell of the sheet according to scrolling of the user. . The method according to claim 1 or 2, The fourth step, If the server executes a script of attributes defined for the sheet and the user selects one or more cells that make up the sheet for entry or change of data or editing of a cell, the server selects the selected cell. And executing a script of a property defined for the processing method for providing the programmable sheet on the web. The method of claim 3, wherein The fourth step, If the server executes a script of the attribute defined for the sheet and the user selects one or more cells that make up the sheet for entry or change of data or editing of a cell, the server in the array And reading out attribute information of the cell, executing a corresponding script, and storing the information in the array when data is input or changed. The method of claim 3, wherein The fifth step, When the user selects to store the sheet, the server reads the data from the array, converts the data into a data manipulation language (DML), and stores the data in the database. Processing method to provide sheet.