merge

1 files changed, 21 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.Documents/ExcelWriter.cs b/Software/Visual_Studio/Tango.Documents/ExcelWriter.cs
index 2f1e4c29f..c344786e0 100644
--- a/Software/Visual_Studio/Tango.Documents/ExcelWriter.cs
+++ b/Software/Visual_Studio/Tango.Documents/ExcelWriter.cs
@@ -197,6 +197,27 @@ namespace Tango.Documents
             return s;
         }
 
+        /// <summary>
+        /// In case a sheet has a table with unknown rows update the size of the table . For example newRef="A1:B328" where 328 is count of rows table included header.
+        /// </summary>
+        /// <param name="sheetName">Name of the sheet.</param>
+        /// <param name="newRef">The new reference.</param>
+        public void UpdateTableSize( string sheetName, string newRef)
+        {
+            WorksheetPart work_sheet_part = GetWorkSheetPart(sheetName);
+            if (work_sheet_part.TableDefinitionParts != null)
+            {
+                TableDefinitionPart tableDefinitionPart = work_sheet_part.TableDefinitionParts.FirstOrDefault();
+                if (tableDefinitionPart == null)
+                    return;
+                Table excelTable = tableDefinitionPart.Table;
+               if(excelTable != null)
+                {
+                    excelTable.Reference = newRef;
+                }
+            }
+        }
+
         public void Dispose()
         {
             _document.Save();