I need to export HTML table with data from database to xlsx file as easily as possible. I've tried PHPExcel and some JS plugins, but unsuccessfully. Is there
I made a PQ append query, send reults to Data Model and then uploaded the pivot table to the excel sheet. Now I'm trying to apply filter based on the cell value
I am getting a Runtime error 1004 and when I debug it, it takes me to this sub, this sub works fine in another sheet, I don't know whats wrong, can anyone help?
I'm trying to parse a json file but the file is set up in a strange way that excel is having problems deciphering. Please see code example below. "in_network":
I'm trying to add a toolbar control on a sheet. I get this error. It does add the toolbar, but that error is not skippable with On Error Resume Next, so it stop
I am using this code: Function wrksht() as Variant wrksht = Application.Caller.Parent.Name End function I am continuously being thrown run time error '424' ob
I a process have a Start date of 1/1/2022 and end date of 3/15/2022, date is in it's own field. Now I have a field for every Month in the Year: J F M A M etc.
I know that this is a really long post but I'm not sure of what part of my process is making my file crash, so I tried to detail everything about what I did to
How to write a list of list into excel using python 3? new_list = [["first", "second"], ["third", "fourth"]] with open("file_name.csv", 'w') as f: fc = csv
Is there a command in Excel to check if a set of rows is directly equal to another set. For instance I want to check if the values inside rows 1 to 10 is equal
I have an xlsx that has two sheets: on has some data in G1:O25 (let's call this "data") and one that has some images inserted into cells in G1:O25 (let's call t
I'm trying to do an excel where to import some data with validations and I've never used npoi before (and my knowledge of excel is as user) so I'm kinda lost a
I need dynamically set via VBA NumberFormat to imported txt file values, as just below : Imported values number type is "General" so I want to
I'm trying to find the column number using a =match formula. In particular I am looking for a result of 42. As you can see, the formula looking in row 16 finds
A small introduction: I need a script that takes an Excel and based on a json that I give to him it sends a Mail to a list of person with attached the same Exce
I have a sheet called "Scores" where I have Column D and J with values from 1-9 in both columns. In this same sheet I have a Column A with the corresponding nam
I'm using Outlook 365 - Microsoft Exchange(owa). I have written a script that looks for emails in my Outlook Inbox with any subject line containing "PHI Attriti
I have a macro in Excel to delete mails older than 30 days from folders and subfolders in a shared mailbox. I have a sub for looping through each subfolder and
I have one column (E) trying to change the Arabic characters to English one. these data i import it as it is from JSON file. How to change these Arabic characte
I'm working with 60 different datasets, each of them with a ton of data in them. I'm trying to build a loop to go through each of the datasets (they are text fi