Import tables from excel formatting

Randy Long
Randy Long
in 2D Drafting

Good morning all,
I have a table I've imported from excel. I have a table style I've created and looks good as far as text height. However, I can't get the cells to shrink. It's like you can't make the data cell smaller. It reverts back to the "standard" size.
When I'm defining a style, is there a way to change? Not really sure on this because I have the same problem in standard AutoCAD.
Unless it's operator error. :)
Thanks and stay safe.

Comments

  • Guillaume
    Guillaume
    We regularly import excel into drawings and use view ports in paper space to adjust the size of the excel table. if we need a larger table, we increase the model table by using the scale command and reframe the paper space vfiew port to suit.
  • ALANH
    ALANH
    A table is a bit like a dimension it has lots of values you can change not just text height, you can make the data row size different than say Title & Header. Some of these options are not in the default table setting dcl. You may need to entmake table style or via say lisp edit the table style, lastly edit an existing table.

    To give you an idea a few.
    ; SetAutoScale (3)
    ; SetAutoScale2 (4)
    ; SetBackgroundColor (2)
    ; SetBackgroundColorNone (2)
    ; SetBlockAttributeValue (4)
    ; SetBlockAttributeValue2 (5)
    ; SetBlockAttributeValue232 (5)
    ; SetBlockAttributeValue32 (4)
    ; SetBlockRotation (3)
    ; SetBlockScale (3)
    ; SetBlockTableRecordId (4)
    ; SetBlockTableRecordId2 (5)
    ; SetBlockTableRecordId232 (5)
    ; SetBlockTableRecordId32 (4)
    ; SetBreakHeight (2)
    ; SetCellAlignment (3)
    ; SetCellBackgroundColor (3)
    ; SetCellBackgroundColorNone (3)
    ; SetCellContentColor (3)
    ; SetCellDataType (4)
    ; SetCellFormat (3)
    ; SetCellGridColor (4)
    ; SetCellGridLineWeight (4)
    ; SetCellGridVisibility (4)
    ; SetCellState (3)
    ; SetCellStyle (3)
    ; SetCellTextHeight (3)
    ; SetCellTextStyle (3)
    ; SetCellType (3)
    ; SetCellValue (3)
    ; SetCellValueFromText (4)
    ; SetColumnName (2)
    ; SetColumnWidth (2)
    ; SetContentColor (2)
    ; SetContentColor2 (4)
    ; SetContentLayout (3)
    ; SetCustomData (4)
    ; SetDataFormat (4)
    ; SetDataType (3)
    ; SetDataType2 (5)
    ; SetFieldId (3)
    ; SetFieldId2 (5)
    ; SetFieldId232 (5)
    ; SetFieldId32 (3)
    ; SetFormat (2)
    ; SetFormula (4)
    ; SetGridColor (3)
    ; SetGridColor2 (4)
    ; SetGridDoubleLineSpacing (4)
    ; SetGridLineStyle (4)
    ; SetGridLineWeight (3)
    ; SetGridLineWeight2 (4)
    ; SetGridLinetype (4)
    ; SetGridLinetype32 (4)
    ; SetGridVisibility (3)
    ; SetGridVisibility2 (4)
    ; SetMargin (4)
    ; SetOverride (4)
    ; SetRotation (4)
    ; SetRowHeight (2)
    ; SetScale (4)
    ; SetSubSelection (4)
    ; SetText (3)
    ; SetTextHeight (2)
    ; SetTextHeight2 (4)
    ; SetTextRotation (3)
    ; SetTextString (4)
    ; SetTextStyle (2)
    ; SetTextStyle2 (4)
    ; SetToolTip (3)
    ; SetValue (4)
    ; SetValueFromText (5)
    ; SetXData (2)