Hi gil.Silva,
Amazing, that's going to solve my problem, thank you very much really.
In some cases (for example line 3 of the values in the exported text, only the last 2 columns have values., being the others in blank. I don't think regex values can achieve this is there anyway to extract...
Hi everyone,
I've been trying for a several time to extract specific values from a text file and put in into a collection, so i can work with the data. Next i show how is my text file is received:
-This text has always de same structure.
-I don't need the header at the begging of each page...
Hi, there was a filter already applied on the sheet. Tried it with a new sheet and works perfectly fine.
Thank you very much for your help! It was very useful.
Still getting the same message error "Autofilter method of range class failed" with exactly the same code i posted before. The header is ok, is the first row in the Excel.
Could be the reason the Excel version? Otherwise i don'´t know why it works fine for you.
Thank you very much for the attention, I've been making the necesarry changes that you have mentioned . But i get an error message in the output data item which says : "Autofilter method of Range Class Failed". I tried to pass an specific range such ass (D10:D200000), but still does not work...
Hi sivagelli, thanks for your quick response the excel sheet contains about 200.000 rows, in consequence i get an SystemOutofMemory error.
to Apply a filter and the passing it to a collection could work too but since for my needs no additional transformation in the excel is needed, only the...
I have an Excel workbook where is needed to remove all rows wherever appears a 0 value in a certain column before adding it into a collection (see attached picture as an example: When column D contains 0 value, that row must be deleted).
I tried these actions with MS EXCEL VBO 1.Get Cell value...
Hi VJ,
That was! , I don't know how I couldn't see it earlier. You were right about the cell formatting in Column N. Now i have the csv file without the last comma.
Thank you very much for your quick response and everything I appreciated it a lot.
-YG.
Hi VJR, your solution works perfectly fine.
The only thing, when I transform my excel to xlCSV format (as I show in next picture). The last line ends with a comma. Is there anyway to avoid the last comma? or remove it using blueprism but without importing the excel file as a collection and...
Hi Raimundasv,
I get the same error "A generic error occurred in GDI+.", but i cannot see the problem with the action stage and path... Maybe mine is different, but.. could you please illuminate me?
Thank you very much, y
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.