DataTable variable to an excel using filename

Help StudioX
,
1

Hello - I did a read range to extract the data in the same cell of each file in a folder. I now want to go into an existing excel file (one file/sheet) that has all of the exact filenames (in column C)of those files and write that DT extracted data in the cell next to it (D). I’m having trouble figuring out how write the data to the excel - any ideas?

2

Hi,

If I understand your requirement correctly, the following sample will help you.

image
image1046×1586 48.8 KB

Sample
Sample20240927-1.zip (29.7 KB)

Regards,

3

Hello @audra.swope

Could you please clarify.
Would you like to have the entire datatable inside one cell with all column headers and data?

Regards
Soren

4

Thank you, Yoichi! Would you let me know what the formula/code is within this value box?
image

5

Hi,

Can you open and run the attached sample in my previous post?

The expression is as the following.
image

Regards,

6

Hi Yoichi - thank you. I used your suggestion and it is populating the first row of the “monthly inventory” file repeatedly with each files data instead of populating each row with the applicable files data. Any idea why? Here is my sequence:

This image depicts a Multifaceted workflow process for handling and processing data from multiple Excel files, including setting and using variable values, iterating through rows, and conducting conditional checks, designed within an automation software interface. (Captioned by AI)
This image depicts a Multifaceted workflow process for handling and processing data from multiple Excel files, including setting and using variable values, iterating through rows, and conducting conditional checks, designed within an automation software interface. (Captioned by AI)562×1191 53.3 KB

7

Hi,

To isolate cause, can you try to insert LogMessage activity to display read value at the following point?

image
image650×855 78 KB

If there is no log, it may be necessary to review condition of IF activity.

Regards,

8

Thank you all. Here is the final product using a little bit of all of your suggestions:

The image depicts an Excel automation workflow in a software tool, performing operations such as reading and writing data to and from Excel files within a loop. (Captioned by AI)
The image depicts an Excel automation workflow in a software tool, performing operations such as reading and writing data to and from Excel files within a loop. (Captioned by AI)442×636 29.6 KB

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.