Skip to main content

i would like to merge the output pdf that include image to put directly inside sheet file at excel file .

 

Do we have method to do that inside FME workbench ?

or is there a method by using python in workbench to do that?

thanks in advance .

FME 2018

Hi @spiderman​ 

Let me see if I did understand you.

 

Do you have PDF's files and is necessary to get image from these files -> combine the images and write in Excel file, correct?

 

 

Thanks in Advance,

Danilo


Hi @spiderman​ 

Let me see if I did understand you.

 

Do you have PDF's files and is necessary to get image from these files -> combine the images and write in Excel file, correct?

 

 

Thanks in Advance,

Danilo

thanks for reply ,

i am creating two output by FME workbench ,one output pdf and also excel file output , i would like as u have written to combine the data that i have written in pdf and it has image includes some cables and so on to add this image in sheet at excel file instead of seperated pdf file .

i would like to have both of them in one excel file

FME 20018


Hi @spiderman​ 

You should be able to do this by rasterizing the vector data in the workflow that creates the PDF. This article that demonstrates a few methods of creating raster data from vector. After creating the raster, you insert the raster into the Excel workbook following the instructions here. I hope this helps!


Hi @debbiatsafe​ Thanks for ur suggestion , i got the idea but i have still problem .

i was using pdf formatter page to let the frame around my output (catographic map with lines ) and specific frame , but now i am using vectoronRsteroverlayer so it works great when i put map with line only ,and i have added also the method to write in excel file .it works great.but my problem ,how could i add the frame around my image output ? ,image output includes catographic map with lines over it .

my frame includes rectangular box and at right corner of rectangular box ,a small table to write some data about the map ,name,type,etc .

could you tell me ,how could i arrange the frame around my output?

Thanks alot for help .

FME 2018


Hi @debbiatsafe​ Thanks for ur suggestion , i got the idea but i have still problem .

i was using pdf formatter page to let the frame around my output (catographic map with lines ) and specific frame , but now i am using vectoronRsteroverlayer so it works great when i put map with line only ,and i have added also the method to write in excel file .it works great.but my problem ,how could i add the frame around my image output ? ,image output includes catographic map with lines over it .

my frame includes rectangular box and at right corner of rectangular box ,a small table to write some data about the map ,name,type,etc .

could you tell me ,how could i arrange the frame around my output?

Thanks alot for help .

FME 2018

One method you could try is to create the required page elements (frame, table), then move and scale them so they appear as expected in relation to your cartographic features. You can look at the frames in the PDFPageFormatter as a starting point for the size and positioning of the page elements. I have attached an example of this workflow based on this article.

Alternatively, if you do not wish to recreate the page elements, the PDF reader does offer a rasterize page option. Create the PDF using a FeatureWriter and then read it back into the workspace as a rasterized page before writing to Excel.


One method you could try is to create the required page elements (frame, table), then move and scale them so they appear as expected in relation to your cartographic features. You can look at the frames in the PDFPageFormatter as a starting point for the size and positioning of the page elements. I have attached an example of this workflow based on this article.

Alternatively, if you do not wish to recreate the page elements, the PDF reader does offer a rasterize page option. Create the PDF using a FeatureWriter and then read it back into the workspace as a rasterized page before writing to Excel.

Thanks alot ,it helps me alot


Reply