I made a XY plot that shows points from one data set in two different colors, depending on a set of conditions. I achieved this by making the source table three columns instead of two. First column is the X. Second column is Y is one set of conditions apply, third column is Y is the other set of conditions apply. So the second and third ...
I have a legacy Excel 2007 Template that has hardcoded Ms Access MDB path in the VBA code used to connect to the Access tables and save, retrieve data. I migrated the MS Access Database over to SQL Server with Integrated Authentication for the Excel 2007 Template Users. My question is, What is the Recommend Way / Best Practice for stor...
Hi I want to read from an excel file in C. The excel 2007 file contains about 6000 rows and 2 columns. I want to store the contents in a 2-D array in C. If there exists a C library or any other method then please let me know. Thanks. ...
Hi all, i'am trying to make a conditional colorization in Excel 2007. Let me explain in more detail. If a user writes some desired words (e.g: Alper) in A1 cell there is not problem, but if user write another word (not Alper) then i want to colorize A1 cell as red (as warning). And i want to do that for all A colmuns (A1,A2,......AN). It...
Hi all, I have a VSTO add-in for Excel 2007 and need to figure out a way to disable two types of events in the Excel: deletion of worksheets and repositioning of worksheets. Ideally I could just handle the event, pop a message to the user indicating the function is disabled, and cancel the action. Does anyone know if this is possible t...
I have a 2D array of type Variant. The size and values that populate the array are generated based on data within a worksheet. Further processing is required on this array, the primary being the interpolation of several values. I am using this interpolation function ( I know about excel equivalent functions but a design choice was made n...
I have 2 Excel sheets (using Excel 2007) Excel sheet1 with column names name kumar manu kiran anu Excel sheet2 with column names name kumar anu I will upload the sheets and then I click on a button (here I will compare the names columns from each sheet) then I need to add the names missing from sheet 2 to a...
Hi everyone! I need help with changing excel 2007 document orientation to landscape. I have not found any helpful information about this. I am using OpenXML SDK for this. The only thing I have found: when I create a new Worksheet I should set PageSetup() { Orientation = OrientationValue.Landscape}; But this doesn't help. Can anybody hel...
I want to allow the user to increase and decrease the decimal places of a locked cell in excel 2007 without allowing other formatting options. Can anyone tell me how to do this? ...
Excel VBA: I am trying to get to some activex option buttons through the OLEObjects object, but I am finding that even though I change the value of (Name) in the property window for the object, it still requires the "OptionButton1" default name as a key. I know that some of the objects in Excel VBA have a code name and another name whic...
Hi! I have and excel file which is connected to an external xml file and uses it as data source (every time I use "refresh all" it reads the xml file and updates the sheet with the data). I want to disconnect from the data source (so that the current data will be copied to the sheet, and pressing "refresh all" will do nothing). I trie...
Hi, How can I sort data containing text and numbers depening on odd and even numbers? example: a1. a03, b2, n08 n9 ans should be: a1,a03,n9 and b2,n08 i want to get separate lists. Please help. Thank you. ...
I built an Excel add-in with VSTO 2005 SE, which I deployed to a user base that is predominantly Office 2003-based, but also with several workstations that have Office 2007 installed on them. On the Office 2003-based workstations, the add-in works perfectly. Now because this add-in was created with the version of VSTO for Office 2003...
Hi, Using : Analysis Services 2008, Excel 2007 I've created a Cube and am able to connect from Excel. Cube does have some Calculated Measures, Named Sets and KPIs. Now, I'm been writing some MDX in MS SQL Server Management Studio. How do I write MDX queries and make them available through the Cube? Can I create Cube Views / Cube spr...
I encountered a weird problem setting a custom date format with PHPExcel: I'm writing an sql formatted date to a cell and setting it's format with setFormatCode to 'd/m/y'. When I open it in Excel 2007, it shows the orignial date format until I double click the cell and then it's updated to my desired format. Is there a way to have it re...
I'm currently considering a number of options for copying an excel sheet into a powerpoint presentation. Using VBA select a excel sheet, copy the range and place it into a newly created powerpoint slide as an image. I create excel automated html of a sheet, once that html is saved(initially), i create an image off of the html. Using VS...
I want to perform a vLookup from a combo box in excel. I have a table of customers that I have linked from Access. I have a combo box that is populated with the customer names from linked table. I want it set up so that when you select a customer it fills in their other information; address, phone, email, etc. I know how to do a vLooku...
I have an Excel 2007 file "my.xlsx" and a sheet named "States", and I have the following code using (OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\my.xlsx;Extended Properties='Excel 12.0 Xml;HDR=NO'")) { OleDbCommand cmd = new OleDbCommand("select * from [States]", con)...
I have like 3000 works in an excel cell that I need to search one word in. It does not highlight the word, it only places me into the cell with the word. Anybody has any idea how I can get the word highlighted that I am looking for? Thank you, Steve ...
I have a bunch of Excel.Name objects under Workbook.Names collection which contain invalid references. In other words, when I evaluate the Excel.Name.RefersTo property, I get a value back beginning with "=#REF...". I tried to run the following code but it seems to have no effect in removing the names: var ranges = myWorkBook.Names; for...