I have an Excel document consisting of data imported into multiple tabs. The columns in each tab are stretched out and hard to read. I am trying to cycle throug
I have created a windows application in C# and I am using excel as a temporary database. I am able to read in the excel data, but I have no idea how to update
I'm trying to add 9 hours to this column and if there's a text like (off, annual, ..etc), then put the same text. but i found an error in the generated column,
I use JXLS to create my woorkbook. JXLS uses POI underneath. To create a workbook JXLS either need a File or an input stream. With file object I get my desired
I have a workbook with several comboboxes (and listboxes) and a lot of vba written around them. I've used the same code in the Workbook_Open procedure to format
I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I think some kind of exit at t
I am relatively new to python and Stackoverflow but hoping anyone can shed some light of my current problem. I have a python script that takes excel files (.xls
I am creating an activity tracker in Excel. I'd like to be able to "Select all that apply" from drop down lists in two separate columns on the same sheet. I am
I wrote a macro to check if a date is the last day of a month. If so this cell should blink every 1 second, so I'm calling a Do While loop. I want to start the
I have a program which writes to a spreadsheet using openpyxl. Upon execution of the program, the cells are filled as expected but the spreadsheet becomes damag
I'm trying to use two custom lists to order the columns in a specific reach. First I define the two custom lists (arrays) and in the .Sort statement I give the
How do I color all the series (lines) in a specific (selected/current) chart the same color? I have the following, but it does nothing: Sub Same_Color() Dim
The Sunburst chart type was introduced in Office 2016 / 365, along with some other new chart types. I'm trying to work with the chart type in PowerPoint, but it
I am trying to add two sheets in Excel file using my php code. Here is the code $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel= $objReader->load(SS_AD
The columns of interest are bonus? and points_earned. For each day, players submit a number of guesses, and I'm trying to write a formula for the bonus? column
The accepted wisdom is that using a construct like Dim dict As New Dictionary is poorer in performance than Dim dict As Dictionary / Set dict = New Dictionary.
How to play local video file on loop on an excel userform?
I have an excel file with about 500,000 rows and I want to split it to several excel file, each with 50,000 rows. I want to do it with pandas so it will be the
I'm working on a school project to compare if date1 is equal to date2 - 1 (date1 is one day earlier than date2). date2 is located one cell below date1. This is
I have a pandas DataFrame that I would like to write to Excel. For one column, I have data values that are comma-delimited strings, like "val1,val2" or "val1,va