insert pagebreake to excel report

[idans]

Hi 

I try to add pagebreak in excel report , but i get error code -2147352571 right after invoke node used to add this page break., 

in this vi i calculate the cell where i want to add this page break and add some text one cell before' is there any other way to add page break?

Regards 

Idan 

add pagebreak

[Bob_Schor]

Have you investigated how (in Excel itself) to insert a Page Break?  There is a method, but I have no idea what it really does (it seems unlikely that it adds a <Vertical Tab>, as the same command also seems to be used to add horizontal page breaks (<Horizontal Tab>), a different Ansi character ...

There are also Excel macros that might do this.  Note that you are starting to "push the boundaries" of what the Report Generation Toolkit can do and also what it is designed to do (this is not meant as a criticism of your actions, but a plea not to be mad at NI if it doesn't do "everything" you might want ...).

Bob Schor

[PsyenceFact · Accepted solution]

The "Before" input of the VPageBreaks:Add method should be a Range reference rather a cell address.  Use the _Worksheet:Range method with the cell address as "Cell1" input to obtain the reference and pass it to the invoke node (no need to explicitly convert to a variant).

Andy

[idans]

Hi Bob

yes i looked in excel documentation and I found Hpagebreake property ,you can see in this link https://docs.microsoft.com/en-us/office/vba/api/excel.vpagebreaks.add ' in their example it look very strait forward , but in labview i get this error that nean type mismatch, but what that means?  if what i did is pushing toolbox limit? i dont know.  

[idans]

thanks andy it worked