excel
Any sample on how to expose a olap cube as oData so it can be used using powerpivot?
I\'m looking for a sample on开发者_如何转开发 how to expose an olap cube as an odata feed so it can be consumed by powerpivot. I do not want to provide direct access to the cube.[详细]
2023-04-12 11:57 分类：问答SimpleXML adding childs and attributes for excel
I\'n really new to this and my question should be simple. Lets say i have this xml: <?xml version=\"1.0\"?>[详细]
2023-04-12 11:54 分类：问答Method 'Range' of object '_Global' failed. error
I\'m trying to get Excel to figure out which columns of a worksheet are blank. Eventually the idea is to get it to delete the completely blank columns.[详细]
2023-04-12 11:22 分类：问答How to remove blank rows when using Excel VBA Autofilter
I have written a macro that searches through workbook and applies an autofilter to any listobjects which have a column named \"Code\". However, when I apply the filter, it does not filter out the blan[详细]
2023-04-12 09:49 分类：问答Why is this happening while writing an Excel in Java
Ok, basically i\'m trying to write 3 columns and N number of rows simultaneously while iterating. The problem is that 2 of the 3 columns are written with the values... even though they appear in the S[详细]
2023-04-12 09:33 分类：问答Reverse a 1d array output from a function (or get the last value), without VBA?
Suppose I have a UDF MyFunc() which is too costly to call more than once, MyFunc() returns an array.By default, if applied to a single cell then the first value in the arr开发者_StackOverflow社区ay is[详细]
2023-04-12 09:28 分类：问答Text values in a pivot table?
I have a table (in MySQL) with 3 columns: LocationCategorySupplier AComputersCompany X APrintersCompany Y[详细]
2023-04-12 08:58 分类：问答.net XSLT to create worksheets
I am trying to export a lot of data to excel. I need a possibility to separate the data between different wor开发者_如何学运维ksheets.[详细]
2023-04-12 06:40 分类：问答Copy Legend of Chart to Powerpoint with VBA
I work on an excel script that creates powerpoint slides. On a powerpoint slide, I want to show the legend of a chart, but not the rest of the chart.[详细]
2023-04-12 05:49 分类：问答Are there any coding standards for VBA within Excel?
Especially, I\'d like to know when it is appropriate to output one or other of the standard error codes (viz#N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! and #NUM!) in response to bad i开发者_如何学Go[详细]
2023-04-12 04:33 分类：问答
加载中,请稍侯......