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.
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
with this one
DataRange.Resize(UBound(Data, 1)+1, UBound(Data, 2)+1) = Data
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 ...