24 questions from the last 7 days
Best practices
3
votes
12
replies
188
views
SpellNumber Simplified Using LAMBDA() function
Here is the custom function to spell number to words using LAMBDA(). I would appreciate any improvement of the function or simplification if possible. Also suggest best practice for the function.
=...
- 38k
-3
votes
0
answers
36
views
MS Excel Web Add-in - Rollout via MS 365 Admin Center
We have developed a ReactJS based Excel Web Add-in, which we are rolling out using the Microsoft 365 Admin Center. The steps that have worked for our Admin Center, as per our IT department (Office 365 ...
- 107
3
votes
1
answer
67
views
Trying to populate a list from another sheet by a single reference number
I am working on a handy reference sheet for my DnD Games, that includes 10 pre-planned encounters of varying difficulty that I want to reference on an Initiative Sheet by referencing the Encounter ...
1
vote
1
answer
89
views
Pandas converts Excel strings like ‘2004E205’ to scientific notation — how to prevent this
How can I handle string values that contain patterns like xxxE205 (e.g., 2004E205), which are used as unique codes in my company? I explicitly read the column as a string in pandas, but values ...
- 11
Best practices
0
votes
4
replies
100
views
Best way to extract a VBA Date out of a byte array and turn it back into a valid VBA Date?
I have confirmed that the following VBA code works just fine.
Dim mydate As Date
mydate = Date
Open "C:\Windows\Temp\dlctest.data" For Binary Access Write As #1
Put #1, , mydate
Close #1
...
- 153
Advice
0
votes
8
replies
127
views
Excel conditional formatting: how to format entire RELATIVE columns based on single row value
My question is quite straightforward - or at least, it should be!
I have an Excel sheet with dates and weekdays laid out across the top three rows. I want to highlight all columns in a particular ...
- 1,516
-2
votes
0
answers
63
views
Is it possible to exit a nested ForEach Loop Used to propagate through excel worksheets? [closed]
I have a For Each Loop container which loops through files in a folder. Inside that container, there is another dynamic For Each Loop container that loops through the worksheets inside the file ...
- 17
1
vote
2
answers
76
views
How to check if two cells in the same column contain matching text in Excel?
Is there an Excel formula that can detect whether two cells in the same column contain similar or partially matching text?
For example:
F3 contains: "regulation BI, how to stop exploitation"...
Advice
0
votes
1
replies
116
views
I want to prevent fill and drag in Excel
I want a VBA code to prevent fill and drag in an Excel sheet without hiding the fill and drag cruiser. and without preventing them from advanced settings.
In addition, I want this code to be localized ...
0
votes
0
answers
72
views
Importing data: VBA run-time error 1004 Application-defined or object-defined error
I am trying to import a table from one workbook to another, but I want to add to the table with each import to the next empty cell (i.e. don't want to over-write existing data in the target workbook). ...
Tooling
1
vote
3
replies
92
views
Convert complex pdf to an excel
I'm currently searching for a solution to read a pdf and convert it to an excel.
For now I found the "tabula-py" library, which seems to be good. But I'm not quite sure because the pdf has ...
0
votes
0
answers
18
views
Aspose.Cells (.NET) (25.5.0): Error Logging
I was wondering is there a way to configure error logging for Aspose.Cells (.NET). The version I am using is, 25.5.0.
I am facing one issue with an excel workbook that has more than 10 excel sheets ...
- 1