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"
Solved! Go to Solution.
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?
@saachitalwar
you can do this to .xlsx file not a CSV file.
I thought so. I have done with method with xlsx before but not csv
@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
Guess you could always write to a xlsx and then convert the file to csv after if you need it in that format?
can I convert a file from xlsx to csv within that workflow?
@saachitalwar
yes you can with blob tools.
@saachitalwar
find the workflow attached.
just add the csv in input