The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
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.
Hi
Thank you for sharing it
Terry
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
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!
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 ...