Solved
February 6, 2016
Interior.Color Property inverts colors?
I have written a piece of code that allows me to retrieve the shading color of a specific cell inside a sheet of an…
thumb_up 5
trending_up 5
excel
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
October 13, 2015
Convert an Array Formula’s Text Results into a Usable Format
When the results of an Array Formula are numbers, I find it generally easy to find an appropriate method to collapse the array into…
thumb_up 4
trending_up 11
Solved
September 24, 2015
How to group rows/columns in EPPlus
Is there a way to achieve this in EPPlus? Only thing I could find on the internet is grouping specific data for example: AAA…
thumb_up 8
trending_up 4
Solved
September 21, 2015
Mysterious use of LOOKUP
I've been using this Excel formula for years. It works fine, but I want to understand why it works! The formula is used to…
thumb_up 7
trending_up 5
Solved
August 25, 2015
Keep excel cell format as text with “date like” data
This seems silly, but I haven't been able to get my values in the format of #/#### to write as the literal string rather…
thumb_up 11
trending_up 1
Solved
May 13, 2015
How to replicate excel solver in R
I used excel solver to solve an optimization problem, and I am trying to replicate it in R. I found many packages like optim,…
thumb_up 10
trending_up 9
Solved
May 6, 2015
Java – Writing strings to a CSV file
I am trying to write data to a csv file with java, however when I try opening the produced file with excel I am…
thumb_up 14
trending_up 5
Solved
May 6, 2015
Changing Numbers from standard form without clicking every cell- Excel
I have imported a csv file from MySQL, documenting part numbers and descriptions. Some of these part numbers have values like 1234567890987654321, which is…
thumb_up 8
trending_up 6
Solved
January 25, 2015
Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
Many spreadsheets have formulas and formatting that Python tools for reading and writing Excel files cannot faithfully reproduce. That means that any file I…
thumb_up 5
trending_up 10
Solved
December 22, 2014
What is the RGB code for the Conditional Formatting ‘Styles’ in Excel
So this should be an easy one, right? Why can't I find it anywhere on StackOverflow or even on the Internet? :) I've got…
thumb_up 12
trending_up 7