xls to txt and other toolset v1.2

Convert xls two-dimensional structure data table to txt data text, csv data text, mysql statement and data preview gadget.

Principle: Read .xls files and display them as tab-delimited .txt format text, supporting multiple tables.

Another 1: dohtml.asp can preview the xls effect. You can right-click to view the source file and convert the .xls format to html code.

Another 2: dosqls.asp can read .xls to get the mysql import database statement.

Another 3: docsvs.asp can read .xls to get the text content in .csv format.

Change log

20190625: Improve the reading method and solve the problem of stuck reading of some files.

20190625: Corrected the problem of repeatedly reading the first column in two of the four functions.

Usage examples: The main use is to filter carriage return and tab functions.

1. PHP+txt universal series query system developed by myself.

2. The asp+txt universal series query system developed by myself.

3. The asp+txt universal search function developed by myself.

4. PHP+txt universal search function developed by myself.

5. Used for online backend txt webpage submission method.

6. Many uses related to asp reading xls multi-table content

Tips

1. The .xls file format is win97-2003 worksheet (.xls)

2. Generally used for the conversion of two-dimensional structure tables (column titles of each column in the first row).

3. This function can be used locally on ordinary windows computers + netbox software.

Put this source code into the asp website space, and access it through domain name + folder name. The access format is: http://domain name/folder name/

Usage steps

1. Save the two-dimensional result table in .xls format as a win97-2003 worksheet (.xls)

2. Place it in the shujukufangzheli folder.

3. Refresh the page to access this function, select the drop-down menu corresponding to the new file and submit it.

4. Get the text content, and after a little processing, get the data available in the query system