On my company data web site, it have download button to download data as excel, but it only to same foler, and file name is random name.
If it can't be write JS script to download the data to specified folder and specified name.
Thanks!
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1"><title>
Genernal_Tool
</title><link href="Css/Body.css" rel="stylesheet" type="text/css" />
<script src="My97DatePicker/WdatePicker.js" type="text/javascript"></script>
<style>
.ui-autocomplete-loading
{
background: white url("images/ui-anim_basic_16x16.gif") right center no-repeat;
}
.style1
{
width: 100%;
}
.style2
{
width: 103px;
}
</style>
</head>
<script language="javascript" for="window" event="onresize">
if (document.title=="Window is locked") lockWindow();
</script>
<script src="../sys.js" type="text/javascript"></script>
<script type="text/javascript" src="../calendar/popcalendar.js"></script>
<body>
<form method="post" action="./Normal_Query.aspx" id="form1">
<div class="aspNetHidden">
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__LASTFOCUS" id="__LASTFOCUS" value="" />
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" />
</div>
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="E4B5808A" />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" />
</div>
<div class="topInfo">
<div class="title_span">
GenralTool 》》QueryTool</div>
</div>
<div>
<table style="width: 100%" cellpadding="2">
<tr>
<td>
<table class="BigTableA" cellpadding="3" cellspacing="0" border="1px" bordercolor="#0077b2">
<tr>
<td class="style2">
QueryReport:
</td>
<td>
<select name="drpQuery" onchange="javascript:setTimeout('__doPostBack(\'drpQuery\',\'\')', 0)" id="drpQuery" class="DropDownListCss" style="font-size:Large;width:800px;">
<option selected="selected" value="128">10111|Test_SN_Query[Test_SN_Query]</option>
</select>
<input type="submit" name="btnOK" value="OK" id="btnOK" class="ButtonCss" style="width:60px;" />
<input type="submit" name="btnQuery" value="Query" id="btnQuery" class="ButtonCss" style="width:67px;" />
<input type="submit" name="btnDownload" value="Download" id="btnDownload" class="ButtonCss" style="width:67px;" />
<input id="chkDown" type="checkbox" name="chkDown" /><label for="chkDown">Download </label>
</td>
</tr>
<tr>
<td colspan="2">
<table id="HolderTable" cellspacing="0" class="BigTable2" border="1px" style="border-color:#0077B2;border-collapse:collapse;">
<tr>
<td style="width:150px;"><span id="lblInfo0">Project(Such as:Ver/Ola):</span></td><td style="width:500px;"><input name="PartFamilyName" type="text" value="" id="PartFamilyName" style="width:500px;" /></td>
</tr><tr>
<td style="width:150px;"><span id="lblInfo1">Station:</span></td><td style="width:500px;"><select name="TestTypeID" id="TestTypeID" style="width:500px;">
<option selected="selected" value="0">All</option>
</select></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<span id="lblMessage" AutoPostBack="True" style="display:inline-block;color:Red;height:17px;width:940px;">
</span>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<table class="style1">
<tr>
<td>
<div>
<table class="Admin_Table" cellspacing="0" rules="all" border="1" id="grv" style="font-family:Calibri;font-size:12px;border-collapse:collapse;">
<tr class="Admin_Table_Title" style="white-space:nowrap;">
<th scope="col">SN_LaserSN</th>
<th scope="col">UnitState</th>
<th scope="col">StationType</th>
<th scope="col">Line</th>
<th scope="col">TestTime</th>
<th scope="col">FailDescription</th>
<th scope="col">testGeneration</th>
<th scope="col">TestResult_Final</th>
</tr>
<tr>
<td>U20050020AE</td>
<td>S5_test</td>
<td>Line1</td>
<td>1/6/2022 2:41:34 PM</td>
<td>DSP Trim Result</td>
<td>1</td>
<td>Pass</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>
1 ACCEPTED SOLUTION
Accepted Solutions
Helpful resources
Register for a Free Workshop
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Restore a Deleted Flow
Did you know that you could restore a deleted flow? Check out this helpful article.
Microsoft Build is May 24-26. Have you registered yet?
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
What difference can a User Group make for you?
At the monthly call, connect with other leaders and find out how community makes your experience even better.
