Excel changes not saving

Help StudioX
,
1

For some reason, every automation I do using excel files is not saving the changes in the files after the execution is done. The rest of the automation works just fine, I can see each step working as they should, but when I open the file it is like nothing has been done.

The “save changes” options is checked and the “read-only” option is unchecked, so I’ve no idea why this is happening

2

@olwrrb is it file containing pivot table? Or it is simple excel file.

3

Hi,

If you use not Excel activity such as Write Cell etc. but UiAutomation : Click, Keyboard shortcut etc, auto save won’t work. Please explicitly save workbook or use Excel activity like Write Cell at the end of the scope.

Regards,

4

simple file

5

I’m only using excel activities, no other automations like click or shortcuts

6

@olwrrb can you show us exact activities and their properties which you are using to save file.

7

Hi,

Does this occur in Studio or Assistant? If latter and try to modify xlsx file via relative path, file which exists under c:\users\[username]\.nuget\packages\[packagename]\[version]\lib\net461 (or net6.0-windows7.0) will modified.
Can you try to check the above path and/or use absolute path?

Regards,

8

This has happen to me before, but this is the most recent project. Right now I’m doing the “Excel Automation With StudioX” course, the empty values are the ones where the input would be the column inserted by the first activity, but it doesn’t save.

I could save it manually to finish the automation, but I want to fix the issue.

Main
Main1048×2262 150 KB

9

image
image828×410 23.3 KB

I’m a new user, so it just lets me put one image per post

10

Hi @olwrrb ,

Possible to share your workflow so I can check? Thanks.

Kind regards,
Kenneth

11

Use at before closing scope at the end save excel activity this will resolve your problem

12

Hi @olwrrb,

  • Verify that the changes are actually being made in the Excel file. You can use the “Write Line” activity to print the values of variables or cells to the Output panel, or use the “Message Box” activity to display them on the screen, to check that the changes are being made correctly.
  • Ensure that the “Save” activity is included in the automation flow and that it is being executed correctly. Make sure that all the required parameters are being set correctly, such as the file path, file format, and overwrite option.
13

Hello Oliwer,

From this screenshot it shows you are telling the bot what to write but have not told it where to write. If you look at the red alerts you can see that there are errors. In the vlookup you have not defined the range.

Best,
Heather

14

https://drive.google.com/drive/folders/1NBIs-IUSDmvWe4rHoBCWqXnICTGKXsVd?usp=sharing

Here is the zipped project folder. I tried changing the path and adding a “save excel file” but it still didn’t work

15

Hi @olwrrb ,

I tried accessing the link you shared but it was empty.

Kind regards,
Kenneth