10-06-2011 08:49 AM
I have an excel templpate that contains a table that is already formatted with lots of formulas and colroed celss, etc. Depending on the query that I run with labview, I produce a data result that is exported to excel and then I want to resize teh excel table to fit the data. I want to resize a table with activex commands in labview. How do I do this?
Solved! Go to Solution.
10-06-2011 09:15 AM
Your question doesn't quite match the Subject of your thread, but anyway, what do you mean "resize the table?" By its very nature, Excel is a borderless table.
10-06-2011 09:19 AM
In Excel 2007+ there is a table object that can be resized by manually selecting the table and going to the table tools>design tab to change its dimensions...
After I write my data I would like to programmatically resize the table width in my template file once populated to the same size as the data written into it.
10-06-2011 09:22 AM
the table object in excel iks what I am talking about specifically. It is on the level as a range in the app but I dont see it in the activeX breakdown
10-06-2011 10:48 AM
@id wrote:
I have an excel templpate that contains a table that is already formatted with lots of formulas and colroed celss, etc. Depending on the query that I run with labview, I produce a data result that is exported to excel and then I want to resize teh excel table to fit the data. I want to resize a table with activex commands in labview. How do I do this?
If your table contains lot of formulas you might end up with invalid references if you delete and shift columns.
Ben64
10-06-2011 02:08 PM
I dont have fomrulas other than conditional formatiing colring the cells if they match a certain string.
06-04-2012 07:25 AM
@id wrote:
the table object in excel iks what I am talking about specifically. It is on the level as a range in the app but I dont see it in the activeX breakdown
I'm not sure why you are asking about the Excel ActiveX Object Model on a LabVIEW forum. You're better off asking about that on a Microsoft Excel forum. Once you know the proper Excel properies/methods to use, then you can do the same thing in LabVIEW.
06-04-2012 08:23 AM - edited 06-04-2012 08:24 AM
@id wrote:
the table object in excel iks what I am talking about specifically. It is on the level as a range in the app but I dont see it in the activeX breakdown
There is not "table" object in Excel object model http://msdn.microsoft.com/en-us/library/bb149081%28v=office.12%29.
What the heck are you talking about?????
06-04-2012 10:27 AM
Please see attached excel worksheet to see the table that I am asking about. It has a simple table but explains what I need to do in comments below it....
06-04-2012 10:32 AM - edited 06-04-2012 10:33 AM
@id wrote:
Please see attached excel worksheet to see the table that I am asking about. It has a simple table but explains what I need to do in comments below it....
You may think it is a table, but in the Excel Object Model, there isn't such thing as a "Table".
If it isn't there, you can't manipulate it.