Solved
September 21, 2010
Fill non-contiguous blank cells with the value from the cell above the first blank
I have a column like the following: 1 red 2 blue 3 red 4 5 blue 6 7 8 white The blanks refer to…
thumb_up 9
trending_up 5
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
September 9, 2010
I want to sum every 7 rows in a worksheet and put the sum in different column & rows
I have never really used Excel before but this seems like it should be possible. I have an ongoing document where I will be…
thumb_up 12
trending_up 5
Solved
September 8, 2010
VBA inheritance, analog of super
For example I have class A which implements class B ---class A---- implements B public sub B_do() end sub --class B---- public sub do()…
thumb_up 16
trending_up 8
Solved
September 3, 2010
How to save excel workbook using com4j API without being prompted
I'm trying to save a workbook that has been modified automatically. Here is an example: import excel.*; import com4j.Variant; import static com4j.Variant.MISSING; public class…
thumb_up 5
trending_up 5
Solved
August 24, 2010
Best language to parse extremely large Excel 2007 files
My boss has a habit of performing queries on our databases that return tens of thousands of rows and saving them into excel files.…
thumb_up 5
trending_up 6
Solved
August 23, 2010
Return values from the row above to the current row
I am trying to do simple thing: I just need to set some cells to values that are on the previous rows. I have…
thumb_up 41
trending_up 16
Solved
July 29, 2010
Convert from Database / Excel / CSV to YAML data fixtures?
Was wondering if there is an easy to convert structured files into YAML data fixtures for Doctrine / Symfony. I don't see any utility…
thumb_up 8
trending_up 5
Solved
July 22, 2010
How to make correct date format when writing data to Excel
Iam exporting a DataTable to an Excel-file using office interop. The problem is, that Excel does not recognize dates as such, but instead it…
thumb_up 25
trending_up 17
Solved
July 12, 2010
How can I programmatically freeze the top row of an Excel worksheet in Excel 2007 VBA?
I am looking to programmatically freeze the top row of an Excel worksheet from VBA. The end goal is to produce the same effect…
thumb_up 25
trending_up 26
Solved
June 30, 2010
How to Insert Double or Single Quotes
I have a long list of names that I need to have quotes around (it can be double or single quotes) and I have…
thumb_up 21
trending_up 10