Many spreadsheets have formulas and formatting that Python tools for reading and writing Excel files cannot faithfully reproduce. That means that any file I want to create programmatically must be ...

I have excel cells which contain entries like this: name/A/date name/B/date name/C/date Cell content is displayed on multiple lines in the same cell. I would like to make only "name" bold for al...

Right now I have a long list of "Industry" values that users have submitted through a form. I've written a macro that will search for particular terms in those values and paste values that conform ...

I have an Excel spreadsheet that I am reading into a Pandas DataFrame: df = pd.read_excel("file.xls") However, one of the columns of the spreadsheet contains text which have a hyperlink associat...

I would like to generate 5 random number between 1 and 49 and place them into a row range like A1:AA1 in 5 random positions. The empty cells should get a value of 0. The basic concept is =RANDARRAY...

I am currently trying to format one column of my table so that if there are any names that match in another column, the cell in the original column will be highlighted. Here's an example of what I ...

Microsoft is about to release a new "Spill" feature for Excel. At time of post, this not available in the current version, but insiders can use it. Is there an "easy" (non-vba o...

How do you read a password protected excel file into r? I have tried excel.link but its not available for R version 3.2.3 (My version) I also tried RDCOMClient but it is also not available for R...

currently I am preparing an R-lesson for a customer. We want to read in data from a password protected xlsx file. Thus, I am trying to read this password protected xlsx file into R (unprotecting th...

Whenever I have the file open in Excel and run the code, I get the following error which is surprising because I thought read_excel should be a read only operation and would not require the file to...

I am looking to make sort of a little form with groups of checkboxes and option buttons which will later feed a vba code. I need to make group boxes with 3 option boxes in them but independent. As ...

I'm trying to implement reading from .xls file. I have the following code: FileInputStream file = null; Workbook workbook = null; try { file = new FileInputStream(System.getProperty("user.h...

I have written a code where I need to get the number from a string like this: "3/1". I need to store those 2 numbers as integer in 2 different variables. I have written this code in 2 classes: This...

I would like to apply a Filter function on multiple columns ranging from A:G and only have columns B,D in the output. How can I do it? For Example =FILTER($A$1:$G$7,$K$1:$K$7=$K$1) results in a spi...

I'm using DoEvents to force an update of a progress indicator in the status bar (or in some cell in the sheet) as in the example code below. But the screen doesn't refresh, or stops refreshing at s...

I am trying to delete multiple columns in VBA for Excel. I downloaded data from the Illinois Statistical analysis center about drug arrest. http://www.icjia.org/public/sac/index.cfm?metasection=for...

My requirement is I have a Excel which contains some data. I would like to select some data from the excel and open a PowerPoint file and Create Table in PowerPoint and populate the data in to it...

I'm using Python version 3.6 and the latest version of the openxlpy module (v2.4.8) on Windows. I want to change certain font to bold in a cell, but I don't want all the text contained in the cell...

I'm really struggling to find an answer to this as online I've really only found VBA solutions to this problem which isn't what I wish to learn how to do. THE PROBLEM BLOOD NAME AGE GENDER A Davi...

Q: How do i determine if an error is in any cell in the entire workbook with Excel VBA? Normally errors will be divide by 0 or #value errors, but this list is not exhaustive (or is it? - i don't kn...

For example, I have an xls where : column A has list of items with property A column B has list of items with property B I need the following : column C which is A union B (unique items of bo...

I'm looking for a way to compute a random number once in Excel. So its computed the first time its called, but then it doesn't change afterwards. So for example, if I had something like this in B1...

I've searched around and I know how to call a function from Personal.xlsb from a VB macro, but how can I call the function to be used in a new workbook? Here's my function, saved in 'Module1' in m...

In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" Application.DisplayAlerts = False Set xls = CreateObject("Excel.Application") Set wb = xls.Workbooks...

I'm using openpyxl to put data validation to all rows that have "Default" in them. But to do that, I need to know how many rows there are. I know there is a way to do that if I were using Iterable...