happy New Year everyone! I have a question about excel automatic page changing, I would like to ask you. . .

111player

I am working on a project that uses VC ++ to control excel documents. The settings of the pages are controlled by the parameters in the INI file, that is, they are all variable. Excel will automatically change pages according to the set paper size, header, footer, line height, etc. So how do I know the number of lines per page after excel auto-coordinate in programming? ? Unlimited languages, vb, vc, c # and so on. Hope to provide an interface. Thank you!

qvbcvb

Can the program also read the parameters in the ini file?

zhilang

Each worksheet object has a collection of HPageBreaks, representing all horizontal page breaks.
A HPageBreaks has 0 to n HPageBreak.
Each HPageBreak has a location attribute (a Range object), which is the cell in the first column of the row below the page break.
Each Range object has a row property. It represents the row number of the cell in the upper left corner of the range object.

111player

Thank youqvbcvb, what you said is exactly what we want users to allow.
Thank youzhilang, what you said is our final plan.

After the unremitting efforts of the project team, I finally found a sentence:
mExcelApp.ExecuteExcel4Macro ("Get.Document (64)")

(CApplication mExcelApp; // Application object of Excel)

The above is implemented under the VC ++ MFC project.