Examples of programming questions in excel

Opening csv files in MicroSoft Excel on a mac
How to sort by dates excel?
how to detect paste event in excel
Delete blanks from start and end of a string in vba
Insert a Checkbox into every cell and assign it to that cell
How does Excel's worksheet password protection work
Deleting all the data series in a dynamic chart
Formula in Excel to count occurrences of substrings within strings
Change Background Color for Entire Sheet
How to Save/Overwrite existing Excel file with Excel Interop - C#
Save Excel range as pdf
How to copy a sheet between Excel workbooks in Java
Apache POI, creating new cells overrides the row style
Excel VBA for selecting an entire column starting from a specific cell
Find something in column A then show the value of B for that row in Excel 2010
Turn Off Filters
VBA Cut and Paste error
VBA-excel paste chart as a picture
Excel VLOOKUP gives wrong value
How to get the column index of the current cell?
Excel User Defined Function: change the cell's color
Excel VBA: Type mismatch when passing array
VBA code showing error 2042 for reason unsure
How can i get the Column letters of a cell (need to make it work past the Z column such as AA,AB)
How to get values from template fields in GridView?
Let property of VBA class modules - is it possible to have multiple arguments?
Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
Count number of cells in a range that match the content of a different cell
Error when calling subroutines "Expected Variable or Procedure, not Module.
Get Cell by a Cell reference letter identifier with Apache POI
Running an Excel Macro via C#: Run a macro from one workbook on another?
Formatting Excel cells (currency)
How to express cell id using string letter and current row number in an Excel formula?
VBA for clear value in specific range of cell and protected cell from being wash away formula
VBA have a sub run another sub
DevExpress export GridView to Excel
Excel with VB.NET (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
How to select XML child node using its baseName instead of Item(#)?
MS Excel adds line break when copying a cell
Ignoring Time Value from DateTime cells - MS Excel
C# Autofit method for excel sheet
VBA Excel, mismatch for inputbox as integer
Cannot execute macro in Break Mode
Excel Macro - Take a snapshot of Particular Range
Date for Previous Monday Excel
How to write data to an existing excel using apache poi
Looping through Multi-selected Listbox values to create and name workbook
How to export table from heroku production database locally to excel from console using Ruby?
Reading data from excel 2010 using Microsoft.Office.Interop.Excel
VBA:Trigger macro on column filter
What is the difference between Sheets.Select and Sheets.Activate?
Filter table in excel VBA based on a column of values
Django: openpyxl saving workbook as attachment
How to convert the actual excel formula (not the result) to a text string
Does NPOI have support to .xlsx format?
Compare cell contents against string in Excel
Add x number of days to a date with vba in excel
delete excel worksheets programmatically
How to read an excel file in go?
How to make Excel VBA variables available to multiple macros?
Select column 1 to 10 of ActiveCell row in Excel
How to check which line of VBA code is causing errors
Excel.Worksheet.Cells[row,col] = "=Formula" vs. Range.set_Value(Missing.Value, arrayFormulas)
Excel: Conditional formatting for clusters of values
Read pixel colors of an image
c#: programmatically create a "named range" in worksheet scope
How to change fontsize in excel using python
When to use TextFrame or TextFrame2 in VBA
Split large Excel/Csv file to multiple files on PHP or Javascript
Why is Excel VBA rounding my integer division results?
Cannot insert object" error when adding ActiveX control like Microsoft DataGrid to Excel sheet
VBA Stop calculation of cells
How to find and replace part of a cell with formatted text
How to set calculation mode to manual when opening an excel file?
Lookup using table with separated columns
export data from excel to sqlite database
How to use NPOI to read Excel spreadsheet that contains empty cells?
How to reduce a huge excel file
PHP export CSV when data having UTF8 charcters
Organizing data read from Excel to Pandas DataFrame
Simple excel find and replace for formulas
Refer to QueryTable objects by name
How to specify all columns as "Text" in Text to Columns function in Data tab?
What is the difference between = and =+ in Excel
How to write a VBA collection to an Excel sheet
Generate CSV for Excel via JavaScript with Unicode Characters
XLWT multiple styles
What do excel xml cell attribute values mean?
Convert time-formatted column in excel to C# DateTime
Formula to find the last " \ " in a filepath and remove all after that
Cell showing Date but not Time
Remove all VBA modules from excel file?
Extracting the top 5 maximum values in excel
Copy format from one row to another using c#
Count unique values in a column in Excel
Return Excel downloadable file from Spring
How to optimize vlookup for high search count ? (alternatives to VLOOKUP)
Dictionary in VBA is created with empty key value pair
Convert large CSV files to JSON
Ending a macro within a called subroutine
Using VLOOKUP()
SSIS Convert string to a guid when importing and saving data
Get values from union of non-contiguous ranges into array with VBA with a simple command (no loops)
Is there any way to read both .xls and .xlsx files using Apache POI?
Excel VBA: How to obtain a reference to a Shape from the ChartObject
Symmetric expressions in excel matrix
How to use the Implements in Excel VBA
When is it appropriate to explicitly use Err.Clear?
Trying to sort excel range by two columns using c#
Get item in VBA Collection by Name
How to write a cell with multiple columns in xlwt?
How to open a file from an archive in vba without unzipping the archive
How to force VBA editor to enter break mode whenever code is called?
File selector, How do i specify filetype?
Closing Excel application with Excel Interop without save message
How to disable changes in a cell using vba?
Input past end of file VBA excel
sep=";" statement breaks utf8 BOM in CSV file which is generated by XSL
How to count cells in a range with a value less than another cell in excel?
How to remove the character "*" in Excel 2010?
Define function that can take null parameter
EPPlus autofilter only working on last cell
Setting a part of the cell contents to Underline using Apache POI?
Unable to lookup a date using vba vlookup
Apache POI - setting left/right print margin in Excel
Java Library to read Microsoft Excel files
SQL run from Excel cannot use a temporary table
Using SQL to query an Excel worksheet without a header row
xssf How to get anything as String
Cannot convert type 'double' to 'string' for Excel values
Can I/How do I show a webpage in an excel form?
Conditional Formatting percent incorrect Excel
Using a InStr function within a Select Case
Excel 2010 VBA Error 1004 with formula
Number stored as text warning in excel using POI
Google Spreadsheet COUNTIF TODAY()?
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries
Excel process still runs in background
What to use instead of deprecated CellRangeAddress.valueOf in ApachePOI
Excel VBA - How do I clear the clipboard on another workbook in another application?
RANDBETWEEN(1,11) but not 6?
Porting SHA-256 library to Excel
Excel: Scalar product of two ranges
VBA Userforms. Textbox as number value to cell
multi-sheet import with oledb netting "_xlnm#_FilterDatabase" as sheet names
Open a CSV file in Excel via C#?
how to change Excel column width
Turn Off Msg for Update Links for Excel Spreadsheet upon Opening
find last match in column using built in functions in excel
Append & prepend string to existing rows
Using a UDF in Excel to update the worksheet
How to remove warning in Excel using apache poi in JAVA?
XLRD/Python: Reading Excel file into dict with for-loops
Export data in CSV, Excel, PDF format in AngularJS
How to put in the thousands separator in xlsx using xlsxwriter module?
How to set the filename when downloading a file?
Export SQL table in CSV With Headers
Symfony return a response to export excel
Excel / VBA: auto-adjust column width after pasting data
Referencing Excel Userform Control Name Value From String (VBA)
How do I read csv with large numbers (probably scientific notation) in R?
Excel Sum If Year Equals
How do I click a link on a web page using Excel VBA?
Get the values of multiple checkboxes in django
Fully reference a worksheet by codename
Write list of lists to excel file using xlwt
Using pandas Combining/merging 2 different Excel files/sheets
How to append or combine Ranges?
How to make Win32::OLE work on 64bit MS OFFICE installation
Deep Copy or Clone an ADODB recordset in VBA
Excel VBA looping through multiple worksheets
Laravel Excel , exporting from a model, styling issues
Excel issue "excel 4.0 function stored in defined names
Error when trying to read an .xls file using EPPlus
How can I copy a formula down a column into every 3rd row?
VBA Save as PDF with Filename as Cell Value
excel match value(get row) in two-dimensional array
Formula for computing total amount per day
Define Excel's column width with R
Splitting String With LastIndexOf() in VBA
SUMPRODUCT vs SUMIFS
Is there a max number items while generating drop down list in Excel using Apache POI?
Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
Ambiguous class resolution in laravel phpexcel update
Excel 2013 VBA clear active filter
Splitting String in VBA using RegEx
Creating a "color scale" using vba (avoiding conditional formatting)
Worksheet_Activate not triggering when workbook opened
Excel VBA Run-time error 1004 when inserting or value formula into cell
Create Excel file with style tag using OpenXmlWriter SAX
JAVA Apache POI Excel: add borders to cell range
Multithreading in Apache POI Workbook
VBA: Acrobat Run time error 429; ActiveX component can't create object
Autofit Method of Range Class Failed (Run Time Error 1004)
VBA Complicated Getter, Setter syntax
Conditional Formatting entire worksheet with case sensitive text
If statement for detecting autofilter, even when nothing has been filtered
How to delete rows in an Excel ListObject based on criteria using VBA?
Add List Validation to Column except the first two rows
if not instr" doesn't work as i thought it should in vba
Is there a faster CountIF
Writing pandas DataFrame to Excel with different formats for different columns
Create excel graph with epplus
Android open XLSX file
NoClassDefFoundError: UnsupportedFileFormatException while working with excel sheet using java
AVERAGEIF(range, criteria) formula that ignores errors in the data
openpyxl Page Setup "Fit To" vs "Adjust To
When reading .xlsx file using POI I got an error "Zip File is closed
Apache POI getRow() returns null and .createRow fails
Slow VBA macro writing in cells
Removing duplicate rows after checking all columns
VB Macros for Office 2016 for Mac require Permissions every time they try to access a file! Is there any way to get around this behavior?
C# NPOI Excel tool does not remove the row?
Excel - Close/Save using full path name
IFERROR, INDEX, MATCH returning zeros instead of blanks
What does "=EMBED("Forms.CheckBox.1","")" do for checkboxes?
Bold and Italics not working in excel with EPPLUS
Declare a Workbook as a Global variable
Separate octets of IP address using formulas
R openxlsx package. writing NA as blanks?
Excel VBA - Pause code execution
Updating existing Excel file in Java Apache POI
How do I get the (X,Y) coordinate of my cursor on a worksheet?
Read excel file with formulas in cells into R
Count ALL Cells in Range in Excel
Excel formula to check and see if a column is in ascending order
Controlling IE11 "Do you want to Open/Save" dialogue window buttons in VBA
Excel COUNTIF cell contains a given text (partial match)
Adding a specific autofilter on a column
Combining 2D (2-dimensional) arrays
Reading very large (more than 100MB) Excel files in PHP
Excel files with byte order mark for UTF-8 causing errors
Convert Rich Text to HTML formatting tags
Should I turn .CutCopyMode back on before exiting my sub procedure?
VBA: Passing multiple values to Instr
Count number of pieces data is split to by a certain delimiter
Is there any difference between numpy.std and excel STDEV function?
Python CSV write to file unreadable in Excel (Chinese characters)
is a CSV with equal sign valid?
Extracting raw data from a PowerPivot model using Python
Call Excel Add-In function in macro
VBA - Copy first three characters from string into another cell
Excel - How do I create a cumulative sum column within a group?
How can I get around Excel's URL Limitation?
How to show print dialog box and print preview on same screen?
pandas Combine Excel Spreadsheets
Dynamically changes ribbon's button label Excel
Rename Excel Sheet with VBA Macro
OpenXML - Cell.DateType is null
How do you create a string literal in excel?