CN109062882A - A kind of electronic spreadsheet generation method and device - Google Patents

A kind of electronic spreadsheet generation method and device Download PDF

Info

Publication number
CN109062882A
CN109062882A CN201810782482.9A CN201810782482A CN109062882A CN 109062882 A CN109062882 A CN 109062882A CN 201810782482 A CN201810782482 A CN 201810782482A CN 109062882 A CN109062882 A CN 109062882A
Authority
CN
China
Prior art keywords
electronic spreadsheet
component
configuration information
user terminal
electronic
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Withdrawn
Application number
CN201810782482.9A
Other languages
Chinese (zh)
Inventor
许磊
高飞
张培训
王凯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Zhengzhou Yunhai Information Technology Co Ltd
Original Assignee
Zhengzhou Yunhai Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Zhengzhou Yunhai Information Technology Co Ltd filed Critical Zhengzhou Yunhai Information Technology Co Ltd
Priority to CN201810782482.9A priority Critical patent/CN109062882A/en
Publication of CN109062882A publication Critical patent/CN109062882A/en
Withdrawn legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of electronic spreadsheet generation method and devices, this method comprises: receiving the electronic spreadsheet that user terminal is sent generates request;Wherein, it includes electronic spreadsheet configuration information in request that electronic spreadsheet, which generates,;According to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components;According to selected component, electronic spreadsheet is generated;The electronic spreadsheet of generation is returned into user terminal to save operation cost of enterprises, improve working efficiency.

Description

