Automating Excel horizontal page break in Delphi

Hi Experts,

I'm trying to add a horizontal page break in an Excel sheet using OLE automation with Delphi.

I've found (using recording an Excel macro) that the HPageBreaks.Add method should be used. But I can't get this working.

Does anyone ever used this method to insert a horizontal page break in an Excel sheet.

Thanks for any help,
JDN
LVL 1
JDNAsked:
Who is Participating?
 
steveaishConnect With a Mentor Commented:
I don't know if this is still open or not but what you need to do is this...

ExcelWorkSheet1.HPageBreaks.Add(IDispatch(ExcelWorkSheet1.Cells.Range['A25', emptyparam]));

This will put in a page break before line 25.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.