Through the Interface

      {

        try

        {

          DBObject obj =

            tr.GetObject(per.ObjectId, OpenMode.ForRead);

          Table tb = obj as Table;

          // It should always be a table

          // but we'll check, just in case

          if (tb != null)

          {

            // The table must be open for write

            tb.UpgradeOpen();

            // Update the data link from the table

            tb.UpdateDataLink(

              UpdateDirection.DataToSource,

              UpdateOption.ForceFullSourceUpdate

            );

            // And the spreadsheet from the data link

            var dlIds = tb.Cells.GetDataLink();

            foreach (ObjectId dlId in dlIds)

            {

              var dl =

                (DataLink)tr.GetObject(dlId, OpenMode.ForWrite);

              dl.Update(

                UpdateDirection.DataToSource,

                UpdateOption.ForceFullSourceUpdate

              );

            }

          }

          tr.Commit();

          ed.WriteMessage(

            "\nUpdated the spreadsheet from the table."

          );

        }

        catch (Exception ex)

        {

     &
#160;    ed.WriteMessage("\nException: {0}", ex.Message);

        }

      }

    }

    static public List<string> GetSheetNames(string excelFileName)

    {

      var listSheets = new List<string>();

      var excel = new Excel.Application();

      var wbs = excel.Workbooks.Open(excelFileName);

      foreach (Excel.Worksheet sheet in wbs.Worksheets)

      {

        listSheets.Add(sheet.Name);

      }

      excel.Quit();

      return listSheets;

    }

    [CommandMethod("TFS")]

    static public void TableFromSpreadsheet()

    {

      const string dlName = "Import table from Excel demo";

      var doc =

        Application.DocumentManager.MdiActiveDocument;

      var db = doc.Database;

      var ed = doc.Editor;

      // Ask the user to select an XLS(X) file

      var ofd =

        new OpenFileDialog(

          "Select Excel spreadsheet to link",

          null,

          "xls; xlsx",

          "ExcelFileToLink",

          OpenFileDialog.OpenFileDialogFlags.

            DoNotTransferRemoteFiles

  &#
160;     );

      var dr = ofd.ShowDialog();

      if (dr != System.Windows.Forms.DialogResult.OK)

        return;

      // Display the name of the file and the contained sheets

      ed.WriteMessage(

        "\nFile selected was \"{0}\". Contains these sheets:",

        ofd.Filename

      );

      // First we get the sheet names

      var sheetNames = GetSheetNames(ofd.Filename);

      if (sheetNames.Count == 0)

      {

        ed.WriteMessage(

          "\nWorkbook doesn't contain any sheets."

        );

        return;

      }

      // And loop through, printing their names

      for (int i=0; i < sheetNames.Count; i++)

      {

        var name = sheetNames[i];

        ed.WriteMessage("\n{0} - {1}", i + 1, name);

      }

      // Ask the user to select one

      var pio = new PromptIntegerOptions("\nSelect a sheet");

      pio.AllowNegative = false;

      pio.AllowZero = false;

      pio.DefaultValue = 1;

      pio.UseDefaultValue = true;

      pio.LowerLimit = 1;

      pio.UpperLimit = sheetNames.Count;

      var pir = ed.GetInteger(pio);

      if (pir.Status != PromptStatus.OK)

        return;

      // Ask for the insertion point of the table

      var ppr = ed.GetPoint("\nEnter table insertion point");

      if (ppr.Status != PromptStatus.OK)

        return;

      // Remove any Data Link, if one exists already

      var dlm = db.DataLinkManager;

      var dlId = dlm.GetDataLink(dlName);

      if (dlId != ObjectId.Null)

      {

        dlm.RemoveDataLink(dlId);

      }

      // Create and add the new Data Link, this time with

      // a direction connection to the selected sheet

      var dl = new DataLink();

      dl.DataAdapterId = "AcExcel";

      dl.Name = dlName;

      dl.Description = "Excel fun with Through the Interface";

      dl.ConnectionString =

        ofd.Filename + "!" + sheetNames[pir.Value - 1];

      dl.DataLinkOption =

        DataLinkOption.PersistCache;

      dl.UpdateOption |=

        (int)UpdateOption.AllowSourceUpdate;

      dlId = dlm.AddDataLink(dl);

      using (var tr = doc.TransactionManager.StartTransaction())

      {

        tr.AddNewlyCreatedDBObject(dl, true);

        var bt =

          (BlockTable)tr.GetObject(

            db.BlockTableId,

            OpenMode.ForRead

          );

        // Create our table

        var tb = new Table();

        tb.TableStyle = db.Tablestyle;

        tb.Position = ppr.Value;

        tb.Cells.SetDataLink(dlId, true);

        tb.GenerateLayout();

        // Add it to the drawing

        var btr =

      
0;   (BlockTableRecord)tr.GetObject(

            db.CurrentSpaceId,

            OpenMode.ForWrite

          );

        btr.AppendEntity(tb);

        tr.AddNewlyCreatedDBObject(tb, true);

        tr.Commit();

      }

    }

  }

}