A kind of electronic spreadsheet generation method and device
Technical field
The present invention relates to data processing field, it is specifically designed a kind of electronic spreadsheet generation method and device.
Background technique
In recent years, the rapid development of computer and mobile phone brings great convenience and high to the work and life of people Effect.Information-based, electronization has become enterprise and saves operation cost, improves the first choice of working efficiency.In enterprise, headcount Larger, the list of use is many kinds of, and each employee is also different to the focus of list.But the employee of current a large amount of medium-sized and small enterprises Management cannot meet the personalization of user still in handwork stage, list format fixed single, this mode inefficiency Also usually there is careless mistake because of the careless of management in demand, in turn results in corporate resources and is lost or develops slowly.Therefore, this hair A kind of bright generation method for proposing electronic spreadsheet and device are to save operation cost of enterprises, improve working efficiency.
Summary of the invention
The present invention provides a kind of generation method of electronic spreadsheet and devices, can save operation cost of enterprises, improve work Make efficiency.
In order to reach the object of the invention, the present invention provides a kind of electronic spreadsheet generation methods, it is characterised in that:
It receives the electronic spreadsheet that user terminal is sent and generates request;Wherein, it includes electronics in request that the electronic spreadsheet, which generates, Form configuration information;
According to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components;
According to selected component, electronic spreadsheet is generated;
The electronic spreadsheet of generation is returned into the user terminal.
Further, the above method also has the following characteristics that
The electronic spreadsheet configuration information includes user terminal ID and form types;
Before selecting corresponding component according to the configuration information of the list, the method also includes:
Judge whether the user terminal ID has the permission for generating the corresponding electronic spreadsheet of the form types;
If the user terminal ID has the permission of the corresponding electronic spreadsheet of the raw form types, the basis is carried out The configuration information of the electronic spreadsheet, the step of selecting corresponding component in pre-set multiple components.
Further, the above method also has the following characteristics that
The configuration information according to the electronic spreadsheet selects corresponding component in pre-set multiple components, Include:
It is selected in pre-set multiple components and the matched component of the form types.
Further, the above method also has the following characteristics that
According to selected component, electronic spreadsheet is generated, comprising:
It is inquired from pre-stored each electronic spreadsheet template and extracts electronic watch corresponding with the electronic spreadsheet type Single mode version;
Identify the component items in the electronic spreadsheet template;
The selected component is filled into corresponding component items, electronic spreadsheet is synthesized.
Further, the above method also has the following characteristics that
It is described that selected component is filled into corresponding component items, comprising:
The selected component is matched according to scheduled rule with the component items;
According to matching result, the selected component is filled into the matched component items of institute.
In the present embodiment, it is asked by receiving the electronic spreadsheet generation including electronic spreadsheet configuration information that user terminal is sent It asks, according to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components, generates electronic watch It is single, the electronic spreadsheet of generation is returned into the user terminal, the operation cost of enterprise has been saved, has improved work efficiency.
In order to reach the object of the invention, the present invention provides a kind of electronic spreadsheet generating means, including memory and processor; It is characterized by:
The memory, for storing computer-readable instruction;
The processor, for executing the computer-readable instruction, to perform the following operations:
It receives the electronic spreadsheet that user terminal is sent and generates request;Wherein, it includes electronics in request that the electronic spreadsheet, which generates, Form configuration information;
According to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components;
According to selected component, electronic spreadsheet is generated;
The electronic spreadsheet of generation is returned into the user terminal.
Further, above-mentioned apparatus also has the following characteristics that
The electronic spreadsheet configuration information includes user terminal ID and form types;
Before selecting corresponding component according to the configuration information of the list, judge whether the user terminal ID has life At the permission of the corresponding electronic spreadsheet of the form types;
If the user terminal ID has the permission of the corresponding electronic spreadsheet of the raw form types, the basis is carried out The configuration information of the electronic spreadsheet, the step of selecting corresponding component in pre-set multiple components.
Further, above-mentioned apparatus also has the following characteristics that
The configuration information according to the electronic spreadsheet selects corresponding component in pre-set multiple components, Include:
It is selected in pre-set multiple components and the matched component of the form types.
Further, above-mentioned apparatus also has the following characteristics that
According to selected component, electronic spreadsheet is generated, comprising:
It is inquired from pre-stored each electronic spreadsheet template and extracts electronic watch corresponding with the electronic spreadsheet type Single mode version;
Identify the component items in the electronic spreadsheet template;
The selected component is filled into corresponding component items, electronic spreadsheet is synthesized.
Further, above-mentioned apparatus also has the following characteristics that
It is described that selected component is filled into corresponding component items, comprising:
The selected component is matched according to scheduled rule with the component items;
According to matching result, the selected component is filled into the matched component items of institute.
To sum up, request is generated by receiving the electronic spreadsheet including electronic spreadsheet configuration information that user terminal is sent, according to The configuration information of the electronic spreadsheet selects corresponding component in pre-set multiple components, generates electronic spreadsheet, will give birth to At electronic spreadsheet return to the user terminal, saved the operation cost of enterprise, improved work efficiency.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by specification, right Specifically noted structure is achieved and obtained in claim and attached drawing.
Detailed description of the invention
Attached drawing is used to provide to further understand technical solution of the present invention, and constitutes part of specification, with this The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is the flow chart of the electronic spreadsheet generation method of the embodiment of the present invention;
Fig. 2 is the schematic diagram of the electronic spreadsheet generating means of the embodiment of the present invention.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application Feature can mutual any combination.
Step shown in the flowchart of the accompanying drawings can be in a computer system such as a set of computer executable instructions It executes.Also, although logical order is shown in flow charts, and it in some cases, can be to be different from herein suitable Sequence executes shown or described step.
Fig. 1 is the electronic spreadsheet generation method flow chart of the embodiment of the present invention, according to the flow chart, the electronics of the present embodiment List generation method, comprising:
Step S101: it receives the electronic spreadsheet that user terminal is sent and generates request;Wherein, electronic spreadsheet, which generates in request, includes Electronic spreadsheet configuration information.
In this step, user can be received by background server pass through the hair such as computer, tablet computer or mobile phone terminal The electronic spreadsheet sent generates request.
Step S102: according to the configuration information of electronic spreadsheet, corresponding component is selected in pre-set multiple components.
In this step, component can be, but not limited to be realized by html language.Component can be used to make user defeated Enter information or receives the operation information (such as selection menu item, click button etc.) of user or realize the specific function in list Deng for example, the text box seen on webpage, button, radio box, check box etc. all can serve as component herein.
Pre-set component may include one or more of in this step: input frame, input domain, dat frame, Radio box, check box, picture box, combobox, file upload frame, two dimensional code frame, read-only message box, signature boxes, frame of taking pictures, positioning Frame etc..
Step S103: according to selected component, electronic spreadsheet is generated.
Step S104: the electronic spreadsheet of generation is returned into the user terminal.
In the present embodiment, it is asked by receiving the electronic spreadsheet generation including electronic spreadsheet configuration information that user terminal is sent It asks, according to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components, generates electronic watch It is single, the electronic spreadsheet of generation is returned into the user terminal, the operation cost of enterprise has been saved, has improved work efficiency.
Optionally, electronic spreadsheet configuration information includes user terminal ID and form types.
Before selecting corresponding component according to the configuration information of list, it can first judge that electronic spreadsheet generates and be wrapped in request Whether the user terminal ID included has the permission for generating the corresponding electronic spreadsheet of form types;
If the user terminal ID has the permission of the corresponding electronic spreadsheet of the raw form types, carry out according to The configuration information of electronic spreadsheet, the step of selecting corresponding component in pre-set multiple components.
In this step, by judging whether User ID has the permission for the electronic spreadsheet for generating corresponding types, it ensure that electricity The safety that sublist list uses.
In an exemplary embodiment, the user terminal ID and each electronic watch with all kinds of electronic spreadsheets be will enable in advance Single type stores in the mapping table, when receiving including the generation request of the electronic spreadsheet of user terminal ID and form types, backstage Inquiry is stored in the mapping table of the electronic spreadsheet type and User ID of background server storage by server.If received User terminal ID in stored mapping table when, show that the user terminal ID received has that generate the electronic spreadsheet type corresponding Electronic spreadsheet permission, then carry out the step of selecting corresponding component in pre-set multiple components.If received User ID not in stored mapping table, then to user terminal return electronic spreadsheet failed regeneration prompting message.User terminal After the message for receiving electronic spreadsheet failed regeneration, superior administrator applies for generating the permission of electronic spreadsheet, after being authorized, It can carry out the step of selecting corresponding component in pre-set multiple components.
In an exemplary embodiment, the judgement to the user terminal ID of application common type list without permission, For example, list of asking for leave, office appliance request slip etc., only the User ID of the list relatively high to application security requirement carries out permission Judgement.
Optionally, according to the configuration information of electronic spreadsheet, corresponding component is selected in pre-set multiple components, is wrapped It includes:
It is selected in pre-set multiple components and the matched component of the form types.
In this step, the corresponding component of different types of electronic spreadsheet is different, can be by background server according to list Type, select component corresponding with form types.It can also increase or change list by background server according to the actual situation The corresponding component of type.For example, form types are list of asking for leave, corresponding single component of asking for leave is input frame, input under normal circumstances Domain, signature boxes, background server select input frame, input domain and signature boxes.But under specific circumstances, due to asking for leave employee's Identity is more special, needs to enclose photo on list asking for leave, background server in addition to selection input frame, input domain and signature boxes it Outside, it also needs to increase picture box.Background server can satisfy use by the component according to the actual situation, increased or modification is selected The individual demand at family.
Optionally, according to selected component, electronic spreadsheet is generated, comprising:
It is inquired from pre-stored each electronic spreadsheet template and extracts electronic watch single mode corresponding with electronic spreadsheet type Version;
Identify the component items in the electronic spreadsheet template;
The selected component is filled into corresponding component items, electronic spreadsheet is synthesized.
Optionally, selected component is filled into corresponding component items, comprising:
Selected component is matched according to scheduled rule with component items;
According to matching result, the selected component is filled into the corresponding component items.
In this step, selected component is matched according to scheduled rule with component items, it can be by component and group Part item is matched according to title, size or type.
Above-mentioned electronic spreadsheet generation method is further described with concrete application example below.
This application example is asked for leave by user terminal application for list.
Step 1: server receives the electronic spreadsheet that user terminal is sent and generates request;It wherein, include electricity in the electronic spreadsheet Sub- form types are the electronic spreadsheet configuration information of list and user terminal ID of asking for leave.
Step 2: server according to the User ID that will be received, singly reflect by the User ID that stores on query service device and asking for leave Firing table determines the User ID received after the mapping table, single type of selecting and ask for leave in preset multiple components Corresponding component, for example, selecting 2 input frames, 2 input domains, dat frame, signature boxes.
Step 3: server is inquired in each electronics template prestored and is extracted and single corresponding electronic watch single mode of asking for leave Version, identifies the component items in the electronic spreadsheet template.
Step 4: selected component and component items are matched according to size, by component size and component items size one The component and component items of cause match, and component are filled into matched component items, generate electronics and ask for leave list.
Step 5: by the electronics of generation ask for leave it is single return to user terminal, user terminal is asked for leave after list receiving the electronics, in electronics Input respectively of asking for leave in the input domain of two single input frames asks dummy, the origin of an incident of asking for leave, and selects to ask for leave the date in dat frame, The signature of oneself is uploaded in signature boxes, after the completion saves the electronic insurance policy and is uploaded to server.
Fig. 2 is the electronic spreadsheet generating means of the embodiment of the present invention, including memory 10 and processor 20.
The memory 10, for storing computer-readable instruction;
The processor 20, for executing the computer-readable instruction, to perform the following operations:
It receives the electronic spreadsheet that user terminal is sent and generates request;Wherein, it includes electronics in request that the electronic spreadsheet, which generates, Form configuration information;
According to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components;
According to selected component, electronic spreadsheet is generated;
The electronic spreadsheet of generation is returned into the user terminal.
Optionally, electronic spreadsheet configuration information includes user terminal ID and form types;
Before selecting corresponding component according to the configuration information of the list, judge whether the user terminal ID has life At the permission of the corresponding electronic spreadsheet of the form types;
If the user terminal ID has the permission of the corresponding electronic spreadsheet of the raw form types, the basis is carried out The configuration information of the electronic spreadsheet, the step of selecting corresponding component in pre-set multiple components.
Optionally, according to the configuration information of the electronic spreadsheet, corresponding group is selected in pre-set multiple components Part, comprising:
It is selected in pre-set multiple components and the matched component of the form types.
Optionally, according to selected component, electronic spreadsheet is generated, comprising:
It is inquired from pre-stored each electronic spreadsheet template and extracts electronic watch corresponding with the electronic spreadsheet type Single mode version;
Identify the component items in the electronic spreadsheet template;
The selected component is filled into corresponding component items, electronic spreadsheet is synthesized.
Optionally, selected component is filled into corresponding component items, comprising:
The selected component is matched according to scheduled rule with the component items;
According to matching result, the selected component is filled into the corresponding component items.
In the present embodiment, electronic spreadsheet generating means include electronic spreadsheet configuration information by receive user terminal transmission Electronic spreadsheet generate request, according to the configuration information of the electronic spreadsheet, selected in pre-set multiple components corresponding Component, generate electronic spreadsheet, the electronic spreadsheet of generation returned into the user terminal, saved the operation cost of enterprise, improved Working efficiency.
Other realization details of Installation practice can be found in embodiment of the method above.
Those of ordinary skill in the art will appreciate that all or part of the steps in the above method can be instructed by program Related hardware is completed, and described program can store in computer readable storage medium, such as read-only memory, disk or CD Deng.Optionally, one or more integrated circuits can be used also to realize in all or part of the steps of above-described embodiment.Accordingly Ground, each module/unit in above-described embodiment can take the form of hardware realization, can also use the shape of software function module Formula is realized.The present invention is not limited to the combinations of the hardware and software of any particular form.
The above is only a preferred embodiment of the present invention, and certainly, the invention may also have other embodiments, without departing substantially from this In the case where spirit and its essence, those skilled in the art make various corresponding changes in accordance with the present invention And deformation, but these corresponding changes and modifications all should fall within the scope of protection of the appended claims of the present invention.

