excel

167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

Solved January 16, 2010

are there any good unit testing packages for excel

are there any good frameworks that can help unit test code in excel ?

thumb_up 5 trending_up 7

Solved December 22, 2009

I need a quick an simple excel formula to get the sum of values for different types of objects as listed below: Type1 10…

thumb_up 8 trending_up 6

Solved December 16, 2009

I'm using Excel Interop assemblies for my project, if I want to use auto filter with then thats possible using…

thumb_up 8 trending_up 5

Solved November 16, 2009

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

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

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

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

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 6, 2009

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

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