You’re offline. This is a read only version of the page.
My 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 🙂
You will need to create an Excel script to automatically create the tables in your Excel file. I recently uploaded a video tutorial to YouTube which covers how you can Create Excel Tables for Your Entire Workbook no matter how many sheets you have.
The same concept will apply for you. You can easily get the script to output a value from a specific cell as well. I'm not an expert at writing Excel scripts however you can probably get ChatGPT to come up with something for you that would suit your needs.
Hope this helps!
| If I helped you solve your problem—please mark my post as a solution ✅. Consider giving me a 👍 if you liked my response! |
Share
Report
All responses (
Answers (
10,149
