使用biee的过程中,我们经常需要将报表、仪表盘页、整个仪表盘等导出为excel。
一、报表【url传参并下载excel】
1.1通过url方式
官方文档中,提供了url传参并下载report报表的方法,示例为
saw.dll?Go&Path=%2fshared%2fSAT%20Regional%2fRegional%20Reports%20with%20guided%20navigation%2fRegion1_AMR&Action=Download&format=excel2007
&col1=%22Dim_Program_D%22.%22PROGRAM%22&val1=%22O_K5B%2B%22+%22O_K60B%22
&col2=%22Dim_Geo_D%22.%22COUNTRY_NAME%22&val2=%22Brazil%22+%22Canada%22+%22USA%22
&col3=%22Dim_Channel_D%22.%22CHANNEL%22&val3=%22RSLR%22
&col4=%22Dim_Geo_D%22.%22GEO%22&val4=%22AMR%22
&col5=%22Dim_PLAN_VERSION_D%22.%22Plan%20Version%22&val5=%22Current%20Plan%22
大概语法为
saw.dll?Go&Path=<报表路径>&Action=Download&