Hai everybody,


I'm new to this group.
I have a problem in changing the width of the columns automatically. How to change the column width according to the data it contents.
Friends send me solution.

Hi,

Please tell us a little more about what the problem is.

Hai Wilfried & everybody,


I'm new to this group.
I have a problem in changing the width of the columns automatically. How to change the column width according to the data it contents.
Friends send me solution.

I display the data, retrieved from database in a table.Each data may contain different width/length. According to the width/length of the data, the width of the column should change inorder to view full data.

Dear friends,
How to get active cell address of an opened excel from labview

Hi,

I'm not sure witch column you mean, but if you display a table you have it in own hand, or do I not understeand ?

I dont know about the cell address in excell...

Hi Baranivis & Wilfried,

I think that Baranivis is looking for some help about EXCEL component, and I think that MP2KMAG is not the best forum for that.

In that component you have the Column Objects and the Width Properties that you can change in your windows application.
So you can do programatically a lot of things with the EXCEL component, as we do here with MAPPOINT Activex.

Baranivis,
you can find what you are looking for in Excel Help when you are editing a Macro.

I am not a specialist, but you can choose your Range and let Excel Autofit the columns width:

Code:

Worksheets("Sheet1").Range("A1:E1").Columns.AutoFit

Wilfried,

Aren't you intersted by the MapPoint Technical Workshop in Paris?

http://blogs.microsoft.fr/arnaudgs/a.../17/28946.aspx


Ciao

Hai Wilfried,Mohamed & everybody,

First of all, I thankyou for ur immediate reply.

I am using labview. In that, normally i display some text/data from database or from excel in labview table.

By default the width of the columns in that table are same. Each data/text from the database or from excel may contain different width/length. According to the width/length of the data, the column's width of the table should change inorder to view full data/text.

How to change each column's width of the table according to the data, automatically.

Mr.Wilfried, I do not know about MapPoint. Plz explain about that.

Hi,

I am using labview

Sorry cannot help you with this. Never used it.

I do not know about MapPoint. Plz explain about that

You can use Mappoint activeX component in any development language. Doing so you have complete control about what happens.