Solved
November 5, 2010
Freeze excel column with c#
I generate an excel spread-cheat with c# and I want to freeze the first column. This is the code that I use : public…
thumb_up 9
trending_up 3
excel
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
October 8, 2010
Is RExcel useful? or should I look for alternatives
Also, would it be illadvised to use RExcel for corporate work? Also, what are some advantages / disadvantages of using it? How small do…
thumb_up 16
trending_up 8
Solved
October 1, 2010
Fastest way to interface between live (unsaved) Excel data and C# objects
I want to know what the fastest way is of reading and writing data to and from an open Excel workbook to c# objects.…
thumb_up 34
trending_up 26
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
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 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