If I understand you right, you are trying to open a CSV file with the Excel activity, and the file isn’t separating the columns. You can use a Read CSV, select the delimiter property, then write it to excel from that data.
:NAME?
When you write the formula, are you using the Write Cell? Maybe it has to do with how you are writing the formula to the file. If you could show me a screenshot or .xaml of your code, I can take a look at it.
exponential format
The number will change to exponential format automatically by Excel if the number is too large. To get around this, you will need to either change the size of the column big enough prior to the number being inputted into the cell OR changing the column format to “Number”. This formatting can be automated too, however I’m not 100% sure on how to do that with StudioX… maybe using Send Shortcuts or Type Into (where you use Alt+keycombinations, which let’s you execute Ribbon options).
It’s really just a User-experience problem cause the value is still the real value in the cell.
I’m getting this error too, even while setting the Region separator to “;”
So there are few workarounds possibly. You can change your Region separator to use “,”, and Excel will then use the comma.
Or, you can type the formula in using a TypeInto, something similar to this:
I tested this using a SUM formula and had no issues. I’m wondering if something with the data on the spreadsheet is causing this. But, I’m not really sure what the problem is. If I come across an answer, I’ll let you know.
From my experience, I had the opportunity to participate in a robotization project for credit card reconciliation processes for cooperative clients; in this the clients asked to reconcile the catgos generated in their credit cards Vs the invoicing that the client generated. The challenge was considerable, since on the one hand all the clinetes handled different credit card franchises and the statements or account statements were generated in different formats (PDF, image, consultation by virtual bank branch, etc); and additionally, the amount of administrative resources dedicated to the work demanded a high cycle time that was reflected in the high operational costs that reduced the profit margin of the service offered.
In the end, we managed to reduce the resources dedicated to this process by 70%, implementing RPA solutions that would take on that operational burden.
I have solved the issue regarding the language setting and the writing of the months that do not match the English dropdown menu in the application, in this way:
I deleted from the workflow the activity:
located above the activity <Select Item ‘Month’>
In the file Project_Notebook.xlsx, sheet : I used the following formulas:
The idea is to convert general number from the cell A1 first into a date with the corresponding month in the cell C1; then, in B1 convert in text (in English language, using the code[$-409]) the month from the date located in C1.
Instead of the activity that I deleted, I put the activity 5 seconds. I’m not sure if this activity is necessary.
The tasks are super cool. One issue which i faced is Write Cell is not working when any other separator is used in place of Comma(Example: SUM(E:E) as per the Robot Path Document).It fails with error.
I’m guessing you’ve resolved this by now because I’m about a week behind - but…
If I remove the export_total.xlsx file from my Downloads folder before running the remaining steps that depend on that downloaded file, I will get the same error. Your screenshots do look right - but it seems like it thinks the export.xlsx file doesn’t exist.
I tested this by deleting the file from the Downloads folder and doing a run from the same place you did “Use Excel File”.
Is the file that you are opening definitely in your Downloads folder?
With the time it took to download all of those files, I was relieved when this project ran smoothly.
One thing I did differently from the solution, is that I used the Saved Value for all of the downloaded files (including the monthly vendor invoices), not just for the master file (export_total.xls). I can’t find any difference between using the Saved Value and waiting to specify the value once the Use Excel activity is added. So I’m not sure if I’m missing something, or not, but my project appeared to run smoothly. I ran the Solution file and compared the vendor invoices, e.g., Report-DE763212-1.xlsx and export_total.xlsx with my project’s files, and they had the same exact output.
Something else I noticed is that the template file don’t appear to be used. I can delete the template file, from the project folder, after it has been referenced in the workflow, and the project still runs successfully. So I wonder how are the template files are actually used?
I suspect that the data is actually on “Sheet1”. If that is true, you need to change “Worksheet” to “Sheet1” in your code: I’m talking about both those Write Cell activities and any other write activities.
what happens is the Write Cell will create a new sheet if it doesn’t exist, and that is what happened most likely, which is why the Sum formula was placed on an empty sheet. (the formula should be placed in the sheet with all the data)
“Template files” are not used at runtime, but at design time, to load the options in the “Dropdown” or to “Indicate in Excel”, when the referenced Excel file is not static - it doesn’t exist yet on the disk or you are iterating through a collection of files with an identical structure. This is why you can delete them:
I’m curious. What does your original downloaded vendor worksheet look like (Before your write calculation is run)? Was there ever any data in it? Like this?