Object in interactive electric whiteboard software is inserted into the method in the Excel page
[technical field]
The invention belongs to computer software fields, specifically refer to the method be inserted into by the object in interactive electric whiteboard software in the Excel page.
[background technology]
Teacher uses interactive electric whiteboard software to say class hour, the Excel document of oneself is used to explain, if will explain the Excel document of oneself, do annotation to carry out under the Window pattern of whiteboarding software, but cannot preserve this this annotation, student does not annotate, and when wanting have these to annotate, teacher can only manually operate in Excel, and not only inconvenience also can waste the plenty of time.
In view of this, the present 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 method be inserted into by object in interactive electric whiteboard software in the Excel page, teacher can be marked the Excel document that will explain at use interactive electric whiteboard software process, conveniently 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 the method in the Excel page, comprises the steps:
Step 1: location obtains the screen coordinate that Excel jumps to the most upper left corner of the page of each page;
Step 2: the picture object of in current whiteboard software being saved as emf form;
Step 3: contrasted by the coordinate obtained in the coordinate of the object in step 2 and step 1, determines the page inserted, picture is inserted the Excel page;
Step 4: judge whether all objects in whiteboarding software all insert? then proceed to step 5, no, then proceed to step 2;
Step 5: disconnect Excel Ole object, terminate.
Further, described step 1, specifically comprises the steps:
Step 1.1: the line number R and the row C that obtain the most upper left corner of current Excel document;
Step 1.2: the displaying ratio obtaining current Excel document;
Step 1.3: obtain and currently choose position A and retain;
Step 1.4: choose the first row first row, now 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: arranging current uppermost line number with row number is R, C;
Step 1.8: location is terminated.
Further, described step 2, specifically comprises the steps:
Step 2.1: scan all objects of all interactive electric whiteboard software under windows pattern;
Step 2.2: obtain the coordinate of described object at screen place and size, mobile object to 20,20 points;
Step 2.3: setting up one to the form of image width+40* object high+40 is the picture of EMF;
Step 2.4: objects draw is caused to this on EMF picture, and picture is preserved.
Further, described step 3, specifically comprises:
Add picture, position is that object's position deducts after screen coordinate that Excel the first row one arranges converts point size to and adds the Excel coordinate of current location A.
The invention has the advantages that: object is inserted into its position in Excel substantially identical to the relative position in picture and Excel document page with before insertion, Excel page Scalable, not showing blank does not affect insertion effect yet.Teacher can be marked the Excel document that will explain at use interactive electric whiteboard software process, and method provided by the invention makes teacher saying that the mark in solution preocess is kept in Excel document, 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 picture flow chart of steps.
[embodiment]
As shown in Figure 1, the object in interactive electric whiteboard software is inserted into the method in the Excel page, comprises the steps:
Step 1: location obtains the screen coordinate that Excel jumps to the most upper left corner of the page of each page;
Step 2: the picture object of in current whiteboard software being saved as emf form;
Step 3: contrasted by the coordinate obtained in the coordinate of the object in step 2 and step 1, determines the page inserted, picture is inserted the Excel page;
Step 4: judge whether all objects in whiteboarding software all insert? then proceed to step 5, no, then proceed to step 2;
Step 5: disconnect Excel Ole object, terminate.
Fig. 2 is positioning step process flow diagram of the present invention.Specifically comprise the steps:
Step 1.1: the line number R and the row C that obtain the most upper left corner of current Excel document;
Step 1.2: the displaying ratio obtaining current Excel document;
Step 1.3: obtain and currently choose position A and retain;
Step 1.4: choose the first row first row, now 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: arranging current uppermost line number with row number is R, C;
Step 1.8: location is terminated.
Fig. 3 is that the present invention preserves picture flow chart of steps.
Step 2.1: scan all objects of all interactive electric whiteboard software under windows pattern;
Step 2.2: obtain the coordinate of described object at screen place and size, mobile object to 20,20 points;
Step 2.3: setting up one to the form of image width+40* object high+40 is the picture of EMF;
Step 2.4: objects draw is caused to this on EMF picture, and picture is preserved.
Inserting step, specifically comprises:
Add picture, position is that object's position deducts after screen coordinate that Excel the first row one arranges converts point size to and adds the Excel coordinate of current location A.
It is substantially identical to the relative position in picture and Excel document page with before insertion that object is inserted into its position in Excel by the present invention, and Excel page Scalable, not showing blank does not affect insertion effect yet.Teacher can be marked the Excel document that will explain at use interactive electric whiteboard software process, and method provided by the invention makes teacher saying that the mark in solution preocess is kept in Excel document, 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 amendment done, equivalent replacement and improvement etc., all should be included within protection scope of the present invention.