Hi. I am an absolute newbie.
I have n(unknown) number of .xlsx files in a folder. I am able to access the folder, and then serially read each file, and then close the file.
What I want to do is store each file in a data table (as is normal) and then store the data table in an array of data tables using Array of [T]-> System.DataTable. The variable is created. I would appreciate a link to all functions of the Array Variable, because in assignment, I am as of now unable to assign the data table to an element of the array.
Link…
I am not sure which all functions are available for the operations on an array. I thought I needed a list of functions for the array, but as you advised, a list of DataTable would be better, I am now trying to search a list of all the functions that can be used to manipulate or operate on such a list.
I did not get that in the documentations, so I wanted a reference to it if possible.
Yes. I have multiple excel files stored in a single folder, and I have to perform web-based operations on data within the excel sheet.
I can read the excel sheet one by one.
I can also read the data required.
The problem is that I want to put into a state machine structure, such that each of the excel files will be read in one go and stored in individual data tables. Since I don’t know the number of files in the folder, I have done the following:
Now I have a list of the names, but not the data in the files themselves.
So I want to store the data table generated from the read range into an array/list as advised by @marci080. I was trying this:
With the state machine situation, I have divided the input into states such that I first get a list of files. Then I want to read all the excel files into individual data tables and store all the data tables in an array/list. Then in the next, each data table is read and operation is performed.
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Previously, using only sequences I was able to get the data onto the website from each file as follows:
With the state machine situation, I have divided the input into states such that I first get a list of files. Then I read and store all the data tables in an array/list. Then in the next, each data table is read and operation is performed.
That’s where I am stuck actually.
StoreExcel currently (before I posted here; haven’t made any changes yet), is of the type System.Data.DataTable. In each element of this, I want to save my data table generated by the Read Range operation on each excel file.
For a normal data table I can use .Rows(), or .Items(). But those functions don’t exist for System.Data.DataTable, or so it seems according to the error messages I was getting. So I wanted to know which functions could be used, and where I can get a list of these functions because I didn’t get them in the UiPath Docs.
On the RHS of the Assign Block, I have the output of the Read Range just before the For Each Block.
I don’t know what exactly to put in LHS. StoreExcel.SomeFunctionToAccessIndividualCellsOrElements().
Sorry to spam, and thanks for the replies @pattyricarte
StoreExcel currently (before I posted here; haven’t made any changes yet), is of the type System.Data.DataTable. In each element of this, I want to save my data table generated by the Read Range operation on each excel file.
I think the For Each loop for StoreExcel is unnecessary.
As per my understanding, @Rpa_U9p1t8 just wants to save the datatables to the StoreExcel array.
If so,
Change the StoreExcel type to List (Of Datatable)
Initialize it to New List (Of Datatable)
Then replace the said ForEach loop with AddToCollection
I have performed the steps as you said. As of now there are no errors. Thanks.
I think this might be it, but once I am able to successfully iterate through each of the stored data tables in the next state, I will mark it as the solution, if that is alright.
So I wanted to know which functions could be used, and where I can get a list of these functions because I didn’t get them in the UiPath Docs.
Just to answer this also. Since UiPath uses the .NET Framework,
you could actually refer to the microsoft docs for those methods,properties,etc.
Also in UiPath Studio, if you type the period (“.”) beside the variable name, the available properties and methods are also displayed.
Sample usage of the microsoft docs.
I noticed that you still have the Path.GetExtension(CustFile) = ".xlsx" checking.
You could define this as the searchPattern (ie. “*.xlsx”) when you performed the Directory.GetFiles() as indicated in the link above.
with the variables:
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu