I'm using MS Excel O365 Business in version 1905 (compilation 11629.20196). In this case i have created two sheets: 1) "Orders" 2) Order_status NUMBER_ORD
I am trying to update an existing Excel file with many formulas. I can't use evaluate-function ( Excel-file contains a function not supported by Apache POI )
Is there a way to load/import an HDF5 file (sometimes called H5, HD5, or Hierarchical Data Format) in to Excel? I do not want to export an intermediary CSV fi
I am coding simple application having one window form using c# in visual studio, app exe will be opened by excel VBA macro and the application will read the val
I would like to write a user-defined function CHOOSERANGE that returns a range from 4 coordinates. The first version is as follows: CHOOSERANGE = LAMBDA(row_min
Is there a function in Excel that will automatically change the hyperlink (hyperlink from a cell on one sheet to cells on another sheet) destination? For exam
I need help in replacing missing values in the following dummy file. The following rule need to be followed when replacing a missing value. If the value is the
Microsoft Visual Basic for Applications 7.1; Version 1088 I created a custom error handler by following online tutorials and I've been us
I am trying to embed a range from a worksheet as an image in outlook mail body. It's saving the picture correctly but I only see blank image in the outlook mail
[update]: Final code used at the end of my question. My problem refers to a graph customization in Microsoft Excel using VBA. I'm trying to customize the label
public class ExcelParserController : ApiController { [HttpGet] public IEnumerable<string> Get(string templatePath) { ExcelParser excel
I am trying to import my json file to excel via the get data function. When doing this i get an error saying that "We found extra characters at the end of JSON
I have a raw data report in Excel 2016 that has hundreds of records, each record contains: a person's name, date, case number, site, and supervisor, along the r
I want my macro to activate ONLY when a calculated cell in a SPECIFIED range changes. At the moment the macro activates whenever any cell on the sheet is calcul
How can I combine two disjoint ranges to be used in an array formula. Example: {=PERCENTILE(10^((E2:F2)/10),0.7)} This works however: {=PERCENTILE(10^((E2:
I've recently made a MCQ test module that will help in preparing test papers with random questions from the question bank and conduct test and calculate the mar
I am running a experiment in excel using NORM.S.INV(RAND()) Is there a way to set the seed for the random function?
My ultimate goal is to give any piece of information on contacts in Outlook or MS Exchange and get their name and email address without encountering any warning
I am in need of help with looping through a range (In this case Column "C") and finding 5 specific words (Sort, Set, Shine, Standardize, and Sustain) and then o
I have a Value 38142 I need to convert it into date format using python. if use this number in excel and do a right click and format cell at that time the value
github-services