All Excel Solutions on Gang of Coders

Total of 304 Excel Solutions

How can I get this 8 year old VBA 64-bit compiler bug fixed?

Excel Vba Ms Access 64 Bit

Copy every nth line from one sheet to another

Why is there still a row limit in Microsoft Excel?

Excel Row Number Limits

Convert milliseconds to date (in Excel)

Count number of times a date occurs and make a graph out of it

Excel Date Graph Excel 2010 Unique

How to control number of decimal digits in write.table() output?

R Excel Number Formatting Decimal Point Output Formatting

Programmatic Access To Visual Basic Project Is Not Trusted

Vba Excel Programmatically Created

Using Pandas to pd.read_excel() for multiple worksheets of the same workbook

Python Excel Pandas Dataframe Xlsx

How to insert a row between two rows in an existing excel with HSSF (Apache POI)

Java Excel Apache Poi Poi Hssf

How to randomize Excel rows

Create excel ranges using column numbers in vba?

Excel Date Conversion from yyyymmdd to mm/dd/yyyy

Excel Excel 2007 Vba

Excel VBA code to copy a specific string to clipboard

Excel Clipboard Vba

Wait until ActiveWorkbook.RefreshAll finishes - VBA

Adding a newline character within a cell (CSV)

How does one sum only those rows in excel not filtered out?

Excel Excel Formula

xls to csv converter

Python Excel Csv Xls Export to-Csv

Quadratic and cubic regression in Excel

Excel Regression

Remove #N/A in vlookup result

How to get row count in an Excel file using POI library?

Java Excel Apache Poi Poi Hssf

Iterating through populated rows

Write Array to Excel Range

C#Excel Interop

How to "flatten" or "collapse" a 2D Excel table into 1D?

vba: get unique values from array

Vba Algorithm Excel Unique

OleDB & mixed Excel datatypes : missing data

Excel Datatable Dataset Oledb

Concatenating date with a string in Excel

Excel Worksheet Function

How can I generate GUIDs in Excel?

How to Remove Line Break in String

Excel CSV. file with more than 1,048,576 rows of data

Excel Csv Split Max Rows

Python convert csv to xlsx

Python Excel File Csv Xlsx

Export data from R to Excel

AngularJS $http-post - convert binary to excel file and download

Json Excel Angularjs Http Post

SSIS Excel Import Forcing Incorrect Column Type

Sql Server Excel Types Ssis

Create Excel file in Java

Java Excel Jexcelapi

Is there any simple way to convert .xls file to .csv file? (Excel)

How do I get the old value of a changed cell in Excel VBA?

.NET Excel Library that can read/write .xls files

C#Excel Xls Read Write

Microsoft Office Excel cannot access the file 'c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx'

C#Excel Export to-Excel Excel Interop

parsing excel documents with python

Python Excel Parsing

Pass row number as variable in excel sheet

Excel Excel Formula

Excel Automation with Haskell gives a seg fault

Excel Haskell Com Ole

Invalid column count in CSV input on line 1 Error

Php Mysql Excel Csv

Use string value from a cell to access worksheet of same name

Excel Worksheet Function

Convert XLSX to CSV correctly using python

Python Excel Python 2.7 Csv

Sum up a column from a specific row down

Excel Excel Formula

iterate through all rows in specific column openpyxl

Excel Python 2.7 Openpyxl

Using EPPlus with a MemoryStream

How to create a link inside a cell using EPPlus

Returning a regex match in VBA (excel)

Regex Excel Vba

Easiest way to loop through a filtered list with VBA?

Setting filter on headers of an Excel sheet via POI

Excel Apache Poi Autofilter

Getting Excel to refresh data on sheet from within VBA

Case Function Equivalent in Excel

Excel Worksheet Function

Does the VBA "And" operator evaluate the second argument when the first is false?

Excel Vba Operators

Delete Sheets and avoid Excel asking the user to confirm, using custom messages instead

How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries

C#.Net Excel Office Interop

How do I find the last column with data?

Using Excel VBA to run SQL query

Sql Sql Server Vba Excel

Append existing excel sheet with new dataframe using python pandas

