HOW TO EXPORT THE DATA IN THE PAGE TO EXCEL IN ASP

dim rs,sql,filename,fs,myfile,objspreadsheet,x

set fs = "")

Let's say you want the generated excel file to do the following to store filename ="")

If the original excel file exists, delete if then

end if

set objspreadsheet = ""), icol). = true

icol). = false

icol). = 10

icol).halignment = 2 'Centering – Create an excel file.

set myfile = ,true)

set rs = "")

Read the data you want to put in excel from the database sql="select * from table name order by id desc"

sql,conn,1,1

if and then

elsedim strline,responsestrstrline=""

for each x in

strline = strline & chr(9)next -- write the column names of the table to excel first

strline

do while not

strline=""

for each x in

strline = strline & chr(9)next -- write the data of the table to excel

strline

set rs = nothing

Add the following ** to the top of the page where you want to export the results:

content-disposition",attachment;filename="Recording.

When entering data in excel, usually the data is a source file, at this time, you can directly export from the source file to excel, how to export it? The following is the method I brought about to export web data to excel, I hope you will be inspired after reading!

How to export web data to Excel:

Web page data export excel step 1: I gave this example is a summary table of the 2014 college entrance examination in the web page, but in the web page, as shown in the figure, we can see that the total is divided into 17 web pages, and it looks a little irritating.

Web Data Export Excel Step 5: Then you can refer to my experience to merge all the excel workbooks into one.

Web data export excel step 6: Of course, as for the word version, just copy the excel and paste it, remember to prepare and plan in advance in excel when pasting, don't learn from me in the picture below to make it so ugly.

There is no direct way. 1. To operate Excel, you first need to refer to Microsoft Office Object Library2, including using; // for comexceptionusing excel; 3.Classes with that namespace.

Operate Excel to obtain the row and column data. Once you get the data, just deposit it in sqlserver. I won't talk about how to operate excel.

There are many on the Internet. Make a copy and modify it according to your actual situation.