hi , i am trying to get file contents of desired excel worksheet from excel file and i want to create a new excel file using collected file content in another location ( sharepoint library).
i am able to get the desired excel worksheet id and name. from there i would like to retrieve the file contents but i am not able to find any option to retrieve.
P.S : i cannot use excel get rows function since my data is not in table format and i could not run scrip to make a table since it will destroy design requirements and formulas.
