Code: Select all
import(mode=o) my_file.xlsx range=Sheet1 colhead=1 na="#N/A" @id @date(ds) @smpl @all
group g *
for !i=1 to g.@count
%name = g.@seriesname(!i)
series {%name}_new = {%name}*100
next
group g_new *_new
wfsave (type=excelxml) B:\test_file.xlsx @keep g_new
i get the error:
Unable to open file C:\(type=excelxml).wf1.
My workfile is not even located in my C drive...
i have tried using the pagesave function as well but to no avail. i can save manually through the drop downs, but that doesnt work for my use case.
any help is greatly appreciated!