Convert Excel Format

Yes,planning on releasing Windows support soon. ~ETA is Sept. 2023.

What I can think of right now is running  a Office repair and trying again. (This shoudl be your first step before trying anything else)

The activity uses Office Interop API to convert the exact way you would get the result if you used the dropdown list manually so there shoudl not be a problem if manual commands are working fine. 

I am guessing some properties like sheet name, or the resulting excel file name etc might not be correctly passed (but basic validations are taken care of by the custom activity code itself) 

Here are some more steps:

- Try running office repair tool or reinstall it for good measure (if not done arleady)

- Make sure the registry (user/machine/system) has the definition for temporary path (The activity first copies the file to a temporary location to not corrupt the original file, only if the conversion/export is successful then it copies the file over to your desired location)

- Make sure you are not asking the activity to do somethign that does not exist (For Example :    See format compatibility and backward compatibility as well, - meaning, your xls to xlsx should not have something that has Excel 4.0 cell based macro/code which is not compatible without registry settings in xlsx or latest office versions)

- Some server side office automation issues are listed here - see whether anything applies - https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2 (Unless of course the user is currently using their own machine, this wont apply)

Finally a very well written answer I would suggest go through it (https://stackoverflow.com/questions/891394/excel-error-hresult-0x800a03ec-while-trying-to-get-range-with-cells-name)

Hi Shivam, can you please elaborate as to what you are trying to do EXACTLY?

- Have you tested whether you are able to save xls as xlsx manually in the user's machine?

- Has the user installed any COM plugins that are not loading?

- Has the user installed a licensed Office (if yes then which is the office version?)

- Are you trying to convert .xlsx and related files and the default APP for those are not configured as 'Excel' application? (Solution : Go to Control Panel > Programs > Default Programs and setting Microsoft Office Excel 2016 as default program for xlsx files)

- Is the file stored on a Network location? If not, is it being synced by any backup programs continuously? (OneDrive, Box etc)

lemme know

Hi Yery Yury, please post your queries in English :)

Hi Erik, Yes it does. Please see activity UI dropdown in studio :)

I hope this is resolved as the activity name was being searched which is similar to another that is in the Japanese/Kanji/Chinese/Asian script

Hey pardon the delay in response @carsten, I will look towards building a separate activity to configure multiple delimiters for a CSV parsing logic.

Hi Shreeja,

There are a lot of things that result in 'Call was rejected by a callee' error while running scripts/using Interop Excel.

Can you confirm the following things: If one or more of your answers are 'yes' to the following then most probably that is the root cause of your issue

1. Is there Excel Application installation issue/liceense allocation issue/ installation incomplete?

2. Are you trying to Refresh Pivot data? (Settings will look like this in this case : Refresh data when opening the file - disabling this might solve the issue)

3. Are you running a script/custom component once the excel loads/opens? (Add-ins, plugins)

4. Any major Windows update pending on your machine?

5. Does the excel file have links to files that cannot be linked?

6. Any message box/excel popups when opening excel/that specific file?

7. Are you trying to convert .xlsx and related files and the default APP for those are not configured as 'Excel' application? (Solution : Go to Control Panel > Programs > Default Programs and setting Microsoft Office Excel 2016 as default program for xlsx files)

8. Are the excel sheets hidden or strong hidden or locked for editing (any restrictions for that matter)?

9. Is that file being simultaneously accessed by some other process with edits to that sheet? Is the sheet name correctly passed?

Please follow up on the above and let me know if the issues still persist.

Regards