Getting Excel Cell Properties from Excel

[Mighty]

I have an ASP page which opens an Excel file in the background. I want to read information from a number of cells and display them as headings in my ASP page. However, in the Excel document there are a number of merged cells which are merged across columns and rows.

So I basically want to be able to check the equivalent "rowspan" and "colspan" properties of the excel cells and mirror that in my ASP page.

Are there such properties that I can read from the Excel file.

Mighty

 

[SkipVought]

Hi,

VBA questions are best addressed in forum707.

But regarding this question, check out the MergeArea property...

With YourCell.MergeArea
  msgbox "column span is " & .columns.count
  msgbox "row span is " & .rows.count
end with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Mighty]

Hi Skip,

Thanks for the solution and the pointer to the VBA forum.

Nick

Mighty