excel

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

Solved December 27, 2012

Excel SUMIF between dates

I have column A with date values formatted as mm/dd/yyyy. I am trying to sum the values of column B if A >=DATE(2012,1,1) AND…

thumb_up 29 trending_up 17
Solved December 7, 2012

Range[] instead of get_Range()

http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.get_range.aspx it says to use the Range property instead of get_Range(Object Cell1, Object Cell2).…

thumb_up 5 trending_up 7
Solved November 4, 2012

How can I send an Excel file by email?

I have an excel file (Excel 2003 / xls format) and I want to send it by email with c#. My code send it…

thumb_up 5 trending_up 8
Solved October 31, 2012

Count occurrences of values

I have a column of text values with repeated values. I want to create a new column of unique values (no repeats) and a…

thumb_up 15 trending_up 8
Solved October 30, 2012

Apache-POI sorting rows in excel

I'd like to sort rows in a sheet by one of string column. I tried to achive that using Sheet.shiftRows method, but I cannot…

thumb_up 4 trending_up 8
Solved September 11, 2012

Can an excel cell contain image

I have been able to paste image in excel. but couldn't insert the image into cell. Can I insert an image in excel cell…

thumb_up 6 trending_up 5