|
楼主 |
发表于 2024-1-15 06:58
来自手机
|
显示全部楼层
橒♂蝣 发表于 2024-1-3 17:52
楼主讲讲什么意思呗
B1=
=WEBSERVICE("https://e.anyoupin.cn/eh3/?sql~cli_tb~sht~" & encodeurl(arraytotext(a2:a19) & ";with recursive cnt as (
select rowid 序号,f01,f01 累计,1 grp from sht where RowID=1
union all
select rowid,a.f01,iif((a.f01+cnt.累计)<=9,a.f01+cnt.累计,a.f01),iif((a.f01+cnt.累计)<=9,grp,grp+1) from sht a,cnt where rowid=(cnt.序号+1) limit 100)
select grp,group_concat(f01,'、') from cnt group by grp;"))
cli_tb~sht~{7;8;1;6;2;7;2;2;1;3;1;1;1;4;6;6;8;1};
with recursive cnt as (
select rowid 序号,f01,f01 累计,1 grp from sht where RowID=1
union all
select rowid,a.f01,iif((a.f01+cnt.累计)<=9,a.f01+cnt.累计,a.f01),iif((a.f01+cnt.累计)<=9,grp,grp+1) from sht a,cnt where rowid=(cnt.序号+1) limit 100)
select grp,group_concat(f01,'、') from cnt group by grp;
b2
=textsplit(b1,"□","△")
|
|