Jump to content

Finding difficulty on _ExcelSaveAs function


Recommended Posts

Hi All,

I am finding difficulty on using the function _ExcelBookSaveAs. I am trying to save the opened excel as PDF file on my desktop where i am unable to do that. could you please someone help me on this ? example code is below!

$open = _ExcelBookOpen(@Desktopdir&"\Change log.xlsx")

Local $save = _ExcelBookSaveAs($open, "C:\temp\ExcelTest","pdf")

If Not @error Then

_FileWriteLog($Excellog,"INFO"&""&">>"&"Excel Save Function>>"&"Excel has been saved successfully")

Else

_FileWriteLog($Excellog,"ERROR"&""&">>"&"Excel Save Function>>"&"Unable to Save an excel work book and the occured error is "& @error)

EndIf

;end of saving excel sheet

Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font]

Link to comment
Share on other sites

Is export to PDF supported in your version of Excel? You might have to print to a PDF driver like "CutePDF Writer" instead.

:)

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law
Link to comment
Share on other sites

i am able to print the excel as PDF successfully in my version of EXcel. What i found is Excle UDF is not having the detail to save as PDF... for _ExcelBookSaveAs has the option to save the file as (txt,xls,html,template,csv) so it doesnt have the information to save as PDF. if you can give const value for PDF or if you can explain me how you have declared the values for the variables... so that i can modify the header file and will give a try...

Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font]

Link to comment
Share on other sites

If you have Excel 2007 you can find the exact format of the save method here. The "Save as PDF" add-in has to be installed.

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Thanks a lot water...if i am using Office 2010 in that case how can i check the vaue?

In Excel 2010 you have to use the ExportAsFixedFormat method as well. But as far as I know there is no need for the add-in any more.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

it worked fine Water! Thank you so much... i have one more help..can you help me on this please! I am just trying to insert image to the excel.. for that i am trying to modify the excel UDF by adding new function.. since i don't have much experiance on it again i got strucked.. can u help me on this? below is the link which i am refering..

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pictures.insert(v=office.14).aspx

Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font]

Link to comment
Share on other sites

Please have a look at the extended Excel UDF

There you'll find function_ExcelPictureInsert which does what you need.

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Hi Water,

As per your suggesstion i have downloaded the _ExcelCOM_UDF.AU3 and i have tried. but where the return value shows that picture inserted successfully... but i couldn't see the image on the excel sheet... also i tried whether the function works by assigning the wrong file name of image...even i get the return value as "True". Could you please help me on this?

Local $addsheet = _ExcelSheetAddNew($oExcel, "New Sheet Example")

Local $pict_insert = _ExcelPictureInsert($addsheet, @DesktopDir&"\QA3.jpg", 10, 10, 18, 18, True, True)

If $pict_insert <> @error Then

_FileWriteLog($Excellog,"INFO"&""&">>"&"Excel Add Image Function>>"&"Image has been added to the Sheet successfully")

Else

_FileWriteLog($Excellog,"ERROR"&""&">>"&"Excel Add Image Function>>"&"Function unable to add a Image to the workbook and the occured error is "& @error)

EndIf

;End of add sheet Function

Sleep(5000)

_ExcelBookClose($oExcel)

Sleep(2000)

Edited by Syed23

Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font]

Link to comment
Share on other sites

Hi Syed,

I'm on my Ubunto PC right now so I can't check the return value and error codes of the ExcelCOM_UDF.au3. But I think the following line is wrong:

If $pict_insert <> @error Then

Shouldn't it read:

If @error <> 0 Then Msgbox(0,"Error","Error inserting picture: @error: " & @error & ", @extended: " & @extended)

Edit: Missed the 0 after the compare operator.

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Shouldn't it read:

If @error <> Then Msgbox(0,"Error","Error inserting picture: @error: " & @error & ", @extended: " & @extended)
Or maybe:
If @error Then Msgbox(0,"Error","Error inserting picture: @error: " & @error & ", @extended: " & @extended)
Without the compare operator "<>".

:)

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law
Link to comment
Share on other sites

Hi water,

Did you get a chance to have a look on the _ExcelPictureInsert issue... i am unable to insert the image on excel sheet...any idea? i am using Office 2007 and 2010 machines.

Thank you,Regards,[font="Garamond"][size="4"]K.Syed Ibrahim.[/size][/font]

Link to comment
Share on other sites

Hi Sysed,

just checked my script and noticed that I didn't use the function but coded it myself:

; Insert picture
$oExcel.ActiveSheet.Pictures.Insert(@ScriptDir & "\Logo.jpg" ).Select
$oExcel.Selection.Height = 44.57
$oExcel.Selection.Width = 391.71
$oExcel.Selection.Left = 40
$oExcel.Selection.Top = 25

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

:)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...