Output Data in Specific Cells of CSV File

[saachitalwar]

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"

[saachitalwar]

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"

[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

[Mathias_Nielsen]

Guess you could always write to a xlsx and then convert the file to csv after if you need it in that format?

[saachitalwar]

can I convert a file from xlsx to csv within that workflow?

[Raj]

@saachitalwar 
yes you can with blob tools.

[Raj · Accepted solution]

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

[Mathias_Nielsen]

Yes, you can. Just take input the file and write it as something different