Output Data in Specific Cells of CSV File

Hello

I'm trying to get some data into different cells of a csv file like this -

[Output Path] + "|||INVTNAV_" + [New Date] + "$A2:A"

[Output Path] + "|||INVTNAV_" + [New Date] + "$F2:L"

I have used blob in and blob out tool to get template.

The output is coming out empty i.e. only the template is getting printed and not the data I have added as mentioned above

Anybody know what can be done for this?

I think the error lies with the sheet name formation [Output Path] + "|||INVTNAV_" + [New Date] + "$A2:A"

Output

Accepted answers

Raj

@saachitalwar
find the workflow attached.
just add the csv in input

3291.yxmd

All comments

alexnajm

I don't think you can output to a range for .csv files - I just tried a quick sample on my side and it didn't work. Have you had success doing that before?

Raj

@saachitalwar
you can do this to .xlsx file not a CSV file.

saachitalwar

I thought so. I have done with method with xlsx before but not csv

Raj

@saachitalwar
blob works for CSV as it is just performing Copy and paste but the capability to write in specific range is not available with CSV files
First convert your CSV to .xlsx and this will work.
hope this helps
mark done if solved