diff options
| -rw-r--r-- | RhSolutions.AddIn/Services/ExcelWriter.cs | 6 | ||||
| -rw-r--r-- | RhSolutions.AddIn/Tools/WorksheetExtensions.cs | 13 |
2 files changed, 19 insertions, 0 deletions
diff --git a/RhSolutions.AddIn/Services/ExcelWriter.cs b/RhSolutions.AddIn/Services/ExcelWriter.cs index 3471224..c9ab4e2 100644 --- a/RhSolutions.AddIn/Services/ExcelWriter.cs +++ b/RhSolutions.AddIn/Services/ExcelWriter.cs @@ -130,6 +130,9 @@ public class ExcelWriter : IWriter, IDisposable if (row != null) { + Range nameCell = worksheetCells[row, _nameCell.Column]; + nameCell.AddValue($"(замена арт. {positionAmount.Key.ProductSku})"); + foreach (int column in columns) { Range cell = worksheetCells[row, column]; @@ -146,6 +149,9 @@ public class ExcelWriter : IWriter, IDisposable if (row != null) { + Range nameCell = worksheetCells[row, _nameCell.Column]; + nameCell.AddValue($"(замена арт. {positionAmount.Key.ProductSku})"); + foreach (int column in columns) { Range cell = worksheetCells[row, column]; diff --git a/RhSolutions.AddIn/Tools/WorksheetExtensions.cs b/RhSolutions.AddIn/Tools/WorksheetExtensions.cs index 7d317a8..9d975d0 100644 --- a/RhSolutions.AddIn/Tools/WorksheetExtensions.cs +++ b/RhSolutions.AddIn/Tools/WorksheetExtensions.cs @@ -44,5 +44,18 @@ public static class WorksheetExtensions range.Value2 += value; } } + + public static void AddValue(this Range range, string value) + { + if (range.Value2 == null) + { + range.Value2 = value; + } + + else + { + range.Value2 = $"{range.Value2} {value}"; + } + } } |