{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 干净又极端 的问题《Dynamically Update Xcelsius Dashboard from Excel D》','https://www.manongdao.com/q-1126274.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I am designing an Xcelsius dashboard that will need to be updated once a week with data that only exists in an Excel Pivot table. I have been able to create dynamic dashboards in the past by tying the dashboard to an XML file or database. I am looking for suggestion on how to dynamically read an Excel File from and Xcelsius dashboard.
相关问题
- Excel sunburst chart: Some labels missing
- Error handling only works once
- Excel formula in VBA code
- Excel VBA run time error 450 from referencing a ra
- DoCmd.TransferSpreadsheet is not recognizing works
相关文章
- Get column data by Column name and sheet name
- programmatically excel cells to be auto fit width
- Unregister a XLL in Excel (VBA)
- How to prevent excel from truncating numbers in a
- numeric up down control in vba
- Declare a Range relative to the Active Cell with V
- What's the easiest way to create an Excel tabl
- How to create a hyperlink to a different Excel she
Actually your best bet is to save the Excel file as XML and read it back using the XML features via Xcelsius and Excel. If you need some help there are a number of videos that can walk you through the process at both MyXcelsius and Datapig Technologies.
Try Centigon Solutions CSV Connector.
You can make a macro in the Excel File that automatically creates the xml file an saves it in the path where the Xcelsisus File reads it from. You will have to program it once and never worry for it again, and its reausable for every dashboard you make.