Contents tagged with Excel

Convert an Excel Column Name into Index
public static string GetExcelColumnName(int columnNumber) { int dividend = columnNumber; string columnName = string.Empty; int modulo; while (dividend > 0) { modulo = … more

How to verify multiple Excel columns are equal
Let’s say we want to compare columns A, B, C and D in row one. The corresponding formula would be:=IF(A1=B1=C1=D1, "Y","N")Unfortunately this will not work. Here’s how this formula should evaluate:= … more

How to create an Excel Spreadsheet with charts
References:How to: Insert text into a cell in a spreadsheet document (Open XML SDK)How to: Merge two adjacent cells in a spreadsheet document (Open XML SDK)How to: Insert a chart into a spreadsheet … more

Resize Excel Table
I’m going to show you how you can resize an existing Excel table. Let’s assume you have the following table in excel (A1:C6): And you want to resize the table to a table like … more