Python Excel For Loop Pandas Append

What is a correct MIME type for .docx, .pptx, etc.?

Excel Ms Word Ms Office Powerpoint Mime Types

Loop through files in a folder using VBA?

Check whether a cell contains a substring

Excel Excel Formula

Return empty cell from formula in Excel

Excel Excel Formula

Reading Excel files from C#

C#.Net Excel Ms Office

Pandas: Looking up the list of sheets in an excel file

Python Excel Pandas Openpyxl Xlrd

What is the difference between .text, .value, and .value2?

Excel: last character/string match in a string

Excel Excel Formula

Saving results with headers in SQL Server Management Studio

Sql Sql Server-2008 Excel Ssms Export to-Excel

Excel VBA - exit for loop

Excel Vba For Loop

Microsoft Excel mangles Diacritics in .csv files?

Excel Encoding Csv Diacritics

How to keep one variable constant with other one changing with row in excel

Excel Excel Formula

How to correctly display .csv files within Excel 2013?

Excel Csv Office 2013

How to read and write excel file

Error in finding last used cell in Excel with VBA

Excel Vba Excel Formula

Import and Export Excel - What is the best library?

C#asp.net Excel Export to-Excel Import From-Excel

How do I properly clean up Excel interop objects?

C#Excel Interop Com Interop

Writing to an Excel spreadsheet

Python Excel Csv

How can I perform a reverse string search in Excel without using VBA?

Excel Excel Formula

Best way to do Version Control for MS Excel

Excel Version Control

How to get the path of current worksheet in VBA?

Generating CSV file for Excel, how to have a newline inside a value

Excel Csv Newline

Excel VBA App stops spontaneously with message "Code execution has been halted"

Could pandas use column as index?

Python Excel Pandas

'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

Sql Server Excel Ssis Oledb Aceoledb

Function to convert column number to letter?

Excel Vba Excel Udf

How to save MySQL query output to excel or .txt file?

How can I read numeric strings in Excel cells as string (not numbers)?

Java Excel Apache Poi

How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops

Regex Excel Vba

How to write to an existing excel file without overwriting data (using pandas)?

Python Excel Python 2.7 Pandas

Pandas cannot open an Excel (.xlsx) file

Python Excel Pandas

How can I send an HTTP POST request to a server from Excel using VBA?

Excel Vba Http Post Serverxmlhttp

Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?

Python Excel Pandas Openpyxl

Importing CSV with line breaks in Excel 2007

Excel Csv Newline Excel 2007

How do I declare a global variable in VBA?

Excel Vba Scope Global Variables

How do I put double quotes in a string in vba?

Excel Vba Double Quotes

Which encoding opens CSV files correctly with Excel on both Mac and Windows?

Windows Excel Macos Csv Utf

IF statement: how to leave cell blank if condition is false ("" does not work)

Excel If Statement Excel 2010 Worksheet Function

Excel to CSV with UTF8 encoding

Excel Encoding Csv Utf 8

Insert picture into Excel cell

Excel Excel 2010

Simple Pivot Table to Count Unique Values

Excel Excel Formula Pivot Table

Generate sql insert script from excel worksheet

Test or check if sheet exists

Excel Vba Scripting

Display milliseconds in Excel

Remove leading or trailing spaces in an entire column of data

Excel Excel Formula Excel 2010

How to create CSV Excel file C#?

C#Excel Csv Export

How to avoid using Select in Excel VBA

Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support

Python Excel Python 2.7 Pandas

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server

Sql Server-2008 Excel Oledb

Excel Date to String conversion

Excel Excel Formula

Last non-empty cell in a column

Excel Worksheet Function

Working with time DURATION, not time of day

Stop Excel from automatically converting certain text values to dates

Excel Csv Import

How to export DataTable to Excel

C#Excel Datatable

Apache POI Excel - how to configure columns to be expanded?

Java Excel Expand Apache Poi

Loop through each row of a range in Excel

Excel Vba Loops Excel 2003

Best timestamp format for CSV/Excel?

Excel Formatting Csv Timestamp

Break out of a While...Wend loop

Excel Vba While Loop

How to suppress Update Links warning?

