Axolot Data

Hi,

I am trying to use the BestFit column property, but i can't see that it does anything? What is it supposed to do?

Anton Bosch

Hello

The BestFit property is used by Excel 2007 files. I have never tested it, so I can't tell if it works.
If you want to size a column to the text width, use:

XLS.Sheets[x].Columns.AddIfNone(Col1,Col2 - Col1 + 1);
XLS.Sheets[x].AutoWidthCol(Col1,Col2);