Gang Of Coders
Home
About Us
Contact Us
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
Excel
Why is there still a row limit in Microsoft Excel?
Excel
Row Number
Limits
Convert milliseconds to date (in Excel)
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
Excel
Random
Create excel ranges using column numbers in vba?
Excel
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
Vba
Excel
Adding a newline character within a cell (CSV)
Excel
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
Excel
Vlookup
How to get row count in an Excel file using POI library?
Java
Excel
Apache Poi
Poi Hssf
Iterating through populated rows
Excel
Vba
Write Array to Excel Range
C#
Excel
Interop
How to "flatten" or "collapse" a 2D Excel table into 1D?
Vba
Excel
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?
Vba
Excel
Guid
How to Remove Line Break in String
Excel
Vba
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
R
Excel
R Faq
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)
C#
Excel
Csv
How do I get the old value of a changed cell in Excel VBA?
Vba
Excel
.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
C#
Excel
Epplus
How to create a link inside a cell using EPPlus
C#
Excel
Epplus
Returning a regex match in VBA (excel)
Regex
Excel
Vba
Easiest way to loop through a filtered list with VBA?
Excel
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
Vba
Excel
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
Vba
Excel
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?
Excel
Vba
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?
Excel
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
Vba
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
Java
Excel
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?
Excel
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"
Excel
Vba
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?
Mysql
Excel
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
Sql
Excel
Test or check if sheet exists
Excel
Vba
Scripting
Display milliseconds in Excel
Excel
Vba
Time
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
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
Excel
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?
Excel
Vba
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)
C#
Excel
How to pause for specific amount of time? (Excel/VBA)
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
R
Excel
Xlsx
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?
Python
Excel
How to import an excel file in to a MySQL database
Mysql
Excel
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?
Excel
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
Excel
R
R Faq
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
Excel
Vba
Vb6
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
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
Excel
EPPlus number format
C#
asp.net
.Net
Excel
Epplus
How to represent a DateTime in Excel
Excel
Datetime
How to turn a string formula into a "real" formula?
Excel
String
Formula
Worksheet Function
Evaluate
Check if the file exists using VBA
Excel
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'
C#
Excel
Save each sheet in a workbook to separate CSV files
Excel
Vba
Csv
Iterate over VBA Dictionaries?
Excel
Vba
How to read Excel cell having Date with Apache POI?
Java
Apache
Excel
Apache Poi
Parsing XLS and XLSX (MS Excel) files with Ruby?
Ruby
Excel
How to put a tooltip on a user-defined function
Excel
Vba
Excel Macro : How can I get the timestamp in "yyyy-MM-dd hh:mm:ss" format?
Excel
Vba
How to merge rows in a column into one cell in excel?
Excel
Vba
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?
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?
R
Excel
Xlsx
Get length of array?
Excel
Vba
Ms Access
Excel interop: _Worksheet or Worksheet?
C#
Excel
Com
Interop
How can I concatenate strings in VBA?
Excel
Vba
Convert cells(1,1) into "A1" and vice versa
Excel
Vba
Cell
Excel: How to check if a cell is empty with VBA?
Excel
Vba
How can I URL encode a string in Excel VBA?
Excel
Vba
Url
Encoding
Urlencode
Detect whether Excel workbook is already open
Excel
Vba
Refresh Excel VBA Function Results
Excel
Vba
User Defined-Functions
How do I get countifs to select all non-blank cells in Excel?
Excel
Setting mime type for excel document
Excel
Content Type
Mime
Excel column number from column name
Vba
Excel
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?
Excel
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
Python
Excel
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?
Excel
Vba
How can I use a for each loop on an array?
Excel
Vba
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
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?
C#
Excel
Math
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#?
C#
Excel
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
Excel
Vba
How to change Format of a Cell to Text using VBA
Excel
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?
Excel
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
Excel
Vba
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
Excel
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?
Excel
Vba
How can I find last row that contains data in a specific column?
Excel
Vba
How to check for empty array in vba macro
Vba
Excel
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?
Excel
Vba
Obtaining the equivalent to printf or String.Format in Excel
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
Vba
Excel
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
Guid
Excel: Scalar product of two ranges
Excel
Formula
Scalar
How to continue the code on the next line in VBA
Vba
Excel
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
Excel
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?
Excel
How to view the XML form of an Excel file?
Xml
Excel
Use of symbol # (hash) in VBA Macro
Vba
Excel
What are .NumberFormat Options In Excel VBA?
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
Vba
Excel
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
C#
Excel
How do I iterate through rows in an excel table using epplus?
C#
Excel
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
Excel
Vba
Cell
Properly Handling Errors in VBA (Excel)
Excel
Vba
DataRow: Select cell value by a given column name
C#
.Net
Excel
Datarow
"Out of Memory Error (Java)" when using R and XLConnect package
Excel
R
Memory
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
Excel
Padding
Loop through each cell in a range of cells when given a Range object
Excel
Vba
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