Skip to main content
Solved

XLS to XLSX Conversion

  • December 23, 2022
  • 4 replies
  • 1439 views
A
Forum|alt.badge.img+2

Hi Masterminds,

 

I would appreciate if someone can help me with a most effective/simple way to convert an XLS file to XLSX. I am currently working on a project where I need to download a lot of XLS files from Oracle and later, have to work on it. The problem I am facing is, as soon as this downloaded file opens, I am getting the below warning on Excel and I am able to work if I press YES. But, I can’t do this every time neither via BOT as I am thinking it would be best to convert this file to XLSX right away after downloading it. By doing this, I can avoid this warning message as well.

 

 

I know there is a File conversion package available on Bot store but there is no option on it for this requirement.

 

Thanks in advance. 😀

Best answer by Padmakumar

agatha.christy wrote:

Hi @Padmakumar ,

 

Perfect. In fact, I was planning to use any of the script for same as well. But I am confused which one to try with. If you don’t mind, could you please share the VB Script which you used for the conversion?

 

Thanks in Advance.😀

 

Please find the below script where I passed the file path (ToBeConverted) as parameter to the script. 

 

In the Run function, I specified as shown below. 

 

 

Hope this will help.

View original
Raul Jaimes
1 person likes this
  • Raul Jaimes
    Raul Jaimes
Did this topic help answer your question?

4 replies

Padmakumar
Forum|alt.badge.img+15
  • Padmakumar
  • Flight Specialist | Tier 4
  • 805 replies
  • December 23, 2022

Hi @agatha.christy ,

 

First of all, you can easily achieve this by using any of the inline script like Python or Java.

 

I had this exact same requirement on one of my projects and I used VBScript for the conversion. You can either use an existing VBScript file or can put the script directly in AA and execute the same.

 

Padmakumar
A
V
S
7 people like this
  • A
    agatha.christy
  • V
    vincet.earnest
  • S
    Shilpa_sood
  • A
    Agnus Marium
  • J
    Jenny Khurana
  • J
    JasminJ
  • V
    Vanessa Newton
A
Forum|alt.badge.img+2
  • agatha.christy
  • Author
  • Cadet | Tier 2
  • 9 replies
  • December 23, 2022

Hi @Padmakumar ,

 

Perfect. In fact, I was planning to use any of the script for same as well. But I am confused which one to try with. If you don’t mind, could you please share the VB Script which you used for the conversion?

 

Thanks in Advance.😀

Padmakumar
Forum|alt.badge.img+15
  • Padmakumar
  • Flight Specialist | Tier 4
  • 805 replies
  • Answer
  • December 23, 2022
agatha.christy wrote:

Hi @Padmakumar ,

 

Perfect. In fact, I was planning to use any of the script for same as well. But I am confused which one to try with. If you don’t mind, could you please share the VB Script which you used for the conversion?

 

Thanks in Advance.😀

 

Please find the below script where I passed the file path (ToBeConverted) as parameter to the script. 

 

In the Run function, I specified as shown below. 

 

 

Hope this will help.

Padmakumar
M
C
A
11 people like this
  • M
    MichalTurek
  • C
    ChanduMohammad
  • A
    agatha.christy
  • V
    vincet.earnest
  • S
    Shilpa_sood
  • R
    RenukaM
  • A
    Agnus Marium
  • J
    Jenny Khurana
  • J
    JasminJ
  • V
    Vanessa Newton
  • zaid.chougle
    zaid.chougle
A
Forum|alt.badge.img+2
  • agatha.christy
  • Author
  • Cadet | Tier 2
  • 9 replies
  • December 23, 2022

Hi @Padmakumar ,

 

Thanks a lot for your support. It is working well and saving a lot of my effort and time now. 

😀

Padmakumar
Raul Jaimes
2 people like this
  • Padmakumar
    Padmakumar
  • Raul Jaimes
    Raul Jaimes

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings