Skip to main content
I
ifomenko1-Visitor
1-Visitor
April 25, 2018
Question

Excel scriptable component: one table for different results with autofit and rich text formatting

  • April 25, 2018
  • 1 reply
  • 2622 views

Hi,

MCAD15

I want to output different tables (matrix) in one excel table component on my MCAD worksheet.

So, I have to format excel cells (auto fit width and height) before output.

Here attached I upload such component for those who need this.

I add a component with subscript, superscript and line feed formatting also.

 

1 reply

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
April 25, 2018

Hi

Thank you for sharing it

Terry

I
ifomenko1-VisitorAuthor
1-Visitor
April 28, 2018

Here I added the ability to assign font size and RTF flag to disable RTF formatting for the fastest output of a table.

Now, famous screen updating problem of excel is half solved

I changed

For i

 For j

 Cell.Value =Data(i,j)

with this one

DataRange.Resize(UBound(Data, 1)+1, UBound(Data, 2)+1) = Data

    W
    Werner_E25-Diamond I
    25-Diamond I
    April 28, 2018

    While I seldom use Excel components in my work this seems to be some good work done and its nice you share it with us. Thanks!

     

    Terms & ConditionsCookie settingsAccessibility statement