Top "Excel" questions

Only for questions on programming against Excel objects or files, or complex formula development.

How to read data from excel file using c#

My application needs to read data from an excel file. I am using .Net and c# for development. I cannot …

c# .net excel ms-office
Check if value exists in column in VBA

I have a column of numbers of over 500 rows. I need to use VBA to check if variable X matches …

excel vba matching
Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right …

excel charts excel-2011
Excel formula to get cell color

I would like to know if we can find out the Color of the CELL with the help of any …

excel worksheet-function
Excel VBA Run-time error '13' Type mismatch

I created a macro for a file and first it was working fine, but today I've been opening and restarting …

excel excel-2010 vba
Break out of a While...Wend loop

I am using a While...Wend loop of VBA. Dim count as Integer While True count=count+1 If count = 10 Then …

excel vba while-loop
How to correctly display .csv files within Excel 2013?

It seems Excel 2013 doesn't read CSV files correctly (Excel 2010 does). Every time I open .csv files, all my data are …

excel csv office-2013
Read Excel File in Python

I've an Excel File Arm_id DSPName DSPCode HubCode PinCode PPTL 1 JaVAS 01 AGR 282001 1,2 2 JaVAS 01 AGR 282002 3,4 3 JaVAS 01 AGR 282003 5,6 I want to …

python excel xlrd
Last non-empty cell in a column

Does anyone know the formula to find the value of the last non-empty cell in a column, in Microsoft Excel?

excel worksheet-function
Declaring variables in Excel Cells

Is it possible to declare variables in Excel cells and use them as parameters for formulas in other cells? For …

excel excel-formula