private void CreateGherkinExampleButtonClick(object sender, RibbonControlEventArgs e)
{
Range selection = Globals.ThisAddIn.Application.ActiveWindow.RangeSelection;
ExcelData excelData = new ExcelData();
int numRows = selection.Rows.Count;
int numCols = selection.Columns.Count;
for (int colIndex = 1; colIndex <= numCols; colIndex++)
{
for (int rowIndex = 1; rowIndex <= numRows; rowIndex++)
{
var o = ((Range)selection.Cells[rowIndex, colIndex]).Value2;
excelData.AddCell(colIndex - 1, rowIndex - 1, o.ToString());
}
}
StringBuilder sb = new StringBuilder();
bool isFirstRow = true;
for (int i = 0; i < numRows; i++)
{
List <string> rowValues = excelData.GetRowValues(i);
bool isFirstColumn = true;
foreach (string value in rowValues)
{
if (isFirstColumn)
{
sb.Append(" ");
isFirstColumn = false;
}
if (isFirstRow)
{
sb.AppendFormat("| {0} ", value);
}
else
{
sb.AppendFormat("| {0}", value);
}
}
isFirstRow = false;
sb.Append("|\r\n");
}
Clipboard.SetText(sb.ToString());
MessageBox.Show("Gherkin example added to clipboard. You can now paste it into the specification outline example", "Example added to clipboard", MessageBoxButtons.OK);
}
private void CreateGherkinExampleButtonClick(object sender, RibbonControlEventArgs e)
{
Range selection = Globals.ThisAddIn.Application.ActiveWindow.RangeSelection;
ExcelData excelData = new ExcelData();
int numRows = selection.Rows.Count;
int numCols = selection.Columns.Count;
for (int colIndex = 1; colIndex <= numCols; colIndex++)
{
for (int rowIndex = 1; rowIndex <= numRows; rowIndex++)
{
var o = ((Range) selection.Cells[rowIndex, colIndex]).Value2;
excelData.AddCell(colIndex-1, rowIndex-1, o.ToString());
}
}
StringBuilder sb = new StringBuilder();
bool isFirstRow = true;
for (int i = 0; i < numRows; i++)
{
List<string> rowValues = excelData.GetRowValues(i);
bool isFirstColumn = true;
foreach (string value in rowValues)
{
if (isFirstColumn)
{
sb.Append(" ");
isFirstColumn = false;
}
if (isFirstRow)
{
sb.AppendFormat("| {0} ", value);
}
else
{
sb.AppendFormat("| {0}", value);
}
}
isFirstRow = false;
sb.Append("|\r\n");
}
Clipboard.SetText(sb.ToString());
MessageBox.Show("Gherkin example added to clipboard. You can now paste it into the specification outline example", "Example added to clipboard", MessageBoxButtons.OK);
}
