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
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
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
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
January 2, 2010
How can I copy columns from one sheet to another with VBA in Excel?
I'm trying to write a macro that copies the content of column 1 from sheet 1 to column 2 on sheet 2. This is…
thumb_up 16
trending_up 6
Solved
December 22, 2009
Excel formula – auto sum for the same types
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
How can I get the Range of filtered rows using Excel Interop?
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
December 15, 2009
Moving images between cells in VBA
I have an image in cell (3,1) and would like to move the image into cell (1,1). I have this code: ActiveSheet.Cells(1, 1).Value =…
thumb_up 7
trending_up 8
Solved
November 29, 2009
Excel VBA function returning an array
Can you create an Excel VBA function that returns an array in the same manner as LINEST does, for example? I would to create…
thumb_up 8
trending_up 5