Category "excel"

Why does the use of "Debug.Print" lead to "Overflow" error?

I create a function to sum all the cells within a range as following Function SumTest(rg As Range) As Double Debug.Print "SumTest..." Dim s As Double s

Setting Excel cell value based on another cell value using VBA

I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the same row using an equation I have. if there is

Adding new Excel file to SharePoint - irgnore ask for check-in

I am adding a new excel file to a SharePoint Library. The Library requires check-in or check-out. When closing the excel workbook, a dialog pops up in the backg

Create a Range Object from Multiple Areas Items

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

SheetJS xlsx-style need cell style in excel

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

How do I clone existed complicated rows to the work sheet using openxml

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

How to loop through the same cell

Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En

ClosedXML cannot set cell data tyep to Number format with a long - v0.95.4.0

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

Check if dynamic array is initialized or contains value - VBA Excel

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

if range of cells contains string then goto

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

Why does my standard deviation formula result in #N/A?

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

What is an efficient way to connect Excel to ML.NET?

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.

Filter Pivot Table based on clicked cell text

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

Preserving Data Groupings when writing to Worksheet using OpenPyxl

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

Copy data to another spreadsheet based off value stored in string

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

Conditional branches of a function raise false circle reference errors

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

Excel document lost all data

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

How to write a loop with openpyxl that allows me to copy a range many times below (watch photo)

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

Convert GET parameter to POST request body and extract specific JSON property

Background I am making a spreadsheet that refers to information security license registration provided by the Japanese government (https://riss.ipa.go.jp/). The

IcCube Excel Xmla opens one session (connection) per PivotTable

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