Claims (10)

1. a kind of electronic spreadsheet generation method, it is characterised in that:
It receives the electronic spreadsheet that user terminal is sent and generates request;Wherein, it includes electronic spreadsheet in request that the electronic spreadsheet, which generates, Configuration information;
According to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components;
According to selected component, electronic spreadsheet is generated;
The electronic spreadsheet of generation is returned into the user terminal.
2. according to the method described in claim 1, it is characterized by: the electronic spreadsheet configuration information includes user terminal ID and table Single type;
Before selecting corresponding component according to the configuration information of the list, the method also includes:
Judge whether the user terminal ID has the permission for generating the corresponding electronic spreadsheet of the form types;
If the user terminal ID has the permission of the corresponding electronic spreadsheet of the raw form types, carry out described according to The configuration information of electronic spreadsheet, the step of selecting corresponding component in pre-set multiple components.
3. according to the method described in claim 2, it is characterized by: the configuration information according to the electronic spreadsheet, pre- Corresponding component is selected in the multiple components being first arranged, comprising:
It is selected in pre-set multiple components and the matched component of the form types.
4. according to the method described in claim 3, it is characterized by: generating electronic spreadsheet according to selected component, comprising:
It is inquired from pre-stored each electronic spreadsheet template and extracts electronic watch single mode corresponding with the electronic spreadsheet type Version;
Identify the component items in the electronic spreadsheet template;
The selected component is filled into corresponding component items, electronic spreadsheet is synthesized.
5. according to the method described in claim 4, it is characterized by: described be filled into corresponding component items for selected component In, comprising:
The selected component is matched according to scheduled rule with the component items;
According to matching result, the selected component is filled into the matched component items of institute.
6. a kind of electronic spreadsheet generating means, it is characterised in that including memory and processor;It is characterized by:
The memory, for storing computer-readable instruction;
The processor, for executing the computer-readable instruction, to perform the following operations:
It receives the electronic spreadsheet that user terminal is sent and generates request;Wherein, it includes electronic spreadsheet in request that the electronic spreadsheet, which generates, Configuration information;
According to the configuration information of the electronic spreadsheet, corresponding component is selected in pre-set multiple components;
According to selected component, electronic spreadsheet is generated;
The electronic spreadsheet of generation is returned into the user terminal.
7. device according to claim 6, it is characterised in that: the electronic spreadsheet configuration information includes user terminal ID and table Single type;
Before selecting corresponding component according to the configuration information of the list, judge whether the user terminal ID has generation institute State the permission of the corresponding electronic spreadsheet of form types;
If the user terminal ID has the permission of the corresponding electronic spreadsheet of the raw form types, carry out described according to The configuration information of electronic spreadsheet, the step of selecting corresponding component in pre-set multiple components.
8. device according to claim 7, it is characterised in that: the configuration information according to the electronic spreadsheet, pre- Corresponding component is selected in the multiple components being first arranged, comprising:
It is selected in pre-set multiple components and the matched component of the form types.
9. device according to claim 8, it is characterised in that: according to selected component, generate electronic spreadsheet, comprising:
It is inquired from pre-stored each electronic spreadsheet template and extracts electronic watch single mode corresponding with the electronic spreadsheet type Version;
Identify the component items in the electronic spreadsheet template;
The selected component is filled into corresponding component items, electronic spreadsheet is synthesized.
10. device according to claim 9, it is characterised in that: described that selected component is filled into corresponding component items In, comprising:
The selected component is matched according to scheduled rule with the component items;
According to matching result, the selected component is filled into the matched component items of institute.
CN201810782482.9A 2018-07-17 2018-07-17 A kind of electronic spreadsheet generation method and device Withdrawn CN109062882A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810782482.9A CN109062882A (en) 2018-07-17 2018-07-17 A kind of electronic spreadsheet generation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810782482.9A CN109062882A (en) 2018-07-17 2018-07-17 A kind of electronic spreadsheet generation method and device

