Solved
June 24, 2010
POI Auto Filter
How do I use Apache POI to pre-define an auto-filter region in an Excel 2007 document? A small code example or link would be…
thumb_up 14
trending_up 9
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
June 24, 2010
`IF` statement with 3 possible answers each based on 3 different ranges
I have 3 ranges of numbers and the answer depends on the range. 75-79=0.255 80-84=0.327 85+ =0.559 I tried to create an equation that…
thumb_up 7
trending_up 4
Solved
June 22, 2010
Fastest way to write cells to Excel with Office Interop?
I am writing a function to export data to Excel using the Office Interop in VB .NET. I am currently writing the cells directly…
thumb_up 24
trending_up 11
Solved
June 18, 2010
Function to Compare Two Cells and Return the Smaller in Excel
I'd think there'd be something to do this in Excel, because it seems so basic... BUT: I have two cells and I need to…
thumb_up 11
trending_up 2
Solved
June 14, 2010
How to Lock the data in a cell in excel using vba
I want to stop others from editing the cell contents in my excel sheet using VBA. Is it possible to do this?
thumb_up 18
trending_up 9
Solved
June 10, 2010
How to clear the entire array?
I have an array like this: Dim aFirstArray() As Variant How do I clear the entire array? What about a collection?
thumb_up 58
trending_up 29
Solved
June 4, 2010
Excel – Combine multiple columns into one column
I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one…
thumb_up 11
trending_up 5
Solved
June 1, 2010
Get start range and end range of a vertically merged cell with Excel using VBA
I need to find out the first cell and the last cell of a vertically merged cell.. Let's say I merge Cells B2 down…
thumb_up 11
trending_up 7
Solved
May 25, 2010
Is there a C# library that will perform the Excel NORMINV function?
I'm running some Monte Carlo simulations and making extensive use of the Excel function NORM.INV using Office Interrop. This functions takes three arguments (probability,…
thumb_up 7
trending_up 9
Solved
May 20, 2010
C++ library to load Excel (.xls) files
I'm looking for a free C++ library that can load .xls files in both Windows and Linux. If I had to make a choice,…
thumb_up 11
trending_up 6