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.
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.