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
I built a coded UI test and I want to make it a data driven test , I want to get the data from an excel file ( Data.xls )located in the same directory with the
I run into run-time error 1004 Works if I use the cell as an argument but I don't want to constrain to one cell. I can get this to run if I use an input param
I have created a macro that opens a excel workbook and performs some operations and then at the end it closes the file.The macro is running fine. Now, when I o
We have an internal web application that accepts a file of varying formats from a user in order to import large amounts of data into our systems. One of the mo
I am rying to ge the values of PivotField in PivotTable(1).Pivotfields, then I am trying to get the the filter value to string(str- Declared as string), It is w
I have the following code, which should simply open a workbook from a master workbook to allow me to paste some information which I will later retrieve from a d
I'm trying to open a HTML file in excel (from VBA) so that the HTML inline styling is preserved. Are there any special ways of doing this because currently I've
I'm trying to open a HTML file in excel (from VBA) so that the HTML inline styling is preserved. Are there any special ways of doing this because currently I've
In Excel, I am able to add validation rules to a range of cells and limit the accepted input to a list of values displayed in a dropdown. This is done using the
I have a large number of rows and columns (e.g. 500k rows and 20 columns) all filled with numbers. I'm trying to delete all data in column I that has a certain
I am a bit suprised as I am trying to record a macro in Excel, but I keep getting this error: Cannot Run Visual Basic Editor Because of a Syntax error The mo
I'm trying to write a macro in Excel that will look through my Outlook calendar, grab all the events, and display the following information: subject, start time
elasticsearch-indices