How do I use FileSystemObject in VBA?

Excel Vba Filesystemobject

Freezing Row 1 and Column A at the same time

Excel Excel 2010

How should I escape commas and speech marks in CSV files so they work in Excel?

Java Excel Csv Special Characters

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

Javascript Jquery Html Excel Google Chrome

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

Excel Csv Utf 8

Microsoft Excel ActiveX Controls Disabled?

Excel Vba Activex

Convert XLS to CSV on command line

Windows Excel Csv

Is there a way to crack the password on an Excel VBA Project?

Excel Vba Passwords

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

.Net Excel Aceoledb

Parsing an ISO8601 date/time (including TimeZone) in Excel

Excel Datetime Vba Timezone Iso8601

When should the xlsm or xlsb formats be used?

Excel Excel 2007 Xlsm Xlsb

How to add a custom Ribbon tab using VBA?

Excel Vba Excel 2007 Ribbonx

How to convert a column number (e.g. 127) into an Excel column (e.g. AA)

How to pause for specific amount of time? (Excel/VBA)

Merge cells using EPPlus?

C#asp.net Excel Epplus

What is correct content-type for excel files?

Excel Mime Types

Easy way to export multiple data.frame to multiple Excel worksheets

Using Excel OleDb to get sheet names IN SHEET ORDER

C#Excel Oledb Server Side

What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Excel Vba Excel 2010 Activex Form Control

How to convert Excel date format to proper date in R

R Excel Date Datetime Lubridate

The quest for the Excel custom function tooltip

C#Excel .Net 4.0 Office Interop Decompiling

Leave out quotes when copying from cell

Excel Clipboard

What is the equivalent of "!=" in Excel VBA?

Excel Vba Function Syntax Inequality

Copy/Paste from Excel to a web page

Javascript Html Forms Excel

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

C#.Net Excel File Io

How to create an Excel File with Nodejs?

Excel node.js File Io Export to-Excel Npm

How can I open an Excel file in Python?

How to import an excel file in to a MySQL database

How can I format bytes a cell in Excel as KB, MB, GB etc?

Excel Formatting

How to run a SQL query on an Excel table?

Sql Excel Filtering

Why on earth can't Excel handle 2 files with the same name?

ImportError: No module named win32com.client

Python Excel Win32com

automatically execute an Excel macro on a cell change

Excel Vba Automation

Excel formula to reference 'CELL TO THE LEFT'

Excel Excel 2007 Excel Formula

Get content of a cell given the row and column numbers

Excel Excel Formula

Read an Excel file directly from a R script

How to add a reference programmatically using VBA

Excel Vba Reference

Read all worksheets in an Excel workbook into an R list with data.frames

R Excel Xlconnect

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Java Excel Apache Poi Jxl

Closing Excel Application Process in C# after Data Access

C#Excel Visual Studio-2012 Excel Interop Kill Process

Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

Python Excel Xlrd

What is the difference between dim and set in vba

Reading Datetime value From Excel sheet

C#Excel Office Interop

How to read file using NPOI

C#.Net Excel Npoi

IndexError: too many indices for array

Python Excel Csv Error Handling Indexing

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

Excel Vba Refresh

Check if Cell value exists in Column, and then get the value of the NEXT Cell

Excel CSV - Number cell format

Excel Csv Formatting Number Formatting

Append same text to every cell in a column in Excel

Excel Excel 2007

How do I convert an Excel serial date number to a .NET DateTime?

.Net Excel Datetime

"Can't find Project or Library" for standard VBA functions

Excel Vba Reference Namespaces

Excel date to Unix timestamp

EPPlus number format

C#asp.net .Net Excel Epplus

How to represent a DateTime in Excel

How to turn a string formula into a "real" formula?

Excel String Formula Worksheet Function Evaluate

Check if the file exists using VBA

Optimal way to Read an Excel file (.xls/.xlsx)

C#Excel Oledb Openxml Sdk Excel Interop

Putting many python pandas dataframes to one excel worksheet

Python Excel Pandas Dataframe Xlsxwriter

Missing compiler required member 'microsoft.csharp.runtimebinder.binder.convert'

