public static Worksheet ExportWorksheet(TranslationBase.TranslationLine[] lines) { Worksheet sheet = new Worksheet(); // Header sheet.AddNextCell("Operator"); sheet.AddNextCell("Comment"); sheet.AddNextCell("Key"); sheet.AddNextCell("Translation"); sheet.GoToNextRow(); // Fields foreach (var translation in lines) { sheet.AddNextCell(translation.Operator); sheet.AddNextCell(translation.Comment); sheet.AddNextCell(translation.Key); sheet.AddNextCell(translation.Translation); sheet.GoToNextRow(); } return(sheet); }
/// <summary> /// Sets a value into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction) /// </summary> /// <exception cref="WorksheetException">Throws a WorksheetException if no worksheet was defined</exception> /// <param name="cellValue">Value to set</param> public void Value(object cellValue) { NullCheck(); currentWorksheet.AddNextCell(cellValue); }