The database query information directly generated in the Web page embedded Excel table format, and can be exported to Excel files

Source: Internet
Author: User
Tags insert xmlns
excel| Data | database | Web page to see the essence of the numerous processing Excel posts, as if no one wrote this method of operation, I have done to write to you for your reference.

1. Create a new page in Frongpage, insert an Excel component into the Web page (insert the-web component-excel spreadsheet), and then enter the data format you want to output into the embedded Excel table, right-click the component, and define the parts of the component. When you are done, look at the source code and get the source code for the embedded component.

2. Create a new ASP Web page in vid, copy the source code from the previous step, and then add a circular fetch code for the data column. As follows:
<object classid= "clsid:0002e510-0000-0000-c000-000000000046" id= "Spreadsheet1" codebase= "Msowc.cab" width= "599" height= "490" >
<param name= "Htmlurl" value>
<param name= "HTMLData" value= "
<style type= "Text/css" >
<!--TR
{Mso-height-source:userset;}
Td
{white-space:nowrap;}
. wc80a6909
{white-space:nowrap;
Font-family: Song body;
Mso-number-format:general;
Font-size:auto;
Font-weight:auto;
Font-style:auto;
Text-decoration:auto;
Mso-background-source:auto;
Mso-pattern:auto;
Mso-color-source:auto;
Text-align:general;
Vertical-align:bottom;
Border-top:none;
Border-left:none;
Border-right:none;
Border-bottom:none;
mso-protection:locked;}
. wc01f2f7a
{white-space:nowrap;
Font-family: Song body;
Mso-number-format:general;
Font-size:auto;
Font-weight:auto;
Font-style:auto;
Text-decoration:auto;
Mso-background-source:auto;
Mso-pattern:auto;
Mso-color-source:auto;
Text-align:general;
Vertical-align:bottom;
Border-top:none;
Border-left:none;
Border-right:none;
Border-bottom:none;
mso-protection:locked;}
. wc0ea6f7a
{white-space:nowrap;
Font-family: Song body;
Mso-number-format:general;
Font-size:auto;
Font-weight:auto;
Font-style:auto;
Text-decoration:auto;
Mso-background-source:auto;
Mso-pattern:auto;
Mso-color-source:auto;
Text-align:center;
Vertical-align:bottom;
Border-top:none;
Border-left:none;
Border-right:none;
Border-bottom:none;
mso-protection:locked;}
-->
</style>

<body>
<!--[if GTE MSO 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:OWCVersion>9.0.0.2710</x:OWCVersion>
<x:label style= ' Font-size:11pt;border-top:solid 5pt silver;border-left:
Solid 5pt silver;border-right:solid. 5pt silver;border-bottom:solid. 5pt Silver ' >
<x:Caption> Rework Day Report-finished products out of storage report-<%=trim (Rs_stock ("fname"))%> (<%=sdate%> to <%=edate%>) </x: Caption>
</x:Label>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Selected/>
<x:Height>12965</x:Height>
<x:Width>13996</x:Width>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:ProtectContents>False</x:ProtectContents>
<x:DefaultRowHeight>315</x:DefaultRowHeight>
<x:standardwi



Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.