Corrispondece between cell excel dimensions and TXLSRow

[irene.brossa]

Good morning,

I've some questions to ask with delphi 2010.

1) I'm not able to find constant declaration list (such as cvaCenter, cbsMedium, xcRed, and so on) into help documentation.

2) How is the corrispondence between Excel row and column dimensions and your column and row dimensions?

3) I'm not able to set rows dimensions: I set, for exampe, XLS[0].Rows[2].Height := 500 but anythings happens.
Is there some working exampke to see?

I will be grateful if you can send me this information.

Best regards.

Irene Brossa

[larsa]

Hello

1. You you can't find a symbol name, search the source files.
cvaCenter, cbsMedium is in Xc12DataStyleSheet5
xcRed is in Xc12Utils5

2. I'm not sure what you mean. If you want to find the dimension of a worksheet, use:

Code: Select all

  XLS[0].CalcDimensions;
  C1 := XLS[0].FirstCol;
  R1 := XLS[0].FirstRow;
  C2 := XLS[0].LastCol;
  R2 := XLS[0].LastRow;

3. The code is correct. If you can't get it to work, please send a complete code sample.