Question
Reading each cell of an excel one by one
Hi All,
Can anyone please help me how to read each excel cell one by one and also copying data from different excel file to different sheet of one excel file.
Also how to connect sql server, run a query and fetch output data in a excel file.
Thanks.
Hi,
I can give you high level procedure for achieving requirement,
1. Use Connect file rule : this will read each cell value and keeps the same into a page list.
2. Use activity and RDB method to initiate connect rule to achieve what you need
Hi,
What is a connect file rule? Can you please explain the process in brief.
I have used export data and extracted proxy of the result, then used two for loop to iterate through rows & column, but in this process in the last step when i used get item(index), as get item(string) is not available it throws error because index is int32 type and the data are string.
I have seen some where, people uses get column letter, which converts index into string and pull the correct data from cells.
Thanks
I found a way to connect to sql and fetched the data in excel file after running the query, also i am also able to get the data from different workbook to different sheet of one workbook, but still not able to read each cell of an excel file one by one.