Questions tagged [excel]

60856 questions
1

votes
0

answer
224

Views

Unable to get rid of ambiguous path error

I've had a look at this post but still can't seem to fix this problem: Resolving an ambiguous reference I'm trying to make a button in WPF that when clicked browses for an excel file and then opens it. However I keep getting the error 'Path' is an ambiguous reference between 'system.windows.shapes...
Friend
1

votes
0

answer
178

Views

Add Comments to Excel pivot slicer options

I have been trying out searching multiple forums before posting this question here. Issue: In one Excel pivot table slicer I have almost 50 options. I have given codes to each slicer option rather than writing entire description about the slicer option. I am looking for some VBA help where in I can...
excelislife
1

votes
0

answer
31

Views

How to fetch data in R by executing command in excel?

I have to fetch data from Reuters and they provide an excel plugin for that. The problem is that my excel is crashing if I try to fetch too many variables at the same time. I was wondering whether I can do it from R via some excel connection. In general I want to give the command to excel (from R),...
Nikhil Vidhani
1

votes
0

answer
77

Views

What charset and encoding does Microsoft Excel use in CHAR() function

Background I am using Microsoft Excel 2010 on Windows 7 environment. System locale is Japanese. I want to convert a character codepoint to a character with CHAR() function. Problem =CHAR(HEX2DEC('244E')) returns a character の. 244E is the codepoint for の in JIS X 0208, so I had guessed that Exce...
satob
1

votes
1

answer
268

Views

Getting the wrong date from cell using PHPExcel

I'm using PHPExcel and trying to get the date values from the cells, but for some reason they give me the wrong date. $dt_column = $obj_sheet->getCell('A1'); $unix_date = PHPExcel_Shared_Date::ExcelToPHP($dt_column); $date = gmdate('Y-m-d 00:00:00', $unix_date); The file is in .xlsx format....
Theodor3gabriel
1

votes
0

answer
587

Views

Convert xlsx file into binary data

I am working on creating xlsx file and i am almost done because i created file successfully but the next i want to do is to add the currently created file into database table and my column requires bytea data so i need to convert the file in binary data. Which i tried in last line but its giving me...
Ahsan Attari
1

votes
1

answer
1.1k

Views

How to reverse search in Excel?

I have a text in a worksheet like: The girl is very beautiful I want a formula to perform a search from right to left for the word 'very', and if found then extract it to some other region of the sheet. Note: Purpose of doing reverse search is because I want to implement it in my workbook which re...
Chen Guo
1

votes
1

answer
28

Views

Strange behavior of phpexcel

