excel

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

Solved September 7, 2012

IF formula to compare a date with current date and return result

I'm looking for a formula which allows me to look at a cell and check if it greater than or equal to today's date…

thumb_up 10 trending_up 5

Solved August 31, 2012

I want to create a TOTAL row at the top of my spreadsheet. In this row, each cell should be the SUM of the…

thumb_up 39 trending_up 18

Solved August 15, 2012

I have a .CSV file which I am reading into a C# program. In one of the columns, there is a date, but it…

thumb_up 28 trending_up 5

Solved July 17, 2012

I'm having a problem fromatting cells in an excel sheet. For some reason my code seems to be changing the style of all cells…

thumb_up 14 trending_up 16

Solved June 21, 2012

I have a web project (.NET 4) that needs to access an Excel file, but it ends up with the following error message: Error…

thumb_up 11 trending_up 4

Solved June 6, 2012

I am trying to find a function that will return the number of cells within a given range that have a number in them.…

thumb_up 14 trending_up 5

Solved May 25, 2012

I don't think there is something wrong with the codes. Can you help me? I need help. Thank you! from xlrd import open_workbook wb…

thumb_up 7 trending_up 6

Solved May 11, 2012

I'm looking for a way to convert xlsx files to csv files in linux, i do not want to use PHP/Perl or anything like…

thumb_up 96 trending_up 108

Solved May 2, 2012

Is there a way in C# to switch off macros in excel before loading an excel file. I am loading the excel file using…

thumb_up 8 trending_up 3

Solved May 1, 2012

So I have two columns in excel with column A containing nearly the exact same data as column B. I need a way to…

thumb_up 7 trending_up 7