Solved
November 21, 2009
Forcing Garbage Collection
Is there a way to force garbage collection in VBA/Excel 2000? This question refers to the Macro language in Excel. Not using VB .NET…
thumb_up 9
trending_up 4
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
November 16, 2009
Which is better open source for Excel file parsing in Java?
Which is better API for excel parsing in Java Apache POI or JExcel API? In terms of speed, memory utilization and code stability.
thumb_up 7
trending_up 3
Solved
November 9, 2009
Building Excel Files with C#
I need to create an excel file via C#. I have read a few places that creating an XML document is the easiest way…
thumb_up 7
trending_up 6
Solved
October 29, 2009
How do I import a COM object namespace/enumeration in Python?
I'm relatively new to programming/python, so I'd appreciate any help I can get. I want to save an excel file as a specific format…
thumb_up 8
trending_up 7
Solved
October 28, 2009
C# or Python for my app
I have the task of developing an application to pull data from remote REST services and generating Excel reports. This application will be used…
thumb_up 12
trending_up 3
Solved
October 20, 2009
Excel 2007 UDF: how to add function description, argument help?
The description I am writing a couple of Excel UDFs in COM Servers. I'd like to get the standard help (Insert Function dialog) that…
thumb_up 11
trending_up 9
Solved
October 12, 2009
How to fall through a Select Case in Excel VBA?
Given Select Case cmd case "ONE": MsgBox "one" case "TWO": MsgBox "two" case "THREE": MsgBox "three" End select My requirement is if cmd =…
thumb_up 12
trending_up 6
Solved
October 7, 2009
Excel VBA “Autofill Method of Range Class Failed”
The following VBA code (Excel 2007) is failing with Error 1004, "Autofill Method of Range Class Failed.". Can anyone tell me how to fix…
thumb_up 16
trending_up 6
Solved
October 6, 2009
How can I write to an Excel spreadsheet using Linq?
I'm writing an app where I need to retrieve some rows from a DB and dump them into an Excel spreadsheet. I'm using Linq…
thumb_up 16
trending_up 8
Solved
September 28, 2009
API to write huge excel files using java
I am looking to write to an excel (.xls MS Excel 2003 format) file programatically using Java. The excel output files may contain ~200,000…
thumb_up 7
trending_up 13