topic Re: Excel - Print (Fit to Page) Code Stage in Product Forum

Excel - Print (Fit to Page) Code Stage

MatthewBelia1 — Thu, 14 Nov 2019 20:42:00 GMT

Hi All,

Has anyone ever created a code stage for Excel to fit to pages when printing (e.g fit to 1 page wide/tall)?

Thanks!

Re: Excel - Print (Fit to Page) Code Stage

dvashish — Tue, 22 Oct 2024 18:52:25 GMT

I am also looking for this solution? Can anyone provide solution to this issue please?

Re: Excel - Print (Fit to Page) Code Stage

harish.mogulluri — Thu, 24 Oct 2024 18:22:28 GMT

Hi @MatthewBelia1 and @dvashish

You can create new action, Here I named as Fit to page and copy" Check instance and workbook" step from Activate worksheet action as in the screenshot.

There are no output parameters for this action.

In the code stage use below code. you can tweak based on your requirement

Dim ws As Object = GetWorksheet(handle, workbookName, worksheetName, False) Dim sheetExists As Boolean = ws IsNot Nothing ' If the worksheet exists, apply the fit to page setup If sheetExists Then ws.PageSetup.Zoom = False ' Disable Zoom to enable FitToPages ws.PageSetup.FitToPagesWide = 1 ' Fit to one page wide ws.PageSetup.FitToPagesTall = 1 ' Fit to one page tall End If

Re: Excel - Print (Fit to Page) Code Stage

dvashish — Fri, 25 Oct 2024 14:09:26 GMT

Hi @harish.mogulluri ,

Thank you for sharing the solution.
Would it be possible to input the number of sheets in this code.
Like, I have to make the first three tabs/sheets of the excel to fit to page.

Thanks!

Re: Excel - Print (Fit to Page) Code Stage

harish.mogulluri — Fri, 25 Oct 2024 14:19:48 GMT

Hi @dvashish
You can loop through each worksheet and update the excel to fit to page

If you found this solution helpful, please mark it as the best answer or give it a thumbs-up