Top "Excel" questions

Add leading zeroes/0's to existing Excel values to certain length

There are many, many questions and quality answers on SO regarding how to prevent leading zeroes from getting stripped when …

excel padding

Sum function in VBA

I have a problem with summing cells in vba. I need to use Cells(a,b): Range("A1").function="=SUM(…

excel vba sum cells

How do I express "if value is not empty" in the VBA language?

How do I express the condition "if value is not empty" in the VBA language? Is it something like this? "…

excel vba

Swap x and y axis without manually swapping values

So I have a set of data that has conditional formatting. Basically it's a set of photometric measurements of stars …

excel charts excel-2010 axes

Get content of a cell given the row and column numbers

I want to get the content of a cell given its row and column number. The row and column number …

excel excel-formula

What is correct content-type for excel files?

I want excel files on a website to open in Excel when clicked, not get saved on desktop, or get …

excel mime-types

Refreshing all the pivot tables in my excel workbook with a macro

I have a workbook with 20 different pivot tables. Is there any easy way to find all the pivot tables and …

excel vba refresh

Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser

I have a HTML table in velocity template. I want to export the html table data to excel using either …

javascript jquery html excel google-chrome

How to create strings containing double quotes in Excel formulas?

How can I construct the following string in an Excel formula: Maurice "The Rocket" Richard If I'm using single quotes, …

excel excel-formula

Is it possible to force Excel recognize UTF-8 CSV files automatically?

I'm developing a part of an application that's responsible for exporting some data into CSV files. The application always uses …

excel csv utf-8