When trying to get an Excel spreadsheet from php with phpexcel, strange characters are generated in the output if a constant definition (DEFINE (' var',' value') is added. My code header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename='theFile.xls''); he...
Jam
1

votes
1

answer
45

Views

How to skip specific columns in a Row copy

So, I'm looking for a way to skip specific columns in a row copy. I'm working with doing a bunch of loops to copy/paste from a bunch of sheets of variable sized reports and I want a way to simply skip a column or columns in a row copy since I can't just do a entirecolumn.delete to deal with the exce...
George
1

votes
0

answer
618

Views

Write Pandas Dataframe To Existing Tab in Excel

I have a workbook called 'Pivot Template.xlsx'. I have data from a query in a Pandas dataframe called 'results'. I need to put this data on a tab called 'Pivot Data'. I am using the code below for writing to the file, but the problem is that deletes all of the existing tabs when writing the file....
Eric Shreve
1

votes
0

answer
60

Views

Facing an error with IndexError: list assignment out of range

I don't know how to use Python as I've never learned it before. Hence, I require some help from the community if that is possible. I've been trying to code out a program that loops through every single cell in the stated column and tokenize it for it to be stored in an array. So far, the array hasn...
Andric Png
1

votes
3

answer
1k

Views

Using openpyxl to refresh pivot tables in Excle

I have a file that has several tabs that have pivot tables that are based on one data tab. I am able to write the data to the data tab without issue, but I can't figure out how to get all of the tabs with pivot tables to refresh. If this can be accomplished with openpyxl that would be ideal.
Eric Shreve
1

votes
1

answer
905

Views

Feed cell value into excel query web browser URL

My problem: Through New Query -> From Other Sources -> From Web, I entered a static URL that allowed me to load approximately 60k 'IDs' from a webpage in JSON format. I believe each of these IDs corresponds to an item. So they're all loaded and organised in a column, with one ID per line, inside a...
Mr. Smith
1

votes
1

answer
596

Views

Excel 2013: Condition Formatting with “IF(AND)” and “ISBLANK” and Data Validation Values

I have a formatted table and would like to use conditional formatting to shade in cells in a column (G) based on the following conditions: Value in column (D) must say 'Pending Decommission'. The value is from a data validation list. If value does not match, do nothing. If the above is true, then ch...
Thomas Nguyen
1

votes
2

answer
53

Views

Excel VBA to Remove Opt-Outs

I am a military recruiter and am trying to use autofilter to filter out a range from another range. I got this from another stackoverflow page but can not figure out how to change that string strSearch to a range like [email protected], [email protected], [email protected], etc. We get lists of leads but I'd like to keep t...
Joe
1

votes
1

answer
53

Views

Keep custom functions aligned with their source files

In this link, it says that During development and testing, you can manually clear your computer's cache of registration metadata by deleting the folder \AppData\Local\Microsoft\Office\16.0\Wef\CustomFunctio‌​ns. I then make a test as follows: I load a manifest.xml pointing to the original custo...
SoftTimur
1

votes
1

answer
465

Views

Remove all hyperlinks from an excel file using OpenXML

My data source is an excel file that contains a lot of hyperlinks (running into 1000s). I would like to remove all of these programmatically using OpenXML SDK and C#. My research so far has mostly pointed me to posts that explain how to add a link to Excel/Word files. The solution provided in this p...
user9145313
1

votes
0

answer
38

Views

I am using a cell value in Excel to look up an array based on that cell value

I am using =VLOOKUP(C$2;INDIRECT(C$2);6;FALSE) One of the inputs (a serial number) is MK05391. When I create the range for this row and name it the same as the serial number it won't let me. Says that The name either does not start with letter/underscore, or there's something else namned the same th...
Vrig
1

votes
1

answer
74

Views

How to get dynamic node and element values in xml using vb?

I am very new to vb. In my XML file all the attributes, nodes and elements are dynamic(Healthcare.xml). I am trying to get the values in the below manner. page: login, method: login, args: ad59090,GA124444 In some cases, there will be multiple methods and arguments. page: benefits, method: tagbenef...
Nandan A
1

votes
0

answer
326

Views

Trouble with sending a left click

I have a series of clicks and cursor movements I have in a macro. Everything works fine until the end. All the clicks work until the last click. I have tried to put various amounts of sleeps in between the clicks and before the clicks. Whats odd is that when i click for real it works! ahh Whats also...
Justin Captain Wypij
1

votes
1

answer
486

Views

Pentaho CDE - Export dashboard to pdf/excel format

I need to export my dashboard CDE (Pentaho 7.1) to pdf/excel format. By default Pentaho seems do not export CDE dashboards, but googling a little bit on this I found some post with export just of table or graph of the dashboard. Please can anyone help me? I would like export entire dashboard to pdf/...
Ema
1

votes
1

answer
195

Views

how to make formatted excel columns autofit with c#

I am exporting gridview to excel and this is my code- HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.AddHeader('content-disposition', string.Format('attachment; filename={0}', fileName)); HttpContext.Current.Response.Cache.SetCacheabili...
MUIED AHMAD
1

votes
1

answer
210

Views

VBA Run-Time Error 1004 on ActiveCell.FormulaR1C1

The formula in Excel cells '=DATEVALUE(IF(ISERROR(INT(LEFT(MID(D2,FIND('/',D2)+1,LEN(D2)),FIND('/',MID(D2,FIND('/',D2)+1,LEN(D2)))-1))),DAY(D2),INT(LEFT(MID(D2,FIND('/',D2)+1,LEN(D2)),FIND('/',MID(D2,FIND('/',D2)+1,LEN(D2)))-1)))&'/'&IF(MID(D2,LEN(D2)-4,1)='/',INT(LEFT(D2,FIND('/',D2)-1)),MONTH(D2))...
Eric
1

votes
3

answer
541

Views

Excel VBA ByVal Target As Range Does not update Target Worksheet when excuting from a function cell

I'm having a issues with copying a value from a cell that is using a function to get its value from another cell. Insert value into A1, A3=A1 and when ever the value of A3 changes the changes need to transfer automatically to column H. The issues i having is that if i type the value into A1 then A3...
Kenneth O'Donnell
1

votes
1

answer
82

Views

Custom Format decimal number as N Week N Day

I have a table of dates that i reference in another table that shows the number of weeks & days elapsed since TODAY().I use the DOLLARFR() function to get a decimal value that represents the weeks & days elapsed. =DOLLARFR((TODAY()-M8)/7,7) Where M8 = '22-Dec-2017' & TODAY() = '29-Dec-2017'. This gi...
sifar786
0

votes
1

answer
14

Views

How to read multiple text files (with multiple lines of data) into a two dimensional array?

DESCRIPTION: I have 10 text files. And I want to read them into a two dimensional array. Each file looks like this and the number of lines vary. There are 5 lines in this text file but other text files may have more or less than 5 lines. No. Location(ft) Mix Near Far Comp. Height(ft) B(in) D(in) An...
lhp2290
0

votes
0

answer
12

Views

How to calculate the sum of each day from my excel sheet?

A B C D E SKU Date Sale Date Sum of Sale b0001 01-Apr 1000 01-Apr b0002 01-Apr 2500 02-Apr b0003 01-Apr 5000 03-Apr b0004 02-Apr 3500 04-Apr b0005 02-Apr 3500 05-Apr b0006 07-Apr 2900 06-Apr b0007 07-Apr 3000 07-Apr b0008...
Forhad Zaman
1

votes
0

answer
35

Views

How to access the same session used by WinHttpRequest in a new browser instance?

I would like to automate a currently manual process in retrieving multiple cookie data (e.g. both 'sessionToken', and 'sessionID' from cookie data that's been sent out in a GET request header, which is triggered from browsing to the URL page) as well as parsing a value from the page's inner HTML (e....
intangibleAssets
1

votes
2

answer
278

Views

Excel VBA Changing Combobox list from static range to dynamic

This should be pretty simple, but I am struggling. Right now, this code works: cboCategoryEdit1.List = Sheets(2).Range('A2:A40').Value I am trying to 'clean up' my project by changing how the combobox is populated. I'd like it to be a combobox with a range that only takes populated cells. Meaning...
jpend314
1

votes
1

answer
94

Views

Submit add-ins with custom functions

In this doc, it is mentioned that The following features aren't yet supported in the Developer Preview. ... ... Publishing add-ins to the Office Store or Office 365 centralized deployment that use custom functions. I just want to make sure it means that at the moment we cannot submit to Office Stor...
SoftTimur
1

votes
0

answer
89

Views

How to stop EXCEL asking: “Are you sure you want to install this customization?”

Whenever I open EXCEL, Microsoft Office Customization Installer asks me to if I want to install a specific customization (COMSOL). How can I stop this? Screenshot Thanks!
Kutadgubilig
1

votes
1

answer
37

Views

Folder Explorer is Not Work well in Excel VBA

Private Sub ButtonPath_Click() Cells(1, 32).Value = FolderExplorer() End Sub Above is my UserForm's Code. Below Code is My Module's FolderExplorer() Function. '//Source : http://software-solutions-online.com/vba-folder-dialog/ , edited by me. Public Function FolderExplorer() Dim intResult As Integer...
박영종
1

votes
2

answer
1.8k

Views

Run Macro without opening Excel

This is my first time using VBs. I used to it to automate Excel macro but I failed due to the spacing between filenames. It works fine if the space was removed. I read this post and used the double quote method but did not work. This is how I used it objExcel.Application.Run '''C:\Users\account\Desk...
Max
1

votes
0

answer
414

Views

Highlight Cell in one Column BASED on Conditional Formatting of Other Columns

I am a beginner with Macros. I slightly changed my code below to include conditional formatting based on an Input Value. The code below applies a conditional format (orange highlight) to 6 specific columns based on whether those columns contain a specific text. I would like to add another step afte...
NoeyPI
1

votes
1

answer
1.2k

Views

Is there a faster way to read excel files to pandas dataframe

I have around 700 excel files which needs to be converted to csv files by removing some headers and changing some column names. I have managed to implement the solution however it is slow. What I found is it takes a lot of time to read excel to a dataframe am using pandas as shown below: df = pd.re...
Azhar
1

votes
2

answer
238

Views

How to add dynamic comment to column with validation list?

Given an excel column with a validation list (dropdown). How do I show a dynamic comment based on the selected option? Thanks
fabian
1

votes
1

answer
229

Views

SSRS button to go to subreport in excel export

We are creating a Summary report with lot of Sub-Reports linked to it in SSRS. When Summary report is exported as excel all Sub-Reports should be exported as separate tabs. So far it is working. Now the issue is we need to have button in each row on the Summary report (in the tablix) , which when c...
vSh
1

votes
0

answer
258

Views

How do I import multiple excel files and merge them using openpyxl

How do I import muleiple excel files and merge them using openpyxl the code I have so far is this..... from openpyxl import Workbook def Test (filepath, yaml_sheetname): assumed_cell = 'A1' wb = openpyxl.load_workbook('/Users/c1carpenter/Desktop/Test.xlsx') wb = openpyxl.load_workbook('/Users/c1carp...
Carolina Estrella
1

votes
0

answer
93

Views

Copy Range of cells to Visio (2013) using VBA code

I have an Excel range of cells (let's call it 'Table A') and I would like to copy that Range/Table into Visio using VBA. Without VBA - I can copy the range in Excel, go to Visio - Insert - Chart - go to Sheet1 tab - Paste Using VBA - I am a novice so this is what I think it should look something li...
Shadowcast
1

votes
0

answer
54

Views

Combining vba filters

Does anyone know how to combine these two lines so that when I run the code rows that contain Oranges do not appear. At the moment, only the first filter is working. So I get all of the Apples, but the second filter does not. Thanks in advance! ActiveSheet.Range('B4', Range('BT4').End(xlDown)).Auto...
Gandalfrandalf

View additional questions