Excel Calculations and VBA
In the following Excel spreadsheet, I need to make the following calculations: Input Color Selected Output ------- -------------- -------- 40 red 40x18 40 blue 40x12 40 green 40x16 40 yellow 40x13 39 ...
excel
hiding an excel sheet
i have an excel spreadsheet with 3 tabs one of the tabs contains formulas for one of the other sheets and i was wondering if there is a way of hiding it?? ...
Creating tables for copy from Word to Excel
So, I needed to take some data done in MS Word tables, and manipulate in excel. I decided to get it from word to excel via a VBA subroutine to "save time". My source word document contained like twentysomething tables. I took my source document's tables, extracted my data and made a new document, with a new table, only needing me to ...
Printing Excel using Interop
Does anybody have any idea how to print an excel file programatically using C# and the Excel Interop? If so, can you please provide code? ...
Excel Chart Several Y values against one X Value
Hi, I have a multiple columns representing Y values each against a specific x value. I am doing a scatter plot. When plotting each series, I can easily select the y values as they are present in columns but the x value is constant for each column and I cant seem to figure out how to repeat a constant x value against several y column val...
Which regular expression is able to select excel column names in a formula in C#?
I'm nedding to implement excel formula autofill in C#. Let's suppose this formula is located at B100: =SUM($B$99:B99) I want to make this formula different at C100: =SUM($B$99:C99) This formula is only an example. Some real examples are: =(SUM($B${0}:B{0})/SUM({1}!$B${0}:{1}!B{0}) -1) =SUM(B{0}:B{1}) =B{0} + B{1} =C{0}+ B{1} ...
How to display a SQL Reporting Service report in Excel
Hi everyone, At the moment i am using VSTO to take a SQL Reporting Services report and display it in Excel 2003 using the ReportViewer control. So bascially on a winform hosted inside Excel. But i also need to be able to display it without the ReportViewer control i.e. just straight into the cells of my Excel sheet. I'm wonder how I s...
VSTO write to a cell in Excel!
Why does this work: ((Excel.Worksheet)Application.ActiveSheet).get_Range("A1", "A1").Value2 = text; But this doesn't: Excel.Worksheet activeSheet = ((Excel.Worksheet)Application.ActiveSheet); activeSheet.Cells[0, 0] = text; I need to do it the second way as I need to loop with rowIndex and colIndex. How can I do that? I get the er...
good way to represent a excel sheet value in Java
Consider that I've a excel sheet in below format: person age Foo 29 Bar 27 Now I want to read these values (using POI HSSF) and have to process them. What's the best way to do that? Note that I do not have a Object Person in my application, becasue the values that may come in excel sheet is arbitrary (i.e. it may not be the ...
Excel spreadsheet
I need a way of displaying 3 cells of data. For example Cell 1 Cell 2 Cell 3 20 140 Lee 12 110 Kerrie Whenever anyone's name is input in cell 3 I need a separate spreadsheet to display the name (cell 3) and the information in cells 1 & 2 (the information i...
How can an Excel Add-In respond to events in any worksheet?
Our workbooks are server-generated SpreadsheetML, which cannot include any VBA code. Creating native Excel files or Excel 2007 XML files is also not an option, unfortunately. So, I have an Excel Add-In (VBA, not XLL) that each of our users installs to add some extra UDFs, etc. that our workbooks need. This works great, but now I need t...
Problem with Excel to Gridview C# ASP.NET
Hi, I got 2 different EXCEL FILE (.xls).And there is a Column named "KATIP" in excel1.xls , and there is a column named "SAVCI" in excel2.xls.I wanna get this 2 column from excel1.xls and excel2.xls and merge themn into a table named "Nobet" with 2 column "SAVCI" and "KATIP". and show them in Gridview Control in ASP.NET .. I got working ...
Detecting Installed Excel Version (and Service Packs)
Hi all I need to be able to detect which version of Excel I have installed in my machine from some .NET code I'm developing. I'm currently using Application.Version for that, but it doesn't give me information about Service Packs. I would preferably to steer away from something like this: http://www.mvps.org/access/api/api0065.htm Ma...
Export to Excel Formatting
I have set up a basic html table with a reader in each cell (don't ask) that exports to excel, I also have a datagrid that exports to excel. Both work without issue in regards to actually creating the spreadsheet, but I have a question regarding formatting. Inside each cell is a list of names, i.e.: Bob Smith Jim Bob John Miller ...
Sort combobox values alphabetically
I have a combobox in a userform for excel. What is the easiest way to sort it alphabetically? The values for it are hardcoded in vba and new ones are just added to the bottom so they are not in any kind of order already. The userform is currently being used so that our users can import data from our database into excel. The combobox ...
Error handling in MS Excel VBA
Hi, I am having a bit of trouble with errors occurring in a loop in VBA. First, here is the code I am using dl = 20 For dnme = 1 To 3 Select Case dnme Case 1 drnme = kt + " 90" nme = "door90" drnme1 = nme Case 2 drnme = kt + " dec" nme = "door70" 'decorative glazed' Case 3 drnme = kt + " gl" nme = "door80" 'plain glazed' End Select On...
How to edit DsoFramer 1.3?
I'm using DsoFramer 1.3 in my project to hold Excel (2007) documents. But it have a big problem, that is: All the Excel documents opened by DsoFramer share only one Excel process. The result is when the second Excel document opened by the DsoFramer, the first document is uneditable. Even more, when I double click an Excel document in W...
Excel decimal rounding.
What is the excel function of rounding up the last decimal point? 9.23 => 9.25 10.26 => 10.30 9.25 => 9.25 ...
Reading date values from excel cell using POI HSSF API
I'm using POI HSSF API for my excel manipulations in Java. I've a date value "8/1/2009" in one of my excel cell and while I try to read this value using HSSF API, it detects the cell type as Numeric and returns the 'Double' value of my date. See the sample code below: cell = row.getCell(); // date in the cell '8/1/2009' switch (cell.get...
Description of DIF file format as used by Excel?
What is the layout of a DIF file, and, more importantly, what is the meaning of the different header and data fields in one? The Wikipedia article has enough information that I suspect this would be an easy-to-generate format that's richer than CSV. But I can't find a good enough description of this format to actually generate it. ...