Print areas on html-to-xlsx recipe



  • Is it possible to set print areas when using html-to-xlsx recipe?



  • I'm not sure exactly what you mean.
    However, you can hide areas using CSS.



  • This post is deleted!


  • I created a template with 7 sheets and I want to set the print areas such that each sheet is printed on a separate page0_1676280786844_cat.JPG



  • You mean the excel "Print area" feature. Unfortunately, this isn't possible in html-to-xlsx recipe.

    The excel advanced features need to be implemented using xlsx recipe helpers. You can look at the following example. Its post-processing already existing output from html-to-xlsx recipe and adding text rotation which is otherwise not possible.
    https://playground.jsreport.net/w/anon/tWGz8qVs

    I know such a solution is time-consuming. You will need to open desktop excel, create some print areas. Decompress the xlsx file and investigate how are the print areas represented in office xmls source. Then replicate the same using xlsx recipe helpers.


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.