Front text box data and import and export EXCEL

2010-03-31  来源:本站原创  分类:Java  人气:290 

Main points to achieve two functions: (text box on a piece of the picture simply are no rules, but in the same column or peers, the size of different lengths)

1. The reception of all designated areas to export into a text box the value of the EXCEL table

2. EXCEL data in the table will be designated into the foreground all the text boxes within the region

Steps:

Export

1. Select rectangular area with JS

2. Obtain information on the selected text box within the region (with the coordinates of the selected area is included to determine whether the intersection or within the region), the growth of the text boxes of information assembled string (also should read each text box is kept in the order INDEX in)

3. String to be transmitted back (in the JS this value is assigned to a HIDDEN in the text box on the line). Split a string into a text box

4. To locate the text box, mainly locate their rows and columns

Specific methods:

Location steps
* 1 The boundary value
* 2, by drawing in the net the way, the scanning X-direction
* If px `from the border on the left beginning with the width = 10 scans, each testing whether a text box with in the same column,
* (The same column means that X has intersection)
* There will identify with the text box with out the box set (not py + = width to scan), then the above numbers are marked,
* Px is targeted to the lower right corner X of the largest in the collection and continue to scan until the right border.
* 3, Y scanning and 2 in the same way

5. After successful positioning of the ranks according to their written in EXCEL can be

EXCEL import:

1. Rectangular selection area

2. Points Import button upload files box appears, upload files, submit. Here will have to front the input box information (which may not value, but location) reached back and parse positioning.

3. EXCEL read the contents of the information inside with HASHMAP deposit, the ranks of a string of keys is

4. Background of the text box to assign, and then growing string assembly

5. Using IFRAME, JS method call parent window, this long string is returned to the parent window, by the method of the long string parsing, and text box under an assignment INDEX

相关文章
  • Front text box data and import and export EXCEL 2010-03-31

    Main points to achieve two functions: (text box on a piece of the picture simply are no rules, but in the same column or peers, the size of different lengths) 1. The reception of all designated areas to export into a text box the value of the EXCEL t

  • Javascript control the text box can only import figures 2008-05-21

    Javascript control the text box can only import figures <input onkeypress="return event.keyCode>=48&&event.keyCode<=57||event.keyCode==46" onpaste="return !clipboardData.getData('text').match(/\D/)" ondragenter="r

  • [Change] import and export excel using POI components 2010-03-29

    [Change] import and export excel using POI components Often encountered in the project to the list, or export data to excel in the excel document that already exist to import data into the database. Here to record the usage in the struts1.2. 1, from

  • import and export excel 2011-10-27

    import and export excel

  • oracle 10g data file import and export 2010-10-25

    Using expdp / impdp previously required to create a Directory in the database create directory dump_test3 as 'E: \ erpdata'; Then it licensed to a user grant read, write on directory dump_test3 to userName; Here you can import and export of data: Imp

  • php import and export Excel 2010-04-24

    1. This method is simple, there is no export problem , But the essence or XML, it is not possible to import the exported file .(Excel_XML This is an external method, you need Excel_XML External class ) Class OutOrInService { // Export excel function

  • the efficiency of import and export excel 2011-05-27

    Recently by Microsoft:: Office:: Interop:: Excel to do import and export. Found extremely slow. Debugging found, api calls inside a function with remote indication. Accordingly I guess, this interface is similar to the ejb, but also crater father stu

  • js control the text box can only import figure is compatible with FF 2009-12-29

    <! DOCTYPE HTML PUBLIC "- / / W3C / / DTD HTML 4.0 Transitional / / EN"> <HTML> <HEAD> <TITLE> New Document </ TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author&q

  • <Switch> Packaging Import and Export Excel class 2010-05-26

    1using System; 2using System.Collections; 3using System.ComponentModel; 4using System.Data; 5using System.Drawing; 6using System.Web; 7using System.Web.SessionState; 8using System.Web.UI; 9using System.Web.UI.WebControls; 10using System.Web.UI.HtmlCo

  • struts poi import and export excel 2010-08-02

    1.action wording Java code import java.io. *; import java.sql .*; import java.util.ArrayList; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.poi.hssf.usermodel .*; import org.apache.stru

  • jxl import and export Excel operations 2010-08-15

    jxl.jar Package Download Address: http://www.andykhan.com/jexcelapi/ Real Download: http://www.andykhan.com/jexcelapi/download.html Its website features the following description: ● support all versions of Excel 95-2000 ● ● generate standard format f

  • OI import and export Excel (a good thing, when you look at the future with haha) 2011-05-13

    1. Create the workbook (WORKBOOK) HSSFWorkbook wb = new HSSFWorkbook (); FileOutputStream fileOut = new FileOutputStream ("workbook.xls"); wb.write (fileOut); fileOut.close (); 2. Create a work sheet (SHEET) HSSFWorkbook wb = new HSSFWorkbook ()

  • Import and export large amounts of data on some of the ways 2010-04-07

    1. Import and export large amounts of data on some of the ways SQL SERVER offers a variety of tools for a variety of data sources, data import and export, the data sources, including paper files, ODBC data source, OLE DB data source, ASCII text files

  • Large-capacity on data import and export summary 2010-07-30

    /*------------------------------------------------ ---------------- - Author: feixianxxx (poofly) - Date :2010-03-29 14:04:14 - Version: - Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsof

  • Oracle 10g, Oracle Data Pump (data pump) methods of data import and export 2011-04-01

    To the data pump pressure Author: Jonathan Gennick Oracle Database 10g's new utility in its performance and versatility to a new level. Oracle Database 10g add called Oracle Data Pump (data pump) of the new import and export features, completely chan

  • Oracle10g data import and export 2011-07-06

    Oracle10g data import and export Introduction Oracle 10g introduces DATA PUMP provides a server-based data extraction and recovery utilities, DATA PUMP in the system structure and function with traditional compared to the EXPORT and IMPORT utilities

  • Db2 command summary file import and export common 2010-10-24

    Db2 command summary file import and export common Db2 command summary file import and export common Db2 data migration, the most commonly used is the import and export functions, and import and export commands seemingly simple, but in fact contains m

  • On Oracle's data import and export and Sql Loader (sqlldr) usage 2010-02-23

    In the Oracle database, we usually between tables in different database records will be used to copy or move the following methods: 1. A record of the table to export to a section of the insert statement, separated by a semicolon, and then insert int

  • How to use PLSQL Developer import and export data from oracle database 2010-10-02

    How to use PLSQL Developer import and export data from oracle database With pl / sql developer export table data in three ways: Oracle Export, Sql Insert, pl / sql developer Only "Oracle Export" to export and then import the way, the table struc

  • In excel 2007 to import or export text files _excel tutorial 2011-03-08

    Use Microsoft Office Excel to import data from text files in two ways: to open the text file in Excel, can also be imported as an external data range (external data range: from external to Excel (such as a database or text file) into a worksheet data