Publications (1)

Publication Number Publication Date
CN109062882A true CN109062882A (en) 2018-12-21

Family

ID=64816832

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810782482.9A Withdrawn CN109062882A (en) 2018-07-17 2018-07-17 A kind of electronic spreadsheet generation method and device

Country Status (1)

Country Link
CN (1) CN109062882A (en)

Similar Documents

Publication Publication Date Title
CN103826215B (en) A kind of method and apparatus for carrying out Root authority management on the terminal device
CN111859470B (en) Business data chaining method and device
CN104731589A (en) Automatic generation method and device of user interface (UI)
CN105165069A (en) Method for accessing Wi-Fi hotspot device, Wi-Fi hotspot device, and user equipment
CN103324470A (en) Web system generation method and device
CA3139243A1 (en) Information collection method, device, computer equipment and storage medium
CN105765533B (en) Method and apparatus for firmware virtualization
CN110750222A (en) Printing method, printing device, computer equipment and storage medium
EP3180714A1 (en) Form filling method and related terminal
CN103473326A (en) Method and device providing searching advices
CN109902095B (en) Policy information updating method, device, terminal and computer readable storage medium
CN112667415A (en) Data calling method and device, readable storage medium and electronic equipment
CN108363809A (en) A method of in PC client information input interface upload pictures
CN109391658B (en) Account data synchronization method and equipment, storage medium and terminal thereof
CN113312588A (en) Method, device, equipment and storage medium for managing operation authority of online document
CN111158777B (en) Component calling method, device and computer readable storage medium
CN112818270A (en) Data cross-domain transfer method and device and computer equipment
CN111045928A (en) Interface data testing method, device, terminal and storage medium
CN109062882A (en) A kind of electronic spreadsheet generation method and device
CN109858993A (en) A kind of car insurance order generation method, server and system
JP5817320B2 (en) User registration system and user registration method
CN112685613B (en) Resource package query method and device and information processing system
CN109784103A (en) The acquisition methods and device and storage medium of a kind of USB device usage record
US10397072B2 (en) Systems, devices, and methods for incident management interactions
CN104361094A (en) Storage method and device for file in search result, and browser client

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
WW01 Invention patent application withdrawn after publication
WW01 Invention patent application withdrawn after publication

Application publication date: 20181221