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

[ifomenko]

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.

[terryhendicott]

Hi

Thank you for sharing it

Terry

[ifomenko]

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

[Werner_E]

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!

[ifomenko]

I changed "." to "_" for subscript because of the situation with vector output in the string form "1.1,1.2,1.3".

In this case, my script makes symbols after dot as a subscript, it`s not right.

There is one more problem with excel formatting - it`s impossible to create subscript in superscript or superscript in subscript. I don`t need this but ...