The set of 4 small tools for converting xls two-dimensional structure data table to txt data text includes xls two-dimensional structure data table to txt data text, csv data text, mysql statements and data preview gadgets.
xls two-dimensional structure data table to txt data text and other 4 small tool sets v1.2 update log Improve the reading method and solve the problem of stuck reading of some files.
Corrected the problem of repeatedly reading the first column in two of the four functions.
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.
Tips
1..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.
Usage steps
Put this source code into the asp website space and access it through domain name + folder name
Access format: http://domain name/folder name/
1. Save the two-dimensional result table in .xls format as a win97-2003 worksheet (.xls)
2. Put 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
Other uses (.csv)
Replace the English commas in the obtained text content with Chinese commas and then replace the tab characters in the text content with commas to use in the php+csv series general query system developed by me.
Other uses (.xls)
Copy the resulting text content back to excel.
If there is any abnormality, please select all the blank tables, format the cells as text, and then paste the copied content.
It can be used in the php+xls/asp+xls series general query system developed by me.
Other uses (.html)
Visit the corresponding URL of dohtml.asp to convert the .xls format to html (you can right-click to view the source file).
Other uses (mysqls)
And facilitate the import of data, such as csv import access, etc.