Hi, I want the series names of the chart to display as the column names of my information. This works when I have more than 1 column however when there is only 1 column of information it seems to set the series name as the number 1. I reproduced this manually in Excel it seems to assume that the column name is the name of the chart. Th...
How do I sum from whats in B2 to C2 ? B2 = A10 or just 10 (preferred) C2 = A25 or just 25 (preferred) Normally you would just use SUM(A10:A25), but the values in B2 and C2 are not fixed, they change based on input. I can use MATCH to find the numbers, but how do I tell SUM to use those numbers ? The values to sum are always in the same...
I have the following situation in database: Department table holds all departments in the company. Employee table holds all employees, together with their department id and AllowedAbsenceDays field, which tells us how many days is the employee alowed to be absent in the current year. Absence table holds all absences that occur in the...
Anyone know of a way to see if the Excel window of a VSTO project is active/in focus? I'm looking for an equivalent of System.Windows.Window.IsActive. ...
A colleague of mine has an XML document which she opens in Excel 2007, using "Get External Data / From XML Data Import". Excel maps the XML to columns automatically. However, some elements store numerical data, which Excel refuses to treat as a number: <SOME_NUMBER>68.12</SOME_NUMBER> Instead, the cell shows the "number stored as tex...
I have a large dataset, say 1,000,000,000 rows, that lives on a server. I need a user to be able to consume (i.e. "run queries upon") that data seamlessly, over the web, from within Access and/or Excel. Additionally, I need to filter the data on the server-side according to the user connected to it. My current approach is to create a we...
Hi, I have a problem, I have to get the o/p in Excel of the report using Xml publisher, my report displays around 29 columns and those are not fiiting in the Word doc template(RTF) . So i need help like Is there any other method to design template eg Excel or anything which can accomodate all 29 columns and give o/p in Excel............ ...
My data starts in C9 and I want to reference every 18th row. For example (the referenced sheet is named Summer): =+Summer!C9 =+Summer!C27 =+Summer!C45 How can I get excel to recognize this pattern so I don't have to type it over and over? Thanks! ...
I have a fairly large Excel file. In this file there is a column with dates. I would like to know if/how it would be possible to make a program that would be able to read the date and post a notice 30 days in advance to Outlook Calendar or send out an email through Outlook in my office. Is there a decent API that I could use for this?...
Hi I need to build a local .cub file for my Excel-using clients. I have scrounged together some VB code but it fails : ConnLocation = "LOCATION=C:\test.cub;" ConnDSN = "SOURCE_DSN=DSN=TEST;UID=test;PWD=pass;" ConnCreateCube = _ "CREATECUBE=CREATE CUBE [TestCube] (" & _ "DIMENSION [account_code]);" Connection = CreateObject("ADODB.Con...
Excel's add-in named "Analysis ToolPak" provides "Yield" function for calculation of yield on security that pays periodic interest. Function works well and returns proper data. My understanding is function base on kind of iteration it is not so easy implement it in my code. My question is anybody know/seen implementation in C# (eventu...
Hi, I'm setting up some VBA in excel to compare two dates to see if they're the same. The problem I'm having is that after assigning the cell's variable to "ActualStartDate", it deletes everything from the cell. So "ActualStartDate" is assigned correctly, but deleted at the same time. Here's my code, any help would be fantastic. (this ...
Apparently Excel 4.0 is still used and I have to read it in Java. Neither poi nor jExcelAPI, as great as they are, can parse them. I can't find anything on them, especially with Java. Any help? Thank you. ...
I'm writing a CSV file. I need to write timestamps that are accurate at least to the second, and preferably to the millisecond. What's the best format for timestamps in a CSV file such that they can be parsed accurately and unambiguously by Excel with minimal user intervention? ...
how can i export my table to excel sheet in jsp?? ...
I have to build an analytic dashboard with Excel, and would like to know whether there is any chart library you would recommend. The charts should be attractive and easy to use by standard users. I've tried Microcharts, and they look very promising, but I'd like to evaluate more options before reaching a decision. Thanks a lot. ...
When updating an Excel file using OLEDB from C# I get the error "Data type mismatch in criteria expression" if the original file has a hidden PrefixCharacter (apostrophe in my case). If I remove the apostrophe from the cells in the original file, my application works as expected and the data is updated without any errors. Any suggestio...
Dear Ammo, A third party developer my boss has brought in, designed a "Better" System than our ASP.NET + MSSQL Server 2005 website we're using now. Here are the relevant specs: Excel + ODBC as the data store Built using old school ASP, not ASP.NET Is there any glaring problem with his solution short of the ancient tech? Thread saf...
Clever People, In Excel, it appears that wrapping an array formula in a SUM does not produce the sum of the contents of the array in all cases. (That is, it appears to me; clearly, I could well be confused.) This came up when trying to write the equivalent of an inner join in Excel. For reasons involving Excel for Mac, I'm doing this w...
Currently this macro is set up so that if Column G has “Last Term” and “Okay” or “Okay” and “Stay” next to each other 07a will be entered into the same row in Column I. I would like to modify this code so that If Column G contains “Last Term” and Column K contains “Okay” and “End” or “Okay” and “Stay” in any combination or in any order...