Saving group to excel file
Posted: Wed Oct 04, 2023 10:16 am
Im trying to save a group to an excel file inside of a loop. programmatically, it is not allowing me to save to a file at all. my inner loop looks something like this:
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!
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
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!