Save each sheet in a workbook to separate CSV files

Iterate over VBA Dictionaries?

How to read Excel cell having Date with Apache POI?

Java Apache Excel Apache Poi

Parsing XLS and XLSX (MS Excel) files with Ruby?

How to put a tooltip on a user-defined function

Excel Macro : How can I get the timestamp in "yyyy-MM-dd hh:mm:ss" format?

How to merge rows in a column into one cell in excel?

Way to run Excel macros from command line or batch file?

Excel Vba Batch File Command Line

How can I create a progress bar in Excel VBA?

Parsing JSON in Excel VBA

Json Excel Parsing Vba Object

Open Excel file for reading with VBA without display

Excel Vba File Io

Importing a big xlsx file into R?

Get length of array?

Excel Vba Ms Access

Excel interop: _Worksheet or Worksheet?

C#Excel Com Interop

How can I concatenate strings in VBA?

Convert cells(1,1) into "A1" and vice versa

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

How can I URL encode a string in Excel VBA?

Excel Vba Url Encoding Urlencode

Detect whether Excel workbook is already open

Refresh Excel VBA Function Results

Excel Vba User Defined-Functions

How do I get countifs to select all non-blank cells in Excel?

Setting mime type for excel document

Excel Content Type Mime

Excel column number from column name

How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?

C#Excel Dll Interop

Exception from HRESULT: 0x800A03EC Error

C#Excel Exception Interop Add In

Ignore Duplicates and Create New List of Unique Values in Excel

Excel Excel Formula Excel 2010

Paste MS Excel data to SQL Server

Sql Server Excel Copy Paste

Excel Reference To Current Cell

Excel Worksheet Function

Code Golf: Numeric equivalent of an Excel column name

Excel Code Golf

Is there a limit on an Excel worksheet's name length?

How to open an Excel file in C#?

C#.Net Excel Vsto

Getting unique values in Excel by using formulas only

Excel Excel Formula

Can Excel interpret the URLs in my CSV as hyperlinks?

Excel Csv Hyperlink

How to escape comma and double quote at same time for CSV file?

Java Regex Excel Oracle Csv

Merging cells in Excel using Apache POI

Java Android Excel Apache Poi

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

Excel Vba Worksheet

How can I import an Excel file into SQL Server?

Sql Server Excel Csv Import Oledb

Cell color changing in Excel using C#

C#Excel Ms Office

check if a file is open in Python

How do I recognize "#VALUE!" in Excel spreadsheets?

Excel Excel Formula

Export DataTable to Excel with EPPlus

C#Excel Datatable Export Epplus

How to use workbook.saveas with automatic Overwrite

Excel Vba Excel 2010

How to read data from excel file using c#

C#.Net Excel Ms Office

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

How can I use a for each loop on an array?

How can I export GitHub issues to Excel?

Excel Github Github Api Github Enterprise

How to set Column Type when using EPPlus

.Net Excel Epplus

Prevent cell numbers from incrementing in a formula in Excel

Converting unix time into date-time via excel

Excel Datetime Unix Timestamp Date Conversion

What is the algorithm to convert an Excel Column Letter into its Number?

Java POI : How to read Excel cell value and not the formula computing it?

Java Excel Apache Poi Notimplementedexception

Use VBA to Clear Immediate Window?

Excel Vba Immediate Window

How to read data of an Excel file using C#?

Create Excel files from C# without office

C#Excel File Io Office Interop

Multi-threading in VBA

Multithreading Vba Excel

Convert string to int if string is a number

How to change Format of a Cell to Text using VBA

Exporting results of a Mysql query to excel?

Mysql Excel Export

New Line Issue when copying data from SQL Server 2012 to Excel

Sql Sql Server-2008 Excel Copy Paste Sql Server-2012

How can I export Excel files using JavaScript?

Javascript Excel

How to detect installed version of MS-Office?

C#Excel .Net 3.5 Ms Office

How to get current working directory using vba?

Setting Column width in Apache POI

Excel Apache Poi

How to use the Implements in Excel VBA

Excel Vba Interface

Is there a coalesce-like function in Excel?

