I am new to programming in Excel. I have done very little Visual Basic. What I would like to do is check a column on one sheet in Excel and compare all the values to a column in a different sheet in Excel. Now the problem is, is it possible that when i click on one of the cells it is "linked" to the other and takes me to the matching cel...
In .NET C# I'm trying to open an Excel template, add some data and save it as a new document. I'm trying to use the OpenXML document format. I can't seem to find any guidance on how to do this. Seems like all the documentation talks about how to write various parts to the Package but I can't find anything on what to do when you're done...
I can't resolve this issue, I found a similar question here but: setting the workbook to Manual calculation (alt-m-x-m or alt-t-o>formulas) didn't work Setting editor options to disable: Auto syntax check & Background compile didn't work anybody have any idea how to fix this very annoying behaviour, I'm used to quickly pop up VBA (al...
I have an Excel 2003 add-in deployed in one of our departments that occasionally needs updated. What currently happens is that I publish the new version from my machine to a central location, this updates a version number stored in a database that the add-in checks each time any of the modules within it are run, and if a newer version n...
Hello, I have a scenario where a user creates a workbook, then this workbook (let's call it A) is assigned a variable. Later on down the line, the user creates a second workbook (let's call it B), which is assigned another variable. The names of these workbooks are not fixed, thus they are always variables. Now I want to do a VLOOKUP...
Hi, I have a cell in Excel that I want to format differently based on a user defined formula (UDF) - my formula tests whether there is a formula in the cell... I am trying to use conditional formatting with my UDF to format the cell - but it does not seem to be working. My condition is this: ="isManualPrice(R22C12)" I tried without...
Hello! I'm trying to write an excel file from php, and I need that some cells to have date type; do you have any ideas which is the format code for that type of cell? I'm using the code from http://pizzaseo.com/php-excel-creator-class to generate the excel files. Thanks. ...
I have a lookup table in Excel with ColA and ColB : ColA ColB ColC va 1 value1 ColC is the actual value table I need to do a wildcard lookup with lookup_value = "value1" I need to perform an operation that if the value of ColC matches the characters in ColA then it should return me ColB value, i.e. 1 I want to use wil...
I am creating an excel report by changing the content type. Response.ContentType = "application/vnd.ms-excel" I have values that contain leading zeros. The issue is when exporting to excel the leading zeros are missing. e.g. 000123 -> 123 I know that this can be changed manually via excel. The question is how can i accomplish this ...
I am using the folowing function to export the information from my DataGrid to Excel. But when it asks me if I want to Save or Export, it takes too long. Anybody knows why/anybody got similar experiences? void ExportToExcel3() { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); ...
I am trying to set the color of individual points in an Excel scatterplot through C#, but can't get it to work. Here is the code I am currently using. Note that the MarkerStyle and MarkerSize part of the code works - so my issue is really about color. I suspect I am missing a cast somewhere. var point = (Excel.Point)series.Points(index)...
I am using Excel to generate a whole slew of INSERT statements, similar to the process described here. I would like to have an SSIS package that will run through each row of this excel file and run the SQL statements it finds against a database. Is this possible? EDIT: As John points out - there is a better way to do it - generate th...
Dear All I am an SQL newbie, I am having an excel sheet in which the first row contains title for all the columns. I want to all the names in the first row. Question What is the SQL command for - reading all the entries in the first row? If possible, I want to define the max-limit. Addition: What I want is, "Enumerate all the column...
I want to have a textbox or a caption in an excel worksheet, that displays the value of some cell from this worksheet. Is it possible? ...
I want to download an excel file which contains three sheets using PHP. Can any one help me? ...
I want to download a macro-enabled Excel workbook from my PHP page. When the workbook displays, the macro should run. How can I ensure the macro will run after the user opens the Excel workbook? ...
Can anyone give a web link to or demonstrate here how to do F# and Excel integration using .NET 4.0 (Visual Studio 2010 Beta 1)? I know how to do this in the CTP release but as far as I know it should be simpler in .NET 4.0 (Visual Studio 2010 Beta 1). ...
I want to scan an excel sheet, and replace any occurrences of social security numbers with zeros... I would like to do this using Excel.Interop if at all possible, but I'm open to anything at this point... here's some of my code... I'm banging my head on the desk for the past few months... // Get range and convert it to a string varia...
I am looking for suggestions on this specific question: What's the fastest way to generate Excel files (regular XLS, not the XLSX ones) in Visual Basic 6 (VB6)? Thanks a lot. ...
I have to update this code to do a substring or regex match but I don't even understand the code: INDEX( $DATA.B$2:B$1501; SMALL( IF( $DATA.$A$2:$A$1501=$B$3; ROW($DATA.$A$2:$A$1501)-ROW($DATA.$A$2)+1 ); ROWS($DATA.$A$1:$A1) ) ) The bit that has me scratching my head the most is $DATA.$A$2:...