using System.Collections.Generic;
public static void Main() {
var worksheet = new WorkSheet();
for (var i = 0; i < 100; i++) {
for (var j = 0; j < 75; j++) {
worksheet.Cells[i, j] = new Cell { Value = "Value " + i + "," + j };
worksheet.Cells[7, 24] = new Cell { Value = null };
worksheet.Cells[99, 5] = new Cell { Value = null };
var configuredColumns = new int[] { 5, 22, 24, 27, 29, 32, 34, 37, 39, 43, 45, 48, 50, 54, 56, 59, 61, 65, 67, 71, 73 };
var allRowTexts = new List<string>();
for (int row = 5; worksheet.Cells[row, 5].Value != null; row++) {
var rowText = new StringBuilder();
foreach (var col in configuredColumns) {
var cell = worksheet.Cells[row, col];
if (cell.Value == null) {
rowText.Append("leer" + "\t");
rowText.Append(cell.Value.ToString() + "\t");
allRowTexts.Add(rowText.ToString());
foreach(var row in allRowTexts) {
Cells = new Cell[100, 75];
public override string ToString() {