使用asp.net动态创建Excel数据透视表 [英] Dynamiclly Create excel pivot table using asp.net

问题描述

如何使用c#在asp.net中动态创建数据透视表并在excel中显示?我想从网页中做到这一点.需要代码示例

how do you dynamically create a pivot table in asp.net using c# and display it in excel? I want to do this from within a web page. Need code example

推荐答案

hi，

请参阅以下为您提供枢纽分析表的功能

私有DataTable GenerateTransposedTable(DataTable inputTable)
{
DataTable outputTable = new DataTable();

//标题行的第一列与inputTable
中的相同 outputTable.Columns.Add(inputTable.Columns [0] .ColumnName.ToString());

//标题行的第二列开始，输入列的第一列
foreach(inputTable.Rows中的DataRow inRow)
{
字符串newColName = inRow [0] .ToString();
outputTable.Columns.Add(newColName);
}

//通过循环列添加行
for(int rCount = 1; rCount&=; inputTable.Columns.Count-1; rCount ++)
{
DataRow newRow = outputTable.NewRow();

//第一列是inputTable的Header行的第二列
newRow [0] = inputTable.Columns [rCount] .ColumnName.ToString();
for(int cCount = 0; cCount< = inputTable.Rows.Count-1; cCount ++)
{
字符串colValue = inputTable.Rows [cCount] [rCount] .ToString();
newRow [cCount + 1] = colValue;
}
outputTable.Rows.Add(newRow);
}

返回outputTable;
}

please see the following function which gives you the pivoted table

private DataTable GenerateTransposedTable(DataTable inputTable)
{
DataTable outputTable = new DataTable();

// Header row''s first column is same as in inputTable
outputTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());

// Header row''s second column onwards, ''inputTable''s first column taken
foreach (DataRow inRow in inputTable.Rows)
{
string newColName = inRow[0].ToString();
outputTable.Columns.Add(newColName);
}

// Add rows by looping columns
for (int rCount = 1; rCount <= inputTable.Columns.Count - 1; rCount++)
{
DataRow newRow = outputTable.NewRow();

// First column is inputTable''s Header row''s second column
newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();
for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)
{
string colValue = inputTable.Rows[cCount][rCount].ToString();
newRow[cCount + 1] = colValue;
}
outputTable.Rows.Add(newRow);
}

return outputTable;
}

检查此

使用ActiveX创建数据透视表和图表 [

Check this

Creating Pivot Tables and Charts Using ActiveX[^]

这篇关于使用asp.net动态创建Excel数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！