Sql Excel Xls Coalesce

Using a UDF in Excel to update the worksheet

Creating an Array from a Range in VBA

Arrays Excel Vba Range

Substring in excel

Excel String Excel Formula Substring

Text was truncated or one or more characters had no match in the target code page When importing from Excel file

Sql Server-2008 Excel Ssis Codepages Import From-Excel

excel plot against a date time x series

DateTime fields from SQL Server display incorrectly in Excel

Excel Sql Server-2008-R2

Excel: the Incredible Shrinking and Expanding Controls

Excel Vba Excel 2010 Excel 2007 Excel 2003

How to clear the entire array?

Arrays Excel Vba

Is it possible to write Excel VBA Code in Visual Studio

Vba Visual Studio Excel

Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn't?

How can I find last row that contains data in a specific column?

How to check for empty array in vba macro

Import Excel spreadsheet columns into SQL Server database

Sql Server Excel Sql Server-2008 Import Etl

What charset does Microsoft Excel use when saving files?

Excel Encoding Character Encoding

How to activate a specific worksheet in Excel?

Obtaining the equivalent to printf or String.Format in Excel

Using "If cell contains #N/A" as a formula condition.

Excel Excel Formula

How to create strings containing double quotes in Excel formulas?

Excel Excel Formula

Protecting cells in Excel but allow these to be modified by VBA script

Excel Interop - Efficiency and performance

C#Excel Performance Interop Vsto

Generating random numbers with normal distribution in Excel

Excel Random Normal Distribution

Convert xlsx to csv in Linux with command line

Linux Excel Csv Converter Xlsx

How to create a GUID in Excel?

Excel: Scalar product of two ranges

Excel Formula Scalar

How to continue the code on the next line in VBA

getting sheet names from openpyxl

Python Excel Openpyxl

Removing the password from a VBA project

Vba Security Excel Password Protection

Declaring variables in Excel Cells

Excel Excel Formula

How do I read a date in Excel format in Python?

Python Excel Datetime

Excel add one hour

Excel Excel 2003

Read/Parse text file line by line in VBA

How can I color dots in a xy scatterplot according to column value?

Vba Excel Charts Excel Formula

Running an Excel macro via Python?

Python Excel Vba Python 2.7

How to write some data to excel file(.xlsx)

C#asp.net Excel

Find the differences between 2 Excel worksheets?

How to view the XML form of an Excel file?

Use of symbol # (hash) in VBA Macro

What are .NumberFormat Options In Excel VBA?

be careful parts of your document may include personal information that cannot be removed by the Document Inspector

Sql Server Excel Excel 2013 Powerpivot

Determining the full type of a variable

What does the Excel range.Rows property really do?

Vba Excel Ole Automation

Convert xlsx file to csv using batch

Excel Csv Batch File Xlsx

How to read single Excel cell value

How do I iterate through rows in an excel table using epplus?

Java - Writing strings to a CSV file

Java Excel Csv Export to-Csv

Levenshtein Distance in VBA

Vba Excel Levenshtein Distance

Excel cell from which a Function is called

Properly Handling Errors in VBA (Excel)

DataRow: Select cell value by a given column name

C#.Net Excel Datarow

"Out of Memory Error (Java)" when using R and XLConnect package

How to obtain sheet names from XLS files without loading the whole file?

Python Excel Pandas Xlrd

How to reference Microsoft.Office.Interop.Excel dll?

C#Excel Reference Visual Studio-2012 Vsto

Excel formula to get cell color

Excel Worksheet Function

Shortcut to Apply a Formula to an Entire Column in Excel

Excel Excel Formula

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

Loop through each cell in a range of cells when given a Range object

How to add a button programmatically in VBA next to some sheet cell data?

Excel Vba Button

How to return a result from a VBA function

Excel Vba Function Return Return Value

Return Index of an Element in an Array Excel VBA

Arrays Excel Vba Indexing Find

Excel function to make SQL-like queries on worksheet data?

Sql Excel Vba Function

Export to xls using angularjs

Javascript Excel Angularjs Xls

Parse XLSX with Node and create json

Javascript Json node.js Excel Xlsx