Newest excel Questions

Q&A for professional and enthusiast programmers

Python Pandas export data

I am using python pandas to process some data. I have exported my data to an excel file using the below code. writer = pd.ExcelWriter('Data.xlsx'); wrong_data.to_excel(writer,"Names which are wrong",...

Using Excel MS Query to pull data from Access

I'm using Microsoft Query in Excel to pull data from an Access database. I don't own the Access database, but I have permission to query its tables and queries using my Excel spreadsheet. I'm ...

How can I speed up this search in Excel and do I need to start from scratch with the code/can this be modified to this end? [on hold]

I have data in over 1000 cells in one workbook, spread over 10 worksheets that I am able to search through using a button. If I use find and replace the data is found within seconds, but using the ...

Index match multiple criteria with return all if no selection

How do I create a multiple criteria index match formula to return ALL criteria selected from 3 independent dropsowns, that will also return all criteria values in any dropdown that is not selected?

Excel VBA to populate multiple Word pages from one Template

This is what I'm trying to achieve: Design a generic envelope template in Word with bookmarks or placeholders; "Group Name", "Guest Name", "Date". (Completed). Design an Excel sheet to input required ...

Unreported Exception. Must be caught or declared to be thrown

so I'm in the process of trying to learn Apache's POI API and I'm having a little difficulty understanding something. I'm trying to open an existing Excel File using the JFileChooser class, so that ...

VBA Vertical scrollbar thumb size

I have a form where controls are dynamically created, the scrollbar included, with Set theScroll = UserForm1.Controls.Add("Forms.ScrollBar.1", "sc1", True) but I'm having difficulty resizing or ...

show data base value in each column of excel

I want to extract my database values to excel ..so i given code like this: sql = "select * from tbl_ItemTransfer" cmd1 = New SqlCeCommand(sql, cn) dr = cmd1.ExecuteReader()...

Write to a text file from Excel range

I'm trying to use Excel VBA to write a range to text file. I'm using the following script which I found: Sub VBA_write_to_a_text_file_from_Excel_Range() Dim iCntr Dim strFile_Path As String ...

TextFieldParser file in use

I am parsing a csv file is ASP.NET application. This file comes form another server so I am reading it as response.Content.ReadAsFileAsync and storing it on a server before I read it. When I fetch ...

Is it possible to spool and append to an excel output in sqlplus

So I generate this excel output using sqlplus with the spool command in my sql script, but when I try to run another script and append the output to same excel file, it doesn't seem to work. The ...

Copy from one workbook to another using VBA

I am trying to copy data from Source.xlsx to Database.xlsx (from where I want to run the macro). The below from this website does the opposite of what I want to achieve. Can someone help me to adapt ...

“NullReferenceException was unhandled” for vb.net when trying to export data to excel [duplicate]

I was trying to export my datagridview data to excel and when i run it after i watched the tutorial this error appeared. It says that "An unhandled exception of type 'System.NullReferenceException' ...

Export HTML table to xls in UTF - 8 for mac and pc

I'm trying to export a table to xls, i found two ways -- first -- //getting data from our table var data_type = 'data:application/vnd.ms-excel;charset=UTF-8;'; var table_div =...

document.location does not produce file

I am trying to generate an Excel file and downloads in the browser when user clicks a button. var vFullExportContent = getExcelXmlNew(includeHidden, fullPageStore); This generated the Excel ...

Automatic Transfer of Data to Sheets Based on Drop-Down by VBA [on hold]

I have an Excel workbook with sheets named All Data, MI, & CF. In the sheet named All Items, there is a table column labelled Lab Group ID which offers a drop-down of three choices: MI, CF, & ...

Two macros on one button in Excel

I have a macro which resets the formatting of a particular worksheet and VBA code which searches for data. I want the button which currently executes the search to firstly remove all of the pre-...

run-time error 91 - issue with object [on hold]

Receiving Run-time 'error 91' I believe the issue is that objCell is not defined but I don't know how to get it to work. Dim objCell As Object 'We will look at this at a later time Dim lngLastRow ...

VBA - Excel - Search multiple string through multiple files in a folder

I begin with VBA and programmation. I have a spreadsheet with X values. Each of this values match (or not) with an .xml file in a folder (the value is present in the xml title). What I need is that ...

How can I save a new sheet into an exsisting workbook from datagridview using visual studio

I am exporting my data from visual studio data grid view into excel and I want to know how to add/save new sheets into an existing excel file.

How to convert stings to int/Typecast in MICROSOFT EXCEl

ok so I basically want to create an interactive form on an excel spreadsheet such that I can average out a result based on an arbitrary number of inputs, however it gets tricky becuase user input ...

Checking Value of Checkbox and setting value for all other Checkboxes accordingly

I am trying to create something like a "Mastercheckbox" that will automatically check all other checkboxes on my worksheet. So I'm trying to start the following VBA Code as soon as I click click on ...

add intersection of row and column of different matrices [on hold]

I'm new to excel vba. I need to find and add all intersections of rows and columns of n number of matrices. for example I need to fill matrix 3 with values from matrix 1 and 2. From matrix 1, row "...

Excel Formula Converted to C# returned NaN

I have formula in excel sheet with returns $205.03. I converted the formula into C# code and it produced NaN. C# Example on dotnetfiddle Excel formula to calculate the result Excel formula:=IFERROR((...

MS Excel: insert a row automatically if the content in a cell is <> that in cell of the last row?

I want to add a row automatically if the content in a cell is not the same as that in the cell of the last row? e.g. B1 contains "K1234", B2 contain "K1235" then add a emply row between line 1 & ...

Combining Columns in Power Query without splitting into multiple queries and appending

I have some reports that I am processing with power query, that I have a solution for, but I am hoping the wizards here have a better method. In the example below, my current method is to split into ...

How to solve 10 fold cross validation [on hold]

Compare and analyse the performance of the following classifiers using F-measure, Accuracy and Area Under Curve (AUC) as performance measures. Use 10 × 10 Fold Cross Validation. Show standard ...

Find file with a text in spreadsheet using vba and attach to Outlook email

Hi I'm coding in Excel and really need your help to complete the following task. I have an Excel spreadsheet with doctor's ID(Column A)and email address(Column B) and some email options. In a folder ...

excel cell = filename of another workbook

I have a macro for updating a sheet from another workbook, how can I use that same file to update a cell with its filename without the .xlsx. Can I use the vFile or wbCopyFrom Dim? Sub UpdateTSOM() ...

how to customise skipping of rows while parsing an EXCEL using xlsx in node?

I have found a way to skip the rows but how to customise it like I want to skip 4 rows for first 3 columns and 5 rows for 4 to 11 columns and 4 rows for 12 th column using this ` var range = J....

how to output values from cells in excel to textboxes with date as search parameter

this is the data in excel screenshot2 I click a date in the calendar and then output the data under that date in the first picture. how can i do it?

Document viewer wpf for dynamically created excel

I have excel file (.xlsx) in stream, and I want to show this file in document viewer. Document viewer accepts IDocumentPaginatorSource however I have a stream.

Excel Macro append duplicates to first line

I'm an Excel VBA newbie and i'm trying to get the duplicates rows to appends to the first occurence of that row. Per exemple we have the table here I would like to format data as here The logic ...

Excel VBA validate pdf password

I have created on Excel VBA application to open pdf file with password with Acrobat component. but i want to get the return value true/false when enter correct password (True) and wrong password(False)...

Use of a column in excel sheet as an input in update statement in Oracle using PL/SQL

I'm just curious - is it possible to use the values in a column of an excel sheet sitting in my C:/ as an input in an update statement I'm writing in PL/SQL connected to an Oracle DB. Update Statement:...

How to dynamically import Excel data into SQL Server 2008 using C#?

I tried to dynamically import data from Excel sheets into a SQL Server database. I want make permission to user to select which table in the database he want to add in This is my code and I don't ...

Excel-Levenshtein algorithm applied on column

I am trying to use Levenshtein algorithm to find similarities between records. What i have is column of Item#, description, LookUp, Similarity(%),ReturnSimilarItem. In the column Description i have ...

DataFormat function from xlsx package in r seems to not work correctly

I need some advise from someone who used this function before and had similar issue. Namely, I apply formatting on the cells: csnumb <- CellStyle(outwb, dataFormat = DataFormat("#,#0.0")) [...] ...

error when reading an excel file java

I am new to POI. I am trying to read an xlsx file with the code below in Eclipse: import java.io.File; import java.io.FileInputStream; import java.io.IOException; import org.apache.poi.ss.usermodel....

content controls with same title have odd index order

My question is really the same as an older post that never really got solved with a twist. VBA MS Word content controls messed order I have an excel macro that is early binding word and using and ...

How to put if-else condition inside Shiny action button code?

The software that I am developing is a 'Sample Selection Software' which using RStudio. The software will behave like this. User uploads Excel document. Then, the user will click 'Submit" button. ...

How do I make a macro that will add a new row with a button that will move when another new row is added

I want to make a table that starts with one row (B14:H14) that has a button in B15 that will run a macro to insert a new row (and copy and paste the formulas from the initial row to the new row). BUT ...

Average including blank cells

I would like to average a range but some of the cells are blanks. The cells should remain blanks, is there a way of including them in an AVERAGE? For example, if I have 2 cells, one is empty and the ...

Convert date from excel file to pandas

I'm importing excel file, where the 'Date' column has different ways of writing: Date 13/03/2017 13/03/2017 13/03/2017 13/03/2017 10/3/17 10/3/17 9/3/17 9/3/17 9/3/17 9/3/...

Msgbox from formula result

I am trying to add a message box if the above formulas return an error or if the cells in the selection are blank, but as of yet have not been able to complete. Any ideas? LastRow = Range("B" & ...

Basic loop (excel not recognizing code consistently)

I am doing a sales dashboard using vba in excel and I have been having trouble with this loop. I have used the same loop multiple times and sometimes it works, but sometimes it doesnt. Excel keeps ...

Find value from columns

I have two sheets. Data Column A Column B Column C Column D Column E 1234 Sheet 1 Cell N3 = 1234 I am using this code to try and find the value in columns A-E. But for some reason ...

Select pay rate based on day and shift start time

Im creating an excel pay sheet so i can keep tabs on my pay. I have two pay rates, £9.30 is paid for hours worked from 6pm to 8am Monday to Thursday £10.30 is paid for hours worked from 6pm Friday ...

Excel PivotChart Treadline Horizontal Label

I've created a Pivot Chart from my Pivot Table, and added a Treadline to forecast the next four quarters. However, the horizontal axis for the new forecasts is blank. How can I add a label to the ...

Single Line to Double-line Formatting in Excel

In my job I have to enter warranty information so that POs can be cut. Vendors are very particular with how this is entered and each one has their own format. One of them requires data be entered: ...
Translating... 0%