public ActionResult Submit(string selectedData)
{
SpreadsheetSelectedData spreadsheetSelectedData = JSON.Deserialize <SpreadsheetSelectedData>(selectedData);
var label = X.GetCmp <Label>("Label1");
if (!spreadsheetSelectedData.IsEmpty())
{
if (spreadsheetSelectedData.Rows.Count > 0)
{
this.OutputRows(spreadsheetSelectedData.Rows, label);
}
else if (spreadsheetSelectedData.Columns.Count > 0)
{
this.OutputColumns(spreadsheetSelectedData.Columns, label);
}
else
{
this.OutputCells(spreadsheetSelectedData, label);
}
}
else
{
label.Html = "<h3>No selection</h3>";
}
return(this.Direct());
}
protected void OutputCells(SpreadsheetSelectedData selectedData, Label label)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table width='100%' cellspacing='5'>");
sb.Append("<tr>");
this.AddHeaderCell(sb, "Range");
this.AddHeaderCell(sb, "RowIndex");
this.AddHeaderCell(sb, "RecordID");
this.AddHeaderCell(sb, "ColumnID");
this.AddHeaderCell(sb, "ColumnDataIndex");
this.AddHeaderCell(sb, "ColumnIndex");
sb.Append("</tr>");
sb.Append("<tr>");
this.AddCell(sb, "Start");
this.AddCell(sb, selectedData.RangeStart.RowIndex.ToString());
this.AddCell(sb, selectedData.RangeStart.RecordID);
this.AddCell(sb, selectedData.RangeStart.ColumnID);
this.AddCell(sb, selectedData.RangeStart.ColumnDataIndex);
this.AddCell(sb, selectedData.RangeStart.ColumnIndex.ToString());
sb.Append("</tr>");
sb.Append("<tr>");
this.AddCell(sb, "End");
this.AddCell(sb, selectedData.RangeEnd.RowIndex.ToString());
this.AddCell(sb, selectedData.RangeEnd.RecordID);
this.AddCell(sb, selectedData.RangeEnd.ColumnID);
this.AddCell(sb, selectedData.RangeEnd.ColumnDataIndex);
this.AddCell(sb, selectedData.RangeEnd.ColumnIndex.ToString());
sb.Append("</tr>");
sb.Append("</table>");
label.Html = sb.ToString();
}
protected void OutputCells(SpreadsheetSelectedData selectedData, Label label)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table width='100%' cellspacing='5'>");
sb.Append("<tr>");
this.AddHeaderCell(sb, "Range");
this.AddHeaderCell(sb, "RowIndex");
this.AddHeaderCell(sb, "RecordID");
this.AddHeaderCell(sb, "ColumnID");
this.AddHeaderCell(sb, "ColumnDataIndex");
this.AddHeaderCell(sb, "ColumnIndex");
sb.Append("</tr>");
sb.Append("<tr>");
this.AddCell(sb, "Start");
this.AddCell(sb, selectedData.RangeStart.RowIndex.ToString());
this.AddCell(sb, selectedData.RangeStart.RecordID);
this.AddCell(sb, selectedData.RangeStart.ColumnID);
this.AddCell(sb, selectedData.RangeStart.ColumnDataIndex);
this.AddCell(sb, selectedData.RangeStart.ColumnIndex.ToString());
sb.Append("</tr>");
sb.Append("<tr>");
this.AddCell(sb, "End");
this.AddCell(sb, selectedData.RangeEnd.RowIndex.ToString());
this.AddCell(sb, selectedData.RangeEnd.RecordID);
this.AddCell(sb, selectedData.RangeEnd.ColumnID);
this.AddCell(sb, selectedData.RangeEnd.ColumnDataIndex);
this.AddCell(sb, selectedData.RangeEnd.ColumnIndex.ToString());
sb.Append("</tr>");
sb.Append("</table>");
label.Html = sb.ToString();
}
