如何将由ajax生成的asp.net报告保存到excel文件中 [英] How do i save my asp.net Report genereated by ajax to excel file

问题描述

此代码我用来生成报告我只想将其输出保存在excel文件中



谢谢

this code i am using to generate report i simply want to save its output on excel file as well

Thanks

function runReport() {
  

	var reportName = $(''#employeeTree'').jstree(''get_selected'').children("a:eq(0)").text() + '' - '' + $(''#reports option:selected'').text() + '' ('' + $(''#reportYear'').val() + '')'';
	reportName = $.trim(reportName)
	var str = $("#employeeTree").jstree(''get_selected'').attr(''id'') + '' - '' + $(''#reports'').val() + ''-'' + $(''#reportYear'').val();
	var reportSelector = ''#'' + str.replace(/\s/gi, "");

	if ($(reportSelector).val() == undefined) {

		$(''#reportResults'').tabs("add", reportSelector, reportName);
		$(''#report'').html("Report Ran with " + $("#employeeTree").jstree("get_path", $("#employeeTree").jstree(''get_selected''), true));
		if ($.inArray('''' + User.pein, $("#employeeTree").jstree("get_path", $("#employeeTree").jstree(''get_selected''), true)) >= 0) {
			$(''#report'').html($(''#report'').html() + "<br /> its in there");
		}

		var params = new Object();
		params.pein = $("#employeeTree").jstree(''get_selected'').attr(''id'');
		params.year = $(''#reportYear'').val();
		params.reportSelector = reportSelector;
		if ($(''#reports'').val() == ''getReport_ActivityType_Specific'')
		{ params.activityType = $(''#asRequired'').val(); }
		if ($(''#reports'').val() == ''getReport_NetworkCode_Specific'')
		{ params.networkCode = $(''#asRequired'').val(); }
		
		callAjax(''/Reports/Reports.aspx'', $(''#reports'').val(), params, null, null, null)
		//Response.ContentType = "application/vnd.ms-excel";
	}
	else
	{ showWarningStatusMessage(''Report Exists'', ''Please Delete "'' + reportName + ''" and re-run the report'') }
}

推荐答案

（''＃employeeTree''）。jstree（''get_selected''）。children（a：eq （0））。text（）+'' - ''+

(''#employeeTree'').jstree(''get_selected'').children("a:eq(0)").text() + '' - '' +

（''＃quote option：selected''）。text（）+''（''+

(''#reports option:selected'').text() + '' ('' +

（''＃reportYear''）。val（）+''）'';
reportName =

(''#reportYear'').val() + '')''; reportName =

这篇关于如何将由ajax生成的asp.net报告保存到excel文件中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！