Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Posts tagged excel

Use for questions about programming with Microsoft Excel. It should be combined with tags for VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, or similar.

This tag doesn't have a detailed wiki yet.

50%
+0 −0
Q&A How to change the color of a cell to a user defined value while keeping its existing style using NPOI from F#?

The answer provided in the How to set the cell color to a user defined value using NPOI from F#? thread solves the problem of how to set the right properties using F#, but it uses a new ICellStyle ...

1 answer  ·  posted 2mo ago by toraritte‭  ·  last activity 2mo ago by toraritte‭

Question f# excel NPOI
60%
+1 −0
Q&A How to set the cell color to a user defined value using NPOI from F#?

As far as I can tell (from F# at least), cell can only be colored using predefined NPOI.SS.UserModel.IndexedColors. From the available methods / properties, val it: ICellStyle = NPOI.XSSF.UserM...

1 answer  ·  posted 2mo ago by toraritte‭  ·  last activity 2mo ago by toraritte‭

Question f# excel NPOI
66%
+2 −0
Q&A How to programmatically evaluate Excel data validations using .NET?

What I would like to do: Set a cell value. Check with a program if cell values conform to data validation rules. I could extract all the information needed to create a validation function, b...

1 answer  ·  posted 3mo ago by toraritte‭  ·  last activity 3mo ago by toraritte‭

Question c# f# excel
66%
+2 −0
Q&A Which .NET project can programmatically validate a cell's value out of the box based on Excel data validation constraints?

Are any of the popular Excel .NET projects have a functionality similar to Apache POI's DataValidationEvaluator class?

1 answer  ·  posted 3mo ago by toraritte‭  ·  edited 3mo ago by toraritte‭

Question c# f# excel Open-XML-SDK
60%
+1 −0
Q&A Drop-down values in Excel cells are not specified in Data Validation rules and global search didn't find them in workbook, so where do they come from?

On top of values seemingly coming from nowhere in multiple columns, they also affect each other's behavior: In the GIF below, if the cells in the left column have no value selected, then there is n...

1 answer  ·  posted 3mo ago by toraritte‭  ·  edited 3mo ago by toraritte‭

77%
+5 −0
Q&A How to create and manipulate (read/write) Excel (XLSX) documents with complex rules using general programming languages?

Our organization (blindness non-profit in California) is obligated to submit reports to grant organizations (e.g., Department of Rehabilitation) on a regular basis. Most of the time, this means exp...

1 answer  ·  posted 4mo ago by toraritte‭  ·  last activity 4mo ago by toraritte‭

Question excel xlsx
50%
+1 −1
Q&A Count the number of occurrences in a text string

If I have some text in a cell, how can I find the number of times another piece of text appears in it? For example, suppose A1 contains Peter Piper picked a peck of pickled peppers.. pick occurs 2...

2 answers  ·  posted 3y ago by pnuts‭  ·  last activity 8mo ago by Dirk Herrmann‭

66%
+4 −1
Q&A Combine the first character of a cell with another cell

A Q on Stack Exchange from a very long time ago included: I have first names in one column and second names in another, I want to create a third column that contains the first character from the...

1 answer  ·  posted 3y ago by pnuts‭  ·  edited 8mo ago by ArtOfCode‭

80%
+6 −0
Q&A Multiple string concatenation in Excel

In Excel I would like to concatenate several strings into one. I could type and fill in the blanks CONCATENATE(A1, A2, ....) but it is a lot of work This would be cool, but it does not work CONCATE...

2 answers  ·  posted 3y ago by James Jenkins‭  ·  last activity 3y ago by Alexei‭

50%
+0 −0
Q&A Merge a pair of columns where in each row one is blank, without a formula

A Q on Stack Overflow asks how to merge two columns where each row has only one populated cell. The example was from (on the left) to (on the right): a|b a 0| ...

0 answers  ·  posted 3y ago by pnuts‭  ·  last activity 3y ago by pnuts‭

Question excel merge
16%
+0 −8
Q&A Delete specific cells with shift cells up

Answers to Excel - Get only values from column that are not Zero “0” asked by @CiscoNewb includes ones applying AGGREGATE: =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12>0),ROW(A1)))...

0 answers  ·  posted 3y ago by pnuts‭  ·  edited 3y ago by luap42‭

Question excel delete