Resizing excel columns

Hi David,

Nice sets of components,

Any plan to implement column resizing? Or allow auto resize to happen.

I tried to look into the code but it seems more complicated then I could find in available documentation.

ExcelSheet.AutoFitColumn(index)  does not seem to work..

If you have time to code this, would be really great. Cell merge would also be a nice feature but also seems to be complicated.

Thanks for the work.

Replies to This Discussion

Permalink Reply by David Mans on November 10, 2013 at 9:08pm

Victor,

That's a great idea.

Im looking into restructuring the datatree inputs to allow for a second branch to access a sheet in workbooks right now {A;B}(C) = {Worksheet; Column}(Row), as well as trying to update the LIVE component to get it really functional.

Ill definitely look into that one and include it in the new release as soon as i can get to it.

Permalink Reply by Victor Leung on November 12, 2013 at 1:03pm

Hi David, great that you are interested in it.

Another issue that when I wrote script with your plugin and send it to other people, they experience this error:

I fixed it by re-pointing the path to my Excel interop (forgot what my filename exactly is...). But is there a way to just use perhaps Windows Marshal to figure this out when it could not find the dll.

RSS