CN102169483A - Filmstrip automatic generation method based on electronic spreadsheet - Google Patents
Filmstrip automatic generation method based on electronic spreadsheet Download PDFInfo
- Publication number
- CN102169483A CN102169483A CN 201110103808 CN201110103808A CN102169483A CN 102169483 A CN102169483 A CN 102169483A CN 201110103808 CN201110103808 CN 201110103808 CN 201110103808 A CN201110103808 A CN 201110103808A CN 102169483 A CN102169483 A CN 102169483A
- Authority
- CN
- China
- Prior art keywords
- lantern slide
- electronic spreadsheet
- data
- filmstrip
- name
- 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.)
- Pending
Links
Landscapes
- Stored Programmes (AREA)
Abstract
The invention relates to a filmstrip automatic generation method based on an electronic spreadsheet. Differing from the existing method of manually manufacturing the filmstrip, the method comprises the following steps of: using the electronic spreadsheet as a data source and a filmstrip template as a presentation mode to separate the data from the mode, and improving the template design efficiency and quality. A filmstrip aid is not limited in a specific scene and has the universality, the parameter setting is easy to learn, and the filmstrip can be automatically generated according to the data so that the work efficiency and quality of the filmstrip can be improved. The filmstrip automatic generation method has universality, usability, high efficiency and accuracy.
Description
Technical field
The present invention relates to a kind of lantern slide and generate method automatically based on electronic spreadsheet.
Background technology
Along with the raising of the degree of office automation, office software uses more and more wider.Office software mainly comprises functions such as word processing, electronic spreadsheet, lantern slide.Electronic spreadsheet is mainly with document form storage and deal with data; Lantern slide with patterned form exhibition information with exchange.Electronic spreadsheet provides the source of data often, the data that word processing and lantern slide use electronic spreadsheet to provide, the consistance of assurance three data.
Provide the manufacturer of office software mainly to comprise Microsoft, Kingsoft and the tissue etc. of increasing income at present, wherein the office software function with Microsoft is the most powerful the widest with use.The product of these producers is realized the quick editor of office software by pasting copy, guarantees the consistance of data in the mode of link.But lantern slide manufacturing can not rely on the electronic spreadsheet content to generate lantern slide automatically, still needs the manual copy/paste/linking functions of carrying out to make up and could generate.For example, form can not need manual according to electronic spreadsheet length and the generation of lantern slide form length according to the content automatic increase of electronic spreadsheet in the lantern slide.
In routine office work, styles such as design template, animation are not only wanted in the making of lantern slide, also will consider the accuracy of demonstrating data.Often owing to the change of the data lantern slide of having to make again, efficiency ratio is lower, and the quality of data is not high.These mainly are because separating of data and style do not accomplished in data and the style design that mixes in the lantern slide manufacturing.Therefore, adopt electronic spreadsheet as data source, the automatic generation lantern slide of supporting data to separate with pattern becomes one of office automation developing direction.
Summary of the invention
Purpose of the present invention just provides a kind of employing electronic spreadsheet as data source, and a kind of lantern slide based on electronic spreadsheet of supporting data to separate with pattern generates method automatically.
Lantern slide based on electronic spreadsheet of the present invention generates method automatically, may further comprise the steps:
1, set up the lantern slide engine, this lantern slide engine is according to graphics shape, and the mode by function call is filled into the lantern slide assigned address with the content of electronic spreadsheet;
2, the lantern slide template is set, animation of Bo Fanging and style are named the component Name that need fill in the lantern slide template as required, and the corresponding relation of this assembly and data source is provided;
3, lantern slide and electronic spreadsheet corresponding relation parameter list are set, pursue figure page by page according to name assembly in the lantern slide template, fill in the form name and the data area of data in the electronic spreadsheet in order, finally set up the corresponding relation between lantern slide pattern and the electronic spreadsheet data;
4, the electronic spreadsheet data are set,, name electronic spreadsheet item by item, fill in correct data in the electronic spreadsheet data area according to component Name according to the setting of lantern slide and electronic spreadsheet corresponding relation parameter list;
5, by starting the lantern slide engine, electronic spreadsheet data field data will import to the required lantern slide of generation in the lantern slide template automatically.
Lantern slide based on electronic spreadsheet of the present invention generates method automatically, has following characteristics:
1, realizes separating of lantern slide pattern and data, improved work efficiency and quality, reduced requirement the producer.
2, set up the corresponding relation of pattern and data by component Name, in existing office software product, do not provide assembly named interface directly perceived, can only be not easy to user's operation by the name of secondary development script.
3, provide an interface that is simple and easy to the parameter setting, the parameter that projection person only needs to fill in the lantern slide page number, component Name, data area item by item according to name assembly in the lantern slide template gets final product.
4, have extensive universality, can give full play to projection person's subjective initiative, freely define template according to scene.
Embodiment
A kind of lantern slide based on electronic spreadsheet generates method automatically, may further comprise the steps:
1, sets up the lantern slide engine
The lantern slide engine begins one page to the end from homepage, travels through all lantern slides in the slide templates page by page; All figures that this page of visit lantern slide comprises in each page lantern slide are named graphics shape simultaneously, call the corresponding interface function.The parameter that interface function comprises is divided into two parts: style parameters (in component Name, the lantern slide page number, this page number figure numbering) and data parameters (electronic watch single file number, electronic watch single-row number), graphics engine judges that the first cell content of name figure claims the whether consistent figure that calculates to number with parameter maps chart form and name.
This auxiliary routine can read parameter list automatically, is filled up to the graph of a correspondence zone from electronic spreadsheet data area reading of data item by item according to the capable project of parameter list.Projection person and data set provider all need not to understand and write the code of auxiliary routine, have realized the full automation and the parameter configurationization of auxiliary routine.
2, the lantern slide template is set
The making of lantern slide does not have special requirement, and the speaker uses scene according to lantern slide, makes suitable lantern slide template, animation that design need be play and style etc.In the lantern slide manufacturing process unique different be that name need be filled in the component Name of data in the lantern slide template, will set up corresponding relation according to this title and data source later on.
So-called name assembly is meant the title that input characters comes proxy component in first effective cell of this assembly.These literal have no requirement except can not repeating with other component Names, are specified the title of " hoping the Wonder meaning " fully according to oneself preference and custom by the speaker.
First effective cell in the assembly be can input characters in the finger assembly first cell, for example the unique input characters cell of static text frame is exactly a first cell, grid control upper left corner cell is exactly the form first cell, the link text of hyperlink control is exactly the first cell of hyperlink, and other assemblies are drawn analogous conclusions.
3, lantern slide and electronic spreadsheet corresponding relation parameter list are set
The corresponding relation parameter list of lantern slide and electronic spreadsheet mainly is to set up the corresponding relation of naming assembly and electronic spreadsheet data area in the lantern slide template.Mapping table comprises and mainly comprises two parts: style parameters (component Name, the lantern slide page number) and data parameters (electronic spreadsheet title, electronic watch single file number, electronic watch single-row number) that is to say this parameter and interface parameters basically identical.
The speaker is responsible for filling in style parameters in the parameter list, numbers according to the figure that name assembly in the lantern slide template is filled in component Name, the lantern slide page number and this page number item by item.Data set provider is responsible for filling in data area parameter in the parameter list, fills in corresponding electronic spreadsheet title, electronic watch single file number and electronic watch single-row number according to the parameter list component Name.Although component Name and electronic spreadsheet title can independently be named, for the purpose of simple clear, reasonable scheme is that component Name and electronic spreadsheet title adopt same title.Finally set up the corresponding relation between lantern slide pattern and the electronic spreadsheet data.
4, the electronic spreadsheet data are set
Data set provider is according to the setting of lantern slide and electronic spreadsheet corresponding relation parameter list, according to component Name name electronic spreadsheet in the capable project of parameter list; With the cell of the ranks defined of data area appointment in the capable project of the parameter list first effective cell as electronic spreadsheet, data set provider is filled in corresponding data in this zone.Data set provider to footline, travels through the capable project of parameter list from the first trip of parameter list one by one, name electronic spreadsheet and fill in data.
Claims (1)
1. the lantern slide based on electronic spreadsheet generates method automatically, and it is characterized in that: it may further comprise the steps:
(1), set up the lantern slide engine, this lantern slide engine is according to graphics shape, the mode by function call is filled into the lantern slide assigned address with the content of electronic spreadsheet;
(2), the lantern slide template is set, animation of Bo Fanging and style as required, the component Name that name need be filled in the lantern slide template provides the corresponding relation of this assembly and data source;
(3), lantern slide and electronic spreadsheet corresponding relation parameter list are set, pursue figure page by page according to name assembly in the lantern slide template, fill in the form name and the data area of data in the electronic spreadsheet in order, finally set up the corresponding relation between lantern slide pattern and the electronic spreadsheet data;
(4), the electronic spreadsheet data are set, according to the setting of lantern slide and electronic spreadsheet corresponding relation parameter list, name electronic spreadsheet item by item according to component Name, fill in correct data in the electronic spreadsheet data area;
(5), by starting the lantern slide engine, electronic spreadsheet data field data will import to the required lantern slide of generation in the lantern slide template automatically.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110103808 CN102169483A (en) | 2011-04-25 | 2011-04-25 | Filmstrip automatic generation method based on electronic spreadsheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110103808 CN102169483A (en) | 2011-04-25 | 2011-04-25 | Filmstrip automatic generation method based on electronic spreadsheet |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102169483A true CN102169483A (en) | 2011-08-31 |
Family
ID=44490646
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110103808 Pending CN102169483A (en) | 2011-04-25 | 2011-04-25 | Filmstrip automatic generation method based on electronic spreadsheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102169483A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103034940A (en) * | 2012-12-07 | 2013-04-10 | 深圳市智维通达科技有限公司 | Method and system for automatic analysis report generation |
| WO2014131194A1 (en) * | 2013-03-01 | 2014-09-04 | Microsoft Corporation | Dynamic presentation prototyping and generation |
| CN105867885A (en) * | 2015-01-19 | 2016-08-17 | 珠海金山办公软件有限公司 | Method and device for storing slide file |
| CN106339363A (en) * | 2015-07-07 | 2017-01-18 | 北京神州泰岳软件股份有限公司 | PPT report making method and device |
| US9619128B2 (en) | 2013-07-01 | 2017-04-11 | Microsoft Technology Licensing, Llc | Dynamic presentation prototyping and generation |
| CN106776509A (en) * | 2016-11-16 | 2017-05-31 | 武汉飞博科技有限公司 | A kind of electronic spreadsheet generation method and device |
| WO2017114015A1 (en) * | 2015-12-31 | 2017-07-06 | 北京金山办公软件股份有限公司 | Method and apparatus for recognizing slide |
| CN107491426A (en) * | 2016-10-25 | 2017-12-19 | 宝沃汽车（中国）有限公司 | The automatic generation method and system of PPT reports |
| CN107783949A (en) * | 2016-08-24 | 2018-03-09 | 北京神州泰岳软件股份有限公司 | A kind for the treatment of method and apparatus of PPT documents |
| US10572128B2 (en) | 2013-09-29 | 2020-02-25 | Microsoft Technology Licensing, Llc | Media presentation effects |
| US10846336B2 (en) | 2014-10-30 | 2020-11-24 | Microsoft Technology Licensing, Llc | Authoring tools for synthesizing hybrid slide-canvas presentations |
| CN115081403A (en) * | 2022-07-26 | 2022-09-20 | 广东壹公里数智科技有限公司 | Conference PPT automatic generation method and device, electronic equipment and storage medium |
-
2011
- 2011-04-25 CN CN 201110103808 patent/CN102169483A/en active Pending
Non-Patent Citations (4)
| Title |
|---|
| 《中国医学教育技术》 20070831 杨蕾，韩晓伟 《基于数据库实现教学幻灯片的自动生成》 321-323 第21卷, 第4期 * |
| 《微机发展》 20040531 孙淮宁 《基于VBA实现远程媒体访问及课件自动生成》 55-57，封三 第14卷, 第5期 * |
| 《硅谷》 20091231 刘晓魁 《C++ Builder对Powerpoint动画的OLE自动化控制》 38-39 , 第16期 * |
| 《福建电脑》 20110331 赵辉 《VFP自动生成POWERPOINT演示文稿》 173-174 , 第3期 * |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103034940A (en) * | 2012-12-07 | 2013-04-10 | 深圳市智维通达科技有限公司 | Method and system for automatic analysis report generation |
| CN105144672B (en) * | 2013-03-01 | 2018-02-27 | 微软技术许可有限责任公司 | Dynamic demonstration prototype and generation |
| WO2014131194A1 (en) * | 2013-03-01 | 2014-09-04 | Microsoft Corporation | Dynamic presentation prototyping and generation |
| CN105144672A (en) * | 2013-03-01 | 2015-12-09 | 微软技术许可有限责任公司 | Dynamic presentation prototyping and generation |
| US9619128B2 (en) | 2013-07-01 | 2017-04-11 | Microsoft Technology Licensing, Llc | Dynamic presentation prototyping and generation |
| US10572128B2 (en) | 2013-09-29 | 2020-02-25 | Microsoft Technology Licensing, Llc | Media presentation effects |
| US10846336B2 (en) | 2014-10-30 | 2020-11-24 | Microsoft Technology Licensing, Llc | Authoring tools for synthesizing hybrid slide-canvas presentations |
| CN105867885A (en) * | 2015-01-19 | 2016-08-17 | 珠海金山办公软件有限公司 | Method and device for storing slide file |
| CN105867885B (en) * | 2015-01-19 | 2019-11-01 | 珠海金山办公软件有限公司 | A kind of storage method and device of slide file |
| CN106339363A (en) * | 2015-07-07 | 2017-01-18 | 北京神州泰岳软件股份有限公司 | PPT report making method and device |
| CN106339363B (en) * | 2015-07-07 | 2019-09-13 | 北京神州泰岳软件股份有限公司 | A kind of production method and device of PPT report |
| WO2017114015A1 (en) * | 2015-12-31 | 2017-07-06 | 北京金山办公软件股份有限公司 | Method and apparatus for recognizing slide |
| US10698943B2 (en) | 2015-12-31 | 2020-06-30 | Beijing Kingsoft Office Software, Inc. | Method and apparatus for recognizing slide |
| CN107783949A (en) * | 2016-08-24 | 2018-03-09 | 北京神州泰岳软件股份有限公司 | A kind for the treatment of method and apparatus of PPT documents |
| CN107783949B (en) * | 2016-08-24 | 2021-06-18 | 北京神州泰岳软件股份有限公司 | PPT document processing method and device |
| CN107491426A (en) * | 2016-10-25 | 2017-12-19 | 宝沃汽车（中国）有限公司 | The automatic generation method and system of PPT reports |
| CN106776509A (en) * | 2016-11-16 | 2017-05-31 | 武汉飞博科技有限公司 | A kind of electronic spreadsheet generation method and device |
| CN115081403A (en) * | 2022-07-26 | 2022-09-20 | 广东壹公里数智科技有限公司 | Conference PPT automatic generation method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102169483A (en) | Filmstrip automatic generation method based on electronic spreadsheet | |
| CN103631597B (en) | WEB list engine apparatus based on XML and method | |
| RU2536390C2 (en) | Automated report generation method | |
| CN102722372B (en) | Method and system for automatically generating codes through classification and configuration | |
| CN100578496C (en) | Webpage dynamic creation method and system based on template | |
| CN109062567B (en) | B/S structure-based information management system rapid development platform | |
| CN104317563B (en) | A kind of online courseware collaborative development system | |
| CN102360296A (en) | WEB-based online form development tool | |
| CN102360290A (en) | Form building device and form building method | |
| US9323737B2 (en) | Generating an interactive page template based on setting a material type and a plurality of input and output signals for a mobile device | |
| CN106021394A (en) | Website construction method and apparatus | |
| CN106339363B (en) | A kind of production method and device of PPT report | |
| TW201324322A (en) | Simulation of web applications and secondary devices in a web browser, web application development tools, and methods using the same | |
| CN104317587A (en) | Automatic android mobile device oriented application generation method | |
| CN105045775A (en) | Method and apparatus for generating Excel document in designated format | |
| CN103593414A (en) | Showing method and device of webpages in browser | |
| CN111444696B (en) | Report form display and editing method and device | |
| CN112214218A (en) | High-performance and high-efficiency Sketch component library generation and management scheme and system | |
| CN111177621B (en) | Web page development method, device and system | |
| US20120212501A1 (en) | Automated method for customizing theme colors in a styling system | |
| CN106610826A (en) | Making method and device for online scenario application | |
| CN109814865A (en) | A kind of mobile application page generation method based on json data format | |
| CN107133206A (en) | A kind of digital content makes and demonstration tool and its application | |
| CN102253986A (en) | Method and device for improving webpage displaying effect in multiple terminals | |
| CN111367514B (en) | Page card development method and device, computing device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20110831 |