I have a DataTable with 200,000 rows. I want to export DataTable in excel file. But it gives System.OutOfMemoryException error. using (ExcelPackage objExcelPa
I am trying to create a formula that returns the concatenation of two arrays of different lengths. I need this concatenation for part of anoth
I'm trying to accomplish that if you click on a hyperlink (in column P), it would copy the cell in the same row but in column B to another cell (A3). I'vre trie
I am new to Excel VBA. With reference from a search engine I have created the above code but stuck at one point. My requirement is to sum data in the range of s
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