I have a workflow where I am converting an excel sheet to a pdf document.
The way I implemented this since the activity doesn’t offer an option to convert only one sheet of a document to pdf, is by copying the current sheet to a new document and then converting that to pdf. I can’t use the option of start page and end page to solve this issue, since one sheet is not always one page.
The issue that I’m facing is the fact that for SOME sheets, the activity adds an extra blank page that I don’t need. I don’t know how to solve this, since it doesn’t do it for all sheets, so I can’t simply remove the last page for all sheets.
I’m assuming this happens because the sheet is a little too wide or too long to fit on one page, but there is nothing I can do about that. Any ideas?
Tried this. The result was weird and unexpected. So, basically, the excel is too wide to fit in the predetermined page size. The last page shows up as empty, but when read with “Read pdf text” activity, they are shown to contain the data from the cells that are very wide. It is very weird and I don’t know what to do with it.
I am unfortunately not allowed to share samples as they contain confidential data.
It is not empty string or a single character, as I stated earlier, it contains text from the excel that is being converted. It is not visible on the pdf, but it is returned as a result when reading the pdf.
The excel cells that are included in the output text are (I’m assuming) too wide to fit in one page of the pdf. However, they are not “fully filled” with text, and they are made that wide as a styling choice (so most of the cell is blank space, it only contains a single word in the middle).
The pdf page that is read looks empty to a human, but when reading it with the Read Pdf Text activity it returns the words from those “wide” cells.
Unfortunately I can’t assume that, as sometimes the excel only contains one word / two / three words etc. at the end of the page that actually needs to be included in the pdf (that is pushed in the second page).