I have a function that aims to return the visible cells (as a range) after applying an autofilter to an inactive worksheet; the autofilter data is represented b
I am trying to export excel using SheetJS/xlsx and want to format cell. I am using following code and excel is generating but can't format a cell. Can any one p
I need to clone exists rows to the work sheet dynamically. ex. I wanna copy row 28, 29 and insert into 30, 31, or 32,33, or more maybe, it depends on the data r
Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En
Hi all for my first question! I am using ClosedXML (great solution to go to Excel) and everything seems to work as prescribed with the exception of making/forma
Is there a way to tell if some dynamic array, for example arr() as String is initialized? IsEmpty and IsNothing seems not to work with dynamic arrays. Currently
I know this is a topic that is talks about a lot, but I just cant find the answer. I have a range. if in that range there is a word then I need it to go to the
Here is the column entry for A1:A24 0,092 0,045 0,015 0,046 0,041 0,027 0,073 0,004 0,020 #N/A 0,000 0,001 0,004 0,000 0,032 0,000 0,002 0,140 0,005 0,001 0,251
Ultimately I would like to generate ML.NET code that can be consumed by Excel. I would generally assume that creating a DLL would be the most appropriate way.
My workbook consists of 2 sheets: Sheet1 is the primary dashboard that the user sees, while Sheet2 consists of a pivot table and regular table. I'd like to imp
Disclaimer: I am a beginner-level, self-taught casual 'programmer' with Python. Background: I have a script that takes Groupings of data from an .xlsx Workbook
I have the below code for one of my financial reports and I'm struggling with updating the code to make it more automated. The code creates a string of the colu
I have a big function with lots of branches of IFS; each branch uses different references of the worksheet: MYFUN = LAMBDA(i, IFS( i = 1, // a formu
I was working on an Excel document and I used the key combination Alt+h+w to wrap a text paragraph, but for my surprise that makes disappear all my sheets and c
I work in Finance and I'm pretty new to Python. I'd like to make a loop with openpyxl which copies the cell contents B2:B15 below in the same column. Ideally ma
Background I am making a spreadsheet that refers to information security license registration provided by the Japanese government (https://riss.ipa.go.jp/). The
We have produced some Excel files using Xmla Pivot Tables against Iccube schemas. Everything is working well except the fact that we noticed : Each Pivot Table
For the Twelve Months Ending Thursday, June 30, 2016 I have the above text in excel and I need an excel formula to extract ONLY the date June 30, 2016. The for
I have a COUNTIFS functions that checks a few things. These include; Date Client Whether a certain range is blank The current function I have is this =COUNTIF
Using excel macro The first line is the json file name, and the second and subsequent columns are the values. With the first column as the key to the json obj