VFP 9 Excel Automation - How To Read Sheet Header Info

[Auguy]

How do I get the value of the cells in an Excel (xlsx) sheet header using automation. I can open and read the rows and columns OK, but not the header info.

Auguy
Sylvania/Toledo Ohio

 

[Mike Lewis]

Header info? Surely a header in Excel is just another cell?

Or do you mean the sheet name? If so, it's simply the Name property of the Sheet object. For example:

[tt]? loWorkbook.Sheets(1).Name[/tt]

If that doesn't answer your question, please clarify it.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Auguy]

Thanks Mike. No, I can get the sheet name just fine. When I open the xlsx file manually there is a section above row 1 labeled Header that has text in it. Please see attached file. I tried Row 0 with no luck and I can't find any reference as to how to read this info with my google searches. I've some info about turning Headers on/off, but not in automation for reading purposes.

Auguy
Sylvania/Toledo Ohio

 

[Auguy]

Oops, it's the area with "Gasoline" in it.

Auguy
Sylvania/Toledo Ohio

 

[Auguy]

Row 1 is the "Seller name", etc.

Auguy
Sylvania/Toledo Ohio

 

[Auguy]

I think I found it. At least a start

oExcel.ActiveSheet.PageSetup.LeftHeader

Auguy
Sylvania/Toledo Ohio

 

[JRB-Bldr]

I agree with Auguy. Your JPG screen snapshot does not show the Row Numbers.

If you made the Row Numbers visible I am sure that you would find that "Seller Name" and the other 'Header" names are in one of the standard rows.

I doubt that it is Row #1 since "Gasoline" appears in what might be Row #3 or 4 then the 'header' appears down even a few more rows that.

Do a Google search for: excel 2010 make row numbers visible and then make your Row numbers visible.

Good Luck,
JRB-Bldr

 

[Auguy]

That's not the issue. I apologize for the bad screen print, I should have included the row numbers. Row 1 is the row with "SELLER NAME". It's the information above row 1 that I need. I found this that will give me the header info I was looking for.

oExcel.ActiveSheet.PageSetup.LeftHeader

This link explains the header and footer properties and how to read them.

http://www.cpearson.com/excel/headfoot.htm

Auguy
Sylvania/Toledo Ohio

 

[Mike Lewis]

So are you saying that my first thought was correct: that what you call the header is in fact simply a row of cells at or near the top of the sheet?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Auguy]

Here's a better screen shot.

Auguy
Sylvania/Toledo Ohio

 

[Mike Lewis]

OK. Got it now.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Auguy]

Sorry Mike (and others), I should have taken more time when i posted the original question and screen shot to make sure it was clear what I needed.

Auguy
Sylvania/Toledo Ohio

 

[Auguy]

It's been a long time since I used Excel automation. I forget, do I need to include anything in my deployment package when I use this code?

oExcel = CreateObject("Excel.Application")

Auguy
Sylvania/Toledo Ohio

 

[Mike Lewis]

No, you don't need to deploy anything special. Just make sure your end-user has Excel installed.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Auguy]

Thanks once again Mike!

Auguy
Sylvania/Toledo Ohio

 

[Scott24x7]

Auguy,
Did you solve this?
The information in Excel is in the Page Setup area (Headers and footers are not part of the visible sheet, you can only see them at print or print/preview time). Each sheet can have it's own, and up to 3 of them: left, center and right. Same with footer.
The center is most commonly used for text to label the page when it's printed. Right and left frequently have logo or date fields.

Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Auguy]

Yes I did thanks. See my post from time "19:36" above. Funny, when I open the file I see the Headers all of the time, but I did not create this file so I'm not sure what they did if this is not the default for displaying the sheets.


Auguy
Sylvania/Toledo Ohio