Share
ReportMy troubles is about modifying the excel file, not e-mailing or handling the files.
The excel files follow the same structure but content changes:
- there is always only one sheet (name varies)
- the list of data I need to work with is in the range A7:P100 (but is not defined as a list / table)
example:
I need to get the value from C8 and update some C-row cells, depending on the content of C8,
then on to Row 9 and so on.
Basically a simple task, get at specific cell value, and update another in excel files send to me.
It seam that the excel actions can not handle references to cells, but only tables and rows, this calls for major workarounds, because se is no tables defined in the files.
I have tried:
- saving the file to sharepoint
- creating a table in the range A7:P100
- get rows
- update row
This works fine when working with the one and same file.
The tricky point comes when I start to automate the process and working with different files. The "update row" action does not work with dynamic data. The columns to update can not be pre-defined, they can only be selected in "live" look-up in the actual file to modify.
So I am looking for another solution, API to the SharePoint or working with the file content as "raw data" somehow.
By the way, I want to avoid the desktop version if possible.
please let me know if you have any ideas 🙂
All responses (
Answers (
10,508
