main / Source / Excel / Excel.BizLogic / Extensions / WorksheetExtensions.cs

Diff from to

Source/Excel/Excel.BizLogic/Extensions/WorksheetExtensions.cs

 
                         metadataTool = sheet.CreateParaMetadataTable();
 
-                        metadataTool.Resize(workSheet.Range["D1", "G" + metadata.Count]);
+                        metadataTool.Resize(workSheet.Range["D1", "I" + metadata.Count]);
                         metadataTool.AutoSetDataBoundColumnHeaders = true;
                         metadataTool.TableStyle = Common.Constants.MetadataTableStyleName;
 
                         {
                             for (int rCnt = 2; rCnt <= metadataList.Range.Rows.Count; rCnt++)
                             {
-                                var typeCell = (Range)metadataList.Range.Cells[rCnt, 3];
+                                var typeCell = (Range)metadataList.Range.Cells[rCnt, 5];
 
                                 typeCell.Validation.Delete();
                                 typeCell.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, XlFormatConditionOperator.xlBetween, Common.Constants.ParameterMetadataType);
                                 typeCell.Validation.InCellDropdown = true;
                             }
                         }
+                        
                     }
 
                     workSheet.UsedRange.Columns.AutoFit();
             {
                 if (ParametadataTable == null)
                 {
-                    ParametadataTable = sheet.Controls.AddListObject(sheet.Range["D1", "G1"], Excel.Common.Constants.ParaMetadataRangeName);
+                    ParametadataTable = sheet.Controls.AddListObject(sheet.Range["D1", "I1"], Excel.Common.Constants.ParaMetadataRangeName);
                 }
             }
 
         private static System.Data.DataTable GetParaDataTable(List<ParameterDetail> metadata)
         {
             System.Data.DataTable table = new System.Data.DataTable();
-
+            table.Columns.Add("EntityName");
+            table.Columns.Add("EntityDescription");
             table.Columns.Add("Name");
             table.Columns.Add("Description");
             table.Columns.Add("Type");
             foreach (var item in metadata)
             {
                 row = table.NewRow();
+                row["EntityName"] = item.EntityName;
+                row["EntityDescription"] = item.EntityDescription;
                 row["Name"] = item.Name;
                 row["Description"] = item.Description;
                 row["Type"] = item.Type;
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.