Top "Excel" questions

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

Insert picture into Excel cell

I'm tying to generate a report with pictures, but I cannot get the pictures into a single cell. I can …

excel excel-2010
Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to …

excel excel-2007
What is a correct mime type for docx, pptx etc?

For older *.doc documents this was enough: header("Content-Type: application/msword"); What mime type should I use for new docx …

excel ms-word ms-office powerpoint mime-types
Loop through files in a folder using VBA?

I would like to loop through the files of a directory using vba in Excel 2010. In the loop, I will …

excel vba
Check whether a cell contains a substring

Is there an in-built function to check if a cell contains a given character/substring? It would mean you can …

excel excel-formula
How to add a named sheet at the end of all Excel sheets?

I am trying to add an Excel sheet named "Temp" at the end of all existing sheets, but this code …

excel vba worksheet
Convert string to int if string is a number

I need to convert a string, obtained from excel, in VBA to an interger. To do so I'm using CInt() …

excel vba
Writing to an Excel spreadsheet

I am new to Python. I need to write some data from my program to a spreadsheet. I've searched online …

python excel csv
Excel: How to check if a cell is empty with VBA?

Via VBA how can I check if a cell is empty from another with specific information? For example: If A:…

excel vba
Excel compare two columns and highlight when found

I have an excel file with 10,000 rows in column A some values are the same. Example: A1 - P7767 A2 …

excel excel-formula