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
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
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
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
Solved
March 23, 2010
How to disable Excel’s auto recognition of numbers and text
I used Python to generate a CSV file. But when I open it in Excel, Excel will auto recognize a string into a number…
thumb_up 4
trending_up 8
Solved
March 22, 2010
Obtaining Excel worksheet reference by worksheet name via C#
I'm currently obtaining a handle to a Excel worksheet by using the below C# code: *Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(15);//Get the worksheet…
thumb_up 17
trending_up 7
Solved
February 9, 2010
Create Excel Charts in Java
I've been using Apache POI to create and modify Excel spreadsheets, but I'm wondering if there is a way (even if it's with a…
thumb_up 5
trending_up 15
Solved
February 3, 2010
How do we set the position of an Excel chart from C#?
I am trying to generate an Excel chart from C#. Chart is generated just find but it allways appears at the center of the…
thumb_up 7
trending_up 5