Robotic Process Automation

  • 1.  Error trying to convert an Excel to HTML

    Posted Wed September 29, 2021 02:40 PM
    I'm traying to convert an Excel file:

    defVar --name Excel_HTML --type Excel
    excelOpen --file "C:\\Users\\Alex Virrueta\\Documents\\TipoCambioDolar\\TCDolar.xlsx" Excel_HTML=value
    excelSaveAs --filename "${Excel_HTML}" --fileformat "xlHTML" --closeaftersave

    Error:
    9/29/2021 1:37:51 PM - Error executing command at line 3: excelSaveAs --filename "${Excel_HTML}" --fileformat "xlHTML" --closeaftersave
    Operation unavailable (Exception from HRESULT: 0x800401E3 (MK_E_UNAVAILABLE))

    If there any way t convert an Excel file to PDF, image or HTML

    ------------------------------
    Alex Virrueta
    ------------------------------


  • 2.  RE: Error trying to convert an Excel to HTML

    Posted Thu September 30, 2021 06:12 AM
    Edited by NIGEL CROWTHER Thu September 30, 2021 06:13 AM
    Hi Alex,

    This seems to be a bug.  I cannot get the ExcelSaveAs to work with any format.  I will log a defect.  To work around this, you could use RPA commands to take control of the Excel window and select the file->save as dialog.  

    Thanks!

    ------------------------------
    NIGEL CROWTHER
    ------------------------------



  • 3.  RE: Error trying to convert an Excel to HTML

    Posted Fri October 01, 2021 10:25 AM
    Thanks Nigel

    ------------------------------
    Alex Virrueta
    ------------------------------



  • 4.  RE: Error trying to convert an Excel to HTML

    Posted Fri October 01, 2021 04:28 PM
    Thanks Nigel

    I used the Save As command and was able to save the file to PDF.

    ------------------------------
    Alex Virrueta
    ------------------------------