Two columns: Column A contains a complete list of available journal titles; Column B contains the ones to which my library already subscribes. Is it possible to delete entries from Column A if they also appear in Column B? In other words, I want to 'dovetail' two columns so that no entry is represented in both columns. Any help will ...
I have an excel add-in that keeps coming back when I start excel, even though I've removed it from the last open instance of excel (yes I checked the processes in task manager). The critter even shows up when I start excel in safe mode. Anybody else had this? ...
I need a quick an simple excel formula to get the sum of values for different types of objects as listed below: Type1 10 Type1 10 Type1 10 Type 2 10 Type 2 10 Type 2 10 Type 2 10 Type 3 10 Type 3 10 Number of items and number of types are unknown (long list), in a different worksheet I would like to get su...
I need a quick an simple excel formula to get the sum of values for different types of objects as listed below: Type1 10 Type1 10 Type1 10 Type2 10 Type2 10 Type2 10 Type2 10 Type3 10 Type3 10 Number of items and number of types are unknown (long list), in a different worksheet I would like to get sum of types like: ...
In excel & word 2007 there is a picture tools tab that shows up in the ribbon when you insert a picture or clip art and there is the smart art. Is there a way to manipulate these objects and settings (e.g. transparency, position, effects etc) in vba. A macro doesn't seem to work for me either. ...
Hi, I am using Python 2.6 + xlwt module to generate excel files. Is it possible to include an autofilter in the first row with xlwt or pyExcelerator or anything else besides COM? Thanks ...
I am inserting data from an Excel sheet to SQL Server 2005 db. I am getting this error randomly, sometimes after 20-30 records and sometimes after 1000s. I am unable to find the reason. I am using Visual Studio 2008. The CLR has been unable to transition from COM context 0x21a7b0 to COM context 0x21a920 for 60 seconds. The t...
I have an ASP.Net MVC site that generates a Microsoft Excel 2003 XML formatted spreadsheet. The spreadsheet looks good, the controller and views both work, but the file won't open in Excel. It opens in the browser because it is an XML document. I tried changing the ContentType to be the Excel XLS format (application/excel) and that ma...
I have a spreadsheet named "Data Sheet" that collects data from other worksheets via formulas and works perfectly. I need a macro that will copy the data from multiple rows so I can paste into a seperate workbook. I have 30 rows of data ranging from A3:EI3 to A32:EI32. This data is collected from 1 to 30 other sheets if they are made vis...
Do you know any free C# library for Excel/CSV import/export operations? Which should work without having Excel installed on machine and works with 2003/2007 formats. ...
I would like to convert an excel cell eg : A1 to 1,1 G6 to 7,6 etc Does any one have idea for it? Note : This is required for a C# application. ...
I have a few reports that are exported to Excel. The problem is whereever there are special characters, it is being replaced by some funny symbols For example, '-'(hyphen) was replaced by –... Any help to solve the problem?? ...
Hi all, I'm running into some formatting issues with exporting data to an excel 2007 spreadsheet. I have a template file that has the columns formatted correctly, but when the data is exported it doesn't get the correct formats (currency, short date, etc.) I'm thinking I have 2 options Have excel autorun a macro. (hate that idea) Fo...
is it possible to create a hyperlink in an excel document , clicking on which opens a particular sheet in the excel document . please let me know ? ...
I would like to update values in the current sheet in current document regardless of file name of excel. In vb6.0 we could do Set AppExcel = GetObject(, "Excel.Application") Set SheetExcel = AppExcel.ActiveWorkbook.ActiveSheet How ever I have been trying to do same in C# . Is there a way to do same in C#. ...
Hi, I am reading the input Excel file and in that i have 1 fields for the address.In that field the special character is coming which is (&).While i am going to parse this character (&) and trying to write it to the XML file at that time the character converts into the (&). I want to remove the translated character (&) from the X...
My challenge is as follow: In competition we have "repechage" Meaning the competitors who loose his fight against the finalist have a chance to come back to get a bronze medal. Now, how can I find the competitors that lost against the finalist if I cant enter more than 13 ifs? =IF(N23=B8;B10;B8;IF(N23=B12;B14;IF(N23=B14;B12;IF(N23=B16...
I have a very simple Excel book that I am trying to spiffy up. Here's what it looks like: Sheet 1: ID Name 1 Bob 2 Joe 3 Earl Sheet 2: Name ID Whatever I would like when I type a name on sheet two for it to match it to a name in sheet 1 and fill in the id for that row in the field in sheet 2. So If I type "Joe" in sh...
How can I call a function defined in a COM Addin using excel macro ? Basically I have created a Excel COM Addin which does some bunch of stuff. Now I want to invoke this via excel macros. Is it possible to do it ? Or Is it possible to install COM Addin using a macro ? ...
A B C 1 PROD1 TYPE1 VAL1 2 PROD2 TYPE1 VAL2 3 PROD1 TYPE2 VAL3 4 PROD2 TYPE3 VAL2 In an empty cell I want to get the value in C column for the Prod Type= Prod2 and type = type3. I will appreciate any kind of help. ...