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(); }