excel
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 分类:问答.dat file how to create one based on excel document
I have a .csv file in my matlab folder with 38 columns and about 48 thousand entries. I was hoping on using the findcluster gui but it only accepts .dat files.[详细]
2023-04-12 04:04 分类:问答How to deserialize Excel file to 2-dimensional array?
I have an Excel wor开发者_Python百科ksheet where all the fields are strings. I would like to de-serialize all the data from the excel file to a 2D array (matrix).[详细]
2023-04-12 03:46 分类:问答