First, clean up the idea first, ~ ~
First: We need to upload the file to the server.
Then: Read Excel data columns to display
Then: Let the user select the corresponding relationship of the field
Then: Submit the data, read the corresponding
The following functions are a general model previously written in VB to facilitate the use of the Excel function and process the output and format.
Public xlsapp as new excel. ApplicationPublic xlsbook as new excel. WorkbookPublic xlssheet as
Data center management system-link between vb and excel 2, data center management system excel
Since the documents I was looking for made me think that creating a table is a huge misunderstanding, I directly created a table in the folder of the
How can I access Excel objects in ASP!
---------------------------------------------------------------
ASP Excel Technical Summary
DirectoryI. Environment ConfigurationIi. Basic ASP operations on Excel3. Generate a data table using ASP ExcelIv.
Many people asked me how to import Excel and made a general scriptlibrary for importing EXCEL to notes, which is very convenient,
Requirements for Excel files: the first line of Excel must be the same as fieldname in notes form.
Usage example:
Article title: Summary of WEB development technology using ASP to operate Excel Technology. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research,
More commonly used is phpexcel,1 data is still OK, but the data reached about 1 million, Phpexcel is very helpless, search for the next more commonly used is the use of PHP fputcsv, do not know what can be exported to compare a large amount of data
First, clear your ideas. First ,~~
First, you need to upload the file to the server.
Then: Read the excel Data column and display it
Then, let the user select the corresponding field relationship.
Then: submit the data and read the correspondence
PHP exports the mysql database as an excel table. There are many ways to use php to export a mysql database as an excel table. The simplest way is to directly use the phpfputcsv function. you can also directly input the csv format, there are many
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.