CN102937947A - Method for inserting object in interactive type electronic white board software into Excel page - Google Patents
Method for inserting object in interactive type electronic white board software into Excel page Download PDFInfo
- Publication number
- CN102937947A CN102937947A CN2012103825986A CN201210382598A CN102937947A CN 102937947 A CN102937947 A CN 102937947A CN 2012103825986 A CN2012103825986 A CN 2012103825986A CN 201210382598 A CN201210382598 A CN 201210382598A CN 102937947 A CN102937947 A CN 102937947A
- Authority
- CN
- China
- Prior art keywords
- excel
- page
- row
- coordinate
- picture
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 21
- 230000002452 interceptive effect Effects 0.000 title claims abstract description 19
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000002372 labelling Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
Images
Landscapes
- User Interface Of Digital Computer (AREA)
- Electrically Operated Instructional Devices (AREA)
Abstract
The invention provides a method for inserting an object in interactive type electronic white board software into an Excel page. The method comprises the following steps of: step 1. positioning to obtain a screen coordinate of turning Excel to the most left upper corner of the page of each page; step 2. storing one object of the current white board software to a picture with an emf format; step 3. comparing the coordinate of the object in the step 2 with the coordinate in the step 1; determining an inserted page and inserting the picture into the Excel page; step 4. judging whether all the objects in the white board software are inserted or not; if so, turning to the step 5; otherwise, turning into the step 2; and step 5. disconnecting an object Excel Ole; and finishing. According to the method, a teacher can mark an Excel document to be explained in a process of using the interactive type electronic white board software, so as to conveniently check.
Description
[technical field]
The invention belongs to computer software fields, specifically refer to the object in interactive electric whiteboard software is inserted into to the method in the Excel page.
[background technology]
The teacher uses interactive electric whiteboard software to say class hour, use the Excel document of oneself to be explained, if the Excel document of oneself is explained, doing annotation can carry out under the Window of blank software pattern, but can't preserve this this annotation, the student does not annotate, and while wanting to have these annotations, the teacher can only manually be operated in Excel, and not only inconvenience also can be wasted the plenty of time.
In view of this, the inventor furthers investigate for the defect of prior art, and has this case to produce.
[summary of the invention]
Technical matters to be solved by this invention is to provide a kind of object in interactive electric whiteboard software is inserted into to the method in the Excel page, make the teacher use the interactive electric whiteboard software process to the Excel labelling document that will explain, conveniently to check.
The present invention solves the problems of the technologies described above by the following technical solutions:
Object in interactive electric whiteboard software is inserted into to the method in the Excel page, comprises the steps:
Step 1: location obtains the screen coordinate that Excel jumps to the upper left corner of the page of each page;
Step 2: the picture that an object in current blank software is saved as to the emf form;
Step 3: the coordinate obtained in the coordinate of the object in step 2 and step 1 is contrasted, determine the page inserted, picture is inserted to the Excel page;
Step 4: judge whether all objects in blank software all insert? be, proceed to step 5, no, proceed to step 2;
Step 5: disconnect Excel Ole object, finish.
Further, described step 1, specifically comprise the steps:
Step 1.1: the line number R and row C that obtain the upper left corner of current Excel document;
Step 1.2: the displaying ratio of obtaining current Excel document;
Step 1.3: obtain current choose position A reservation;
Step 1.4: choose the first row first row, now the Excel document jumps to the first row first row automatically;
Step 1.5: the first row first row coordinate conversion becomes screen coordinate;
Step 1.6: choose position A, the now automatic redirect of Excel document;
Step 1.7: it is R, C with row number that current uppermost line number is set;
Step 1.8: finish location.
Further, described step 2, specifically comprise the steps:
Step 2.1: scan all objects of all interactive electric whiteboard software under the windows pattern;
Step 2.2: obtain the coordinate and size, mobile object to 20,20 points of described object at the screen place;
Step 2.3: set up one to image width+40* object high+picture that 40 form is EMF;
Step 2.4: object is plotted to this and causes on the EMF picture, and picture is preserved.
Further, described step 3 specifically comprises:
Add picture, position is that screen coordinate that object's position deducts Excel the first row one row converts after point size the Excel coordinate that adds current location A to.
The invention has the advantages that: basic identical with the relative position in the Excel documentation page to picture before object is inserted into to its position in Excel and inserts, the Excel page amplifies and dwindles, and does not show that blank does not affect the insertion effect yet.Make the teacher use the interactive electric whiteboard software process can be to the Excel labelling document that will explain, method provided by the invention be kept in the Excel document mark of teacher in the explanation process, conveniently checks.
[accompanying drawing explanation]
The invention will be further described in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is software major function process flow diagram of the present invention.
Fig. 2 is positioning step process flow diagram of the present invention.
Fig. 3 is that the present invention preserves the picture flow chart of steps.
[embodiment]
As shown in Figure 1, the object in interactive electric whiteboard software is inserted into to the method in the Excel page, comprises the steps:
Step 1: location obtains the screen coordinate that Excel jumps to the upper left corner of the page of each page;
Step 2: the picture that an object in current blank software is saved as to the emf form;
Step 3: the coordinate obtained in the coordinate of the object in step 2 and step 1 is contrasted, determine the page inserted, picture is inserted to the Excel page;
Step 4: judge whether all objects in blank software all insert? be, proceed to step 5, no, proceed to step 2;
Step 5: disconnect Excel Ole object, finish.
Fig. 2 is positioning step process flow diagram of the present invention.Specifically comprise the steps:
Step 1.1: the line number R and row C that obtain the upper left corner of current Excel document;
Step 1.2: the displaying ratio of obtaining current Excel document;
Step 1.3: obtain current choose position A reservation;
Step 1.4: choose the first row first row, now the Excel document jumps to the first row first row automatically;
Step 1.5: the first row first row coordinate conversion becomes screen coordinate;
Step 1.6: choose position A, the now automatic redirect of Excel document;
Step 1.7: it is R, C with row number that current uppermost line number is set;
Step 1.8: finish location.
Fig. 3 is that the present invention preserves the picture flow chart of steps.
Step 2.1: scan all objects of all interactive electric whiteboard software under the windows pattern;
Step 2.2: obtain the coordinate and size, mobile object to 20,20 points of described object at the screen place;
Step 2.3: set up one to image width+40* object high+picture that 40 form is EMF;
Step 2.4: object is plotted to this and causes on the EMF picture, and picture is preserved.
Inserting step specifically comprises:
Add picture, position is that screen coordinate that object's position deducts Excel the first row one row converts after point size the Excel coordinate that adds current location A to.
The present invention is basic identical with the relative position in the Excel documentation page to picture before object is inserted into to its position in Excel and inserts, and the Excel page amplifies and dwindles, and does not show that blank does not affect the insertion effect yet.Make the teacher use the interactive electric whiteboard software process can be to the Excel labelling document that will explain, method provided by the invention be kept in the Excel document mark of teacher in the explanation process, conveniently checks.
The foregoing is only better enforcement use-case of the present invention, be not intended to limit protection model figure of the present invention.Within the spirit and principles in the present invention all, any modification of doing, be equal to and replace and improvement etc., within all should being included in protection scope of the present invention.
Claims (4)
1. the object in interactive electric whiteboard software is inserted into to the method in the Excel page, it is characterized in that: comprise the steps:
Step 1: location obtains the screen coordinate that Excel jumps to the upper left corner of the page of each page;
Step 2: the picture that an object in current blank software is saved as to the emf form;
Step 3: the coordinate obtained in the coordinate of the object in step 2 and step 1 is contrasted, determine the page inserted, picture is inserted to the Excel page;
Step 4: judge whether all objects in blank software all insert? be, proceed to step 5, no, proceed to step 2;
Step 5: disconnect Excel Ole object, finish.
2. as claimed in claim 1 object in interactive electric whiteboard software is inserted into to the method in the Excel page, it is characterized in that: described step 1 specifically comprises the steps:
Step 1.1: the line number R and row C that obtain the upper left corner of current Excel document;
Step 1.2: the displaying ratio of obtaining current Excel document;
Step 1.3: obtain current choose position A reservation;
Step 1.4: choose the first row first row, now the Excel document jumps to the first row first row automatically;
Step 1.5: the first row first row coordinate conversion becomes screen coordinate;
Step 1.6: choose position A, the now automatic redirect of Excel document;
Step 1.7: it is R, C with row number that current uppermost line number is set;
Step 1.8: finish location.
3. as claimed in claim 1 object in interactive electric whiteboard software is inserted into to the method in the Excel page, it is characterized in that: described step 2 specifically comprises the steps:
Step 2.1: scan all objects of all interactive electric whiteboard software under the windows pattern;
Step 2.2: obtain the coordinate and size, mobile object to 20,20 points of described object at the screen place;
Step 2.3: set up one to image width+40* object high+picture that 40 form is EMF;
Step 2.4: object is plotted to this and causes on the EMF picture, and picture is preserved.
4. as claimed in claim 1 object in interactive electric whiteboard software is inserted into to the method in the Excel page, it is characterized in that: described step 3 specifically comprises:
Add picture, position is that screen coordinate that object's position deducts Excel the first row one row converts after point size the Excel coordinate that adds current location A to.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210382598.6A CN102937947B (en) | 2012-10-11 | 2012-10-11 | Object in interactive electric whiteboard software is inserted into the method in the Excel page |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210382598.6A CN102937947B (en) | 2012-10-11 | 2012-10-11 | Object in interactive electric whiteboard software is inserted into the method in the Excel page |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102937947A true CN102937947A (en) | 2013-02-20 |
| CN102937947B CN102937947B (en) | 2015-08-19 |
Family
ID=47696845
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210382598.6A Expired - Fee Related CN102937947B (en) | 2012-10-11 | 2012-10-11 | Object in interactive electric whiteboard software is inserted into the method in the Excel page |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102937947B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104407851A (en) * | 2014-10-30 | 2015-03-11 | 锐达互动科技股份有限公司 | Method for reading interaction subject in PPT (Power Point) file from whiteboard software |
| CN106354395A (en) * | 2016-09-28 | 2017-01-25 | 厦门印天电子科技有限公司 | Method of inserting multimedia object in interactive whiteboard software to 2D sheet |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101211334A (en) * | 2006-12-28 | 2008-07-02 | 珠海金山软件股份有限公司 | Device and method for positioning unit grid position in electronic form designated area |
| US7673235B2 (en) * | 2004-09-30 | 2010-03-02 | Microsoft Corporation | Method and apparatus for utilizing an object model to manage document parts for use in an electronic document |
-
2012
- 2012-10-11 CN CN201210382598.6A patent/CN102937947B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7673235B2 (en) * | 2004-09-30 | 2010-03-02 | Microsoft Corporation | Method and apparatus for utilizing an object model to manage document parts for use in an electronic document |
| CN101211334A (en) * | 2006-12-28 | 2008-07-02 | 珠海金山软件股份有限公司 | Device and method for positioning unit grid position in electronic form designated area |
Non-Patent Citations (1)
| Title |
|---|
| 松博学习科技股份有限公司: "SMART Board互动式电子白板基本培训使用手册", 《HTTP://ICT.CMSH.TC.EDU.TW/IWB/SUBJECT.PDF》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104407851A (en) * | 2014-10-30 | 2015-03-11 | 锐达互动科技股份有限公司 | Method for reading interaction subject in PPT (Power Point) file from whiteboard software |
| CN104407851B (en) * | 2014-10-30 | 2017-07-14 | 锐达互动科技股份有限公司 | A kind of method of the interactive problem read in whiteboarding software in PPT files |
| CN106354395A (en) * | 2016-09-28 | 2017-01-25 | 厦门印天电子科技有限公司 | Method of inserting multimedia object in interactive whiteboard software to 2D sheet |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102937947B (en) | 2015-08-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103646582B (en) | A kind of method and device pointing out clerical error | |
| EP3291635A3 (en) | Location aware resource locator | |
| CN109815932A (en) | A kind of paper corrects method, apparatus, electronic equipment and storage medium | |
| CN103186510B (en) | A kind of method and apparatus of convert documents form | |
| EP2395795A3 (en) | Scanning for a predetermined access point by a portable terminal in unused state | |
| EP2458335A3 (en) | Road estimation device and method for estimating road | |
| EP2645290A3 (en) | Devices and methods for unlocking a lock mode | |
| WO2008031085A3 (en) | System and method for web enabled geo-analytics and image processing | |
| EP2477123A3 (en) | Saveless documents | |
| WO2007121332A3 (en) | Business transaction documentation system and method | |
| WO2012067802A3 (en) | Techniques to annotate street view images with contextual information | |
| IN2013CH05313A (en) | ||
| US20160012796A1 (en) | Method and system for replacing theme of a mobile terminal on the basis of a user's clothes color | |
| CN103970736A (en) | Method for converting Excel sheet to database table | |
| EP2458330A3 (en) | Road estimation device and method for estimating road | |
| EP2458332A3 (en) | Road estimation device and method for estimating road | |
| MX2009005417A (en) | Mobile terminal and method of managing meeting information using the same. | |
| CN102955769A (en) | Method for inserting objects of interactive electronic whiteboard software into PPT (PowerPoint) page | |
| CN102902662B (en) | Method for inserting object in interactive electronic white board software into Word page | |
| CN102937947A (en) | Method for inserting object in interactive type electronic white board software into Excel page | |
| EP2506560A3 (en) | Image Processing Apparatus, Image Processing Method, and Storage Medium | |
| CN102981833B (en) | Method enabling object in interactive electronic whiteboard software to be inserted into Office page | |
| EP2466419A1 (en) | Apparatus and method for providing electronic book service | |
| CN204143488U (en) | Call the roll of the contestants in athletic events management system in the examination hall of reading based on electronic tag | |
| CN104111820A (en) | Method and device for adding reading time for E-book |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| C53 | Correction of patent of invention or patent application | ||
| CB02 | Change of applicant information |
Address after: Cangshan District of Fuzhou City, Fujian province 350000 to build a new town, Jinshan Road No. 618 Garden State Industrial Park Gulou Park Building No. 8 Applicant after: Returnstar Interactive Technology Group Co., Ltd. Address before: Cangshan District of Fuzhou City, Fujian province 350000 to build a new town, Jinshan Road No. 618 Garden State Industrial Park Gulou Park Building No. 8 Applicant before: Fuzhou Returnstar Digital Technology Co., Ltd. |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: APPLICANT; FROM: FUZHOU RETURNSTAR DIGITAL TECHNOLOGY CO., LTD. TO: RETURNSTAR INTERACTIVE TECHNOLOGY GROUP CO., LTD. |
|
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder |
Address after: 350000 6, No. 1 Innovation Park, No. 3 east science and technology road, Minhou street, Minhou, Fuzhou. Patentee after: Returnstar Interactive Technology Group Co., Ltd. Address before: 350000 Building 8, Gulou garden, Citrus Industrial Park, 618 Jinshan Road, Jianxin Town, Cangshan District, Fuzhou, Fujian, China Patentee before: Returnstar Interactive Technology Group Co., Ltd. |
|
| CP02 | Change in the address of a patent holder | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20150819 Termination date: 20201011 |