# Save LibXL made Excel to PDF

**URL:** <https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486>\
**Category:** questions\
**Created:** [August 12, 2023, 4:20pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486 "2023-08-12T16:20:21Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![BILAZ](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ecd19e/32.png) [@BILAZ](https://clarionhub.com/u/BILAZ)\
**Post date:** [August 12, 2023, 4:20pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/1 "2023-08-12T16:20:21Z")

</div>

Is there a product, template or other that allows save Excel to PDF

I need to directly edit my Excel tables generated by my program (APP) without opening EXCEL

I am writing a program using LibXL. I am analyzing all the cells (font,color,size..) to print this Excel file directly in my Clarion Report

Does Office Inside from Capesoft that I acquired allow to Import File Excel and save it to PDF ?

Thanks

Alla

---

<div class="post-metadata">

**Author:** ![e\_mano\_e](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/c77e96/32.png) [@e\_mano\_e](https://clarionhub.com/u/e_mano_e)\
**Post date:** [August 12, 2023, 4:26pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/2 "2023-08-12T16:26:35Z")

</div>

Excel allows to save a file as PDF. And because you already use Libxl you can just do a saveas with libxl i think.

---

<div class="post-metadata">

**Author:** ![jslarve](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/e480ec/32.png) [@jslarve](https://clarionhub.com/u/jslarve)\
**Post date:** [August 12, 2023, 8:16pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/3 "2023-08-12T20:16:39Z")

</div>

LibXL is not Excel, nor does it utilize Excel. Whatever printing output Excel has, would not necessarily translate to LibXL, unless LibXL specifically states that capability.

---

<div class="post-metadata">

**Author:** ![SerhatSatir](https://clarionhub.com/user_avatar/clarionhub.com/serhatsatir/32/1953_2.png) [@SerhatSatir](https://clarionhub.com/u/SerhatSatir)\
**Post date:** [August 14, 2023, 3:25pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/4 "2023-08-14T15:25:46Z")

</div>

Office Inside template is opening Excel.  
On the other hand, LibXL does not has function to load Excel file. How do you solve that case?

---

<div class="post-metadata">

**Author:** ![BILAZ](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ecd19e/32.png) [@BILAZ](https://clarionhub.com/u/BILAZ)\
**Post date:** [August 15, 2023, 10:39am UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/5 "2023-08-15T10:39:48Z")

</div>

I have a clarion APP that creates an EXCEL workbook  
I would like to save it automatically in IMAGE format and integrate it into my report  
If INSIDE OFFICE capsoft allows it (Class oiObjectoiObject)  
my problem will be solved  
The user does not have access to this excel workbook

---

<div class="post-metadata">

**Author:** ![jslarve](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/e480ec/32.png) [@jslarve](https://clarionhub.com/u/jslarve)\
**Post date:** [August 15, 2023, 2:54pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/6 "2023-08-15T14:54:06Z")

</div>

Hello - I’m not sure whether Office Inside has all of those methods wrapped, but if you search for  
[vba+excel+range+copypicture+export+image](https://www.google.com/search?q=vba+excel+range+copypicture+export+image), maybe you will come up with a solution.

---

<div class="post-metadata">

**Author:** ![JonW](https://clarionhub.com/user_avatar/clarionhub.com/jonw/32/1344_2.png) [@JonW](https://clarionhub.com/u/JonW)\
**Post date:** [August 15, 2023, 4:11pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/7 "2023-08-15T16:11:50Z")

</div>

As well as SaveAs pdf in Excel, you can also print to PDF using the “Microsoft Print to PDF” printer driver which probably comes with Windows, or at least with Microsoft Office.They both work fine. With my rather complex eight page workbook printing actually requires three prints because the page orientation changes, and then I have to merge them together afterwards. SaveAs pdf does the whole file at once.

---

<div class="post-metadata">

**Author:** ![BILAZ](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ecd19e/32.png) [@BILAZ](https://clarionhub.com/u/BILAZ)\
**Post date:** [August 15, 2023, 4:51pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/8 "2023-08-15T16:51:07Z")

</div>

Hello  
Thank you , the idea is excellent I will integrate this macro VBA in excel,  
I hope that with OFFICE INSIDE , libxl or libxlswriter I can run this macro  
Thanks

---

<div class="post-metadata">

**Author:** ![BILAZ](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ecd19e/32.png) [@BILAZ](https://clarionhub.com/u/BILAZ)\
**Post date:** [August 15, 2023, 6:50pm UTC](https://clarionhub.com/t/save-libxl-made-excel-to-pdf/6486/9 "2023-08-15T18:50:33Z")

</div>

Hello  
I used a POWERSHELL script that I integrated into my APP  
simpler than VBA macro

## Load Excel file

$ExcelPath = ‘C:\cgtemp85\TestExcel.xlsx’  
$Excel = New-Object -ComObject Excel.Application  
$Excel.Visible = $true  
$ExcelWordBook = $Excel.Workbooks.Open($ExcelPath)  
$ExcelWorkSheet = $Excel.WorkSheets.item(‘Sheet1’)

## save as image

$ExcelWordBook.ActiveSheet.Range(“a1:f64”).Select()  
$Excel.Selection.Copy()

$image = Get-Clipboard -Format Image  
$image.Save(‘C:\cgtemp85\TestExcel.jpg’)
