asp-excel javascript-excel

1. individual Name
2. fileName P_fileName
3. p_mode
4. Test the list
5 Edit the Button
6. Edit the call Program.

Example : salesBydotCom

Step 1
p_mode=trim(Request.querystring("p_mode")) 'for excel
p_fileName=trim(Request.querystring("p_fileName")) 'for excel

Step 2
fileName=Int((max-min+1)*Rnd+min)
if p_fileName<>"" then  'for excel
fileName=p_fileName 'for excel
end if 'for excel

Step 3
'for Excel
if p_mode="E" then
ReportName=ReportName+"_"+pcus+"_"
end if

Step 5

for each x in acustomerNOs

html=x

o=x

x=Replace(x, ",", "_")

x=Replace(x, " ", "_")

x=Replace(x, "'", "_")

o=Replace(o, "'", "_")

o=Replace(o, " ", "__")

response.write("<button class='customerButton' style='display:none; float:left;' onclick=custDisplay3('"&x&"','"&o&"');>"&html&"</button>")

next

Step 6
// for excel
function custDisplay3(pcustcode,sql_custcode){
$('.allcustcode').css('display','none');
$('.class_'+pcustcode).css('display','block');
sql_custcode=sql_custcode.replace(/__/g," ");
i=sql_custcode.indexOf("_");
if (i>1) sql_custcode=sql_custcode.substring(0,i);
url_='salesByDotComsList10.asp?cus='+sql_custcode+'&p_fileName=<%=fileName%>&p_mode=E&callback=?';
$.getJSON(url_,
function(data) {
if (data[0]){
for (r=0 ; r<data.length; r++)
{
//alert(data[0][0]);
//obj_field.options[r+1] = new Option(data[r][0],data[r][1]);
}
}
}
)
}

function callExcel Program(pcustcode){
$('.allcustcode').css('display','none');
$('.class_'+pcustcode).css('display','block');
sql_custcode=pcustcode
sql_custcode=sql_custcode.replace(/__/g," ");
i=sql_custcode.indexOf("_");
if (i>1) sql_custcode=sql_custcode.substring(0,i);
url_='forecastVSActualCustomerFtyList9.asp?cus='+sql_custcode+'&p_fileName=<%=fileName%>&p_mode=E&callback=?';
$.getJSON(url_,
function(data) {
}
) 
}