C++ :: Excel XLL Returns Different Results?

Feb 1, 2015

I am using Excel 2013, Visual Studio 2015. I began learning about Excel XLL. I wrote simple function which tests whether the argument is missing. Here's code:

#define DllExport __declspec(dllexport)
static LPWSTR rgFuncs[1][7] = { { L"GetSum", L"BU", L"GetSum" } };
DllExport double WINAPI GetSum(LPXLOPER12 arg)
{
if (arg->xltype == xltypeMissing) return -1;
return arg->xltype;
}

This code works as expected: if I miss argument, it gives me -1, and the type otherwise. But when I change code to this:

DllExport double WINAPI GetSum(LPXLOPER12 arg)
{
return (arg->xltype == xltypeMissing) ? -1 : arg->xltype;
}

then, when I miss argument, it gives me 4294967295. Why?

View 2 Replies


ADVERTISEMENT

C Sharp :: Filter Excel Sheets Through C# While Importing Excel Data To Database?

Mar 1, 2013

private String[] GetExcelSheetNames(string excelFile) {  
             OleDbConnection objConn = null;
             SqlConnection objSqlConn = null;
             System.Data.DataTable dt = null;  
             try {

[code].....

Now I can fatch all the excel sheet belongs to the Excel File.But How can I check "If and Only If the sheets are havin Underscore in their name(eg. student_data,teachers_data) then only the data of the sheets will populate in tha data base"

View 2 Replies View Related

C++ :: Getting Too Big Of Numbers On Returns

Feb 7, 2013

I am trying to get each step down before proceeding to the next one for my problem. I have started my program into returning the Area and Volume of a cylinder. The return numbers I get are huge and I cannot figure out why.My header file

class cylinderType {
public:
void getRadius(double rad);
void getHeight(double heigh);
double area();
double volume();

[code]....

View 17 Replies View Related

C :: Function That Returns A Char

Sep 4, 2013

I have a function that returns a char*. No problem. But I need to concatenate another array with the results of this function. I'm getting a segmentation error.

Code:

//this next line outputs correctly so I know my function is working
fprintf(stdout, "%s
", get_filename(selection));
char* temp;

[Code].....

View 11 Replies View Related

C++ :: Functions With Void Returns?

Nov 27, 2014

Write a C++ program consisting of main plus two other functions which will do the following:

Take an integer input from the keyboard.

Send the integer to a function which will output the integer to the screen.

Send the integer to a second function which will tell the user that the integer is an odd value.

Do not tell the user anything if the integer is an even value.

Repeat this process until the user enters something which is not an integer; use input validation to check for validity.

Any not valid input should terminate the program.

View 3 Replies View Related

C++ :: Minesweeper - Function Always Returns The Same

Jun 24, 2013

For a Homework i need to make some kind of Minesweeper but i have one Probleme one of my functions always return teh same and i cannot fin out why here is the code:

bool setzen(int x, int y){
if(feld[x][y]!=3){
return mine=false;
}

[Code]....

Thats the Part where Everything happens but the Function "bool setzen" always returns false and i dont know why.

View 6 Replies View Related

C/C++ :: Prime Factorization Returns No Value

Feb 27, 2014

So, I have been working my way through lines of code, and practicing quite a bit. In fact, I have done programs far more complicated than this and still I cannot get it to work.

The idea of the code is to take a number input by the user through the terminal and check if it is a prime number(It does this) If the number is not prime it takes that number and checks for N amount of primes that is put in through the console. When a prime is found it writes that to the console until the N amount of primes have been found.

#include <iostream>
using namespace std;
int prime(unsigned long long x);
int main() {
long long x;
long long y;
long long z;

[Code] ....

At least that's my goal. Currently it will accept the number and check if it is prime. It will then ask for the N amount of primes but will not return any primes. I have check with numbers a I know have prime factors. I have added the comment //XXXXXXXX To show where the problem appears to occur.

View 1 Replies View Related

C++ :: How To Use Function That Returns Vector

Oct 7, 2014

How can I show elements of a vector that is returned by a function in main() ?

Code:
vector<int> merge_sorted(vector<int> a, vector<int> b){
vector<int>temp;
int count = 0;
if(a.size() < b.size()) count = a.size();
else count = b.size();

[Code] .....

View 12 Replies View Related

C++ :: Time Measurement Returns Negative Value

Oct 9, 2013

I am using the first method, listed here.

I want to take the time measurement of a construction of a tree, which contains about 2841482 nodes (inner and leaves). Here it is:

Code:
struct timespec start, end;
clock_gettime(CLOCK_MONOTONIC, &start);
Tree t(...);

clock_gettime(CLOCK_MONOTONIC, &end);

int64_t time;
time = timespecDiff(&end, &start);
std::cout<<"Time: " << time << " ns

"; which gives me always a negative value, like -13481628 ns.

View 9 Replies View Related

C :: Writing A Macro That Returns A Boolean Value

Apr 24, 2014

I need writing a macro that would return true/false (1/0) )value. I want to check if a certain element exists in the array. The macro will accept array, its size, and the value to be compared, and must return yes or no. Here is the code that I have written:

Code:
#define EXISTS(T, a, n, val) do {
char ret=0;
T *a_ = (a);
size_t n_ = (n);
for (; n_ > 0; --n_, ++a_){
ret = (*a_ == val);
}
}
while(0)

How can I get the result from this macro.

View 6 Replies View Related

C :: Function That Returns ARRAY And Its SIZE?

Dec 24, 2013

to return the array i shall make a pointer function thats ok.. but how do I get the size return if i dont know the size?

if I need to make AXB=C and output C my new array doesnt have a size..

View 7 Replies View Related

C++ :: Cin Input Validation Returns Wrong

Jul 11, 2014

I have this function that is supposed to take a float as a parameter and then call the getLine() method to accept the users input. The function basically just checks to see if what the user input was of the same data type, if it is it returns the input value, if not then it keeps looping through taking new input until its correct. The problem is no matter what number you put in the output always returns as 140734799803512.

float InputValidation(){
float num;
string strInput;
while (true){
getline(cin, strInput);

[Code] ....

You also need to include <string> and <sstream>.

View 3 Replies View Related

C++ :: Function That Returns Integer Value And Displays It

Mar 8, 2013

Is it possible to create a function that can both return and display a value. I was trying to make a program that computes and prints terms of the Fibonacci series using a recursive function.

View 3 Replies View Related

C++ :: Function Returns Values After Loop Done

May 15, 2013

I am writing a program with a function that includes a long loop. I need this function to return a value when each loop is done, to send this value to output, in order to follow the progression. But I don't know how to do it in easy way. The function is like follow:

int goC(){
... // some local value definition
for(int i = 0; i < 1000; i++){
... // a lot of calculations done here
return i; // -> return the value after each loop is done
}
}

Here it only returns one value, i = 0. Clearly it's wrong.

View 10 Replies View Related

C/C++ :: Comparison Of Excel And CSV

Mar 6, 2012

I have to compare data in excel and csv based on the file name and update the status of file from CSV into excel file by creating a new column status on weekly basis.

View 1 Replies View Related

Visual C++ :: How To Use C# With Excel

Jan 2, 2013

Is it possible to create an app that can be saved on my desktop that can be used with an excel file that is saved on my desktop? I have opened VS 2010 and I have created a form design that has a button for every sheet name in my excel file. All of the sheet names are hidden with the exception of one. When a button is pressed on the c# form, I would like for that sheet to be shown in excel. Then once the updates have been made to that sheet in excel, I want a button to be at the top of the excel worksheet that will hide that worksheet again and return to the form c# form...can that be done?

View 2 Replies View Related

C :: Loops That Would Generate Same Results

Nov 20, 2013

Using loops that would generate the same results. I need to use a loop that would make the syntax less lengthy ....

Code:
#define _CRT_SECURE_NO_WARNINGS
#include<stdio.h>
#include<iostream>

float check(float s);
void load(float*);

[Code] .....

View 2 Replies View Related

C++ :: How To Do Operation Of Two Integers That Gives Results

Feb 25, 2014

How do I do the operation of two integers that gives you the results?

I'm supposed to write a program that:

Asks the user for an integer
Asks the user for one of '+', '-', '*', or '/' (as a character)
Asks the user for another integer
Performs the given operation on the two integers, and prints out the result of

Please enter an integer: 4
Please enter an operation (+, - , *, /): *
Please enter another integer: 5

4 * 5 = 20

Code:
#include <iostream>
using namespace std;
int main() {
int x;
int c;
int d;
char e;

[Code] ....

View 7 Replies View Related

C++ :: How To Pause After Outputting Results

Feb 19, 2013

I mean on the executable file. It just displays the results and quickly flashes away, cin.get() has no effect and system("PAUSE") is undeclared.

I never found a single sure way to pause effectively. Is there a method that works all the time? Sometimes cin.get() gets skipped even in the code itself. The IDE I am using is Code Blocks if that matters any.

View 4 Replies View Related

C++ :: Console App - Outfile Results

Aug 5, 2013

I have created a game that functions correctly, however, for balancing and future changes, I would like to record results .txt document (its 1v1 btw). I already have code to determine who won and what I am looking for is some way to keep track of different match-ups for the different characters. Im looking for something like this:

loser
Winner char1 char2 char3
char1 3 2 5
char2 2 5 4
char3 8 1 2

the numbers are the amounts of wins a given character has over another character. I'm looking for code to open the .txt file and add 1 to the respective win total so I can do balance changes and such.

View 1 Replies View Related

C++ :: Adding Results Of Incremented Value?

May 11, 2013

The point of this program is to calculate how many cents the user would have after a certain number of days. The user is given .01 cent on day one, and this amount is doubled with each passing day. I cannot seem to figure out how to add all of the results. Currently, my program simply outputs them to the screen. How do I tell it to add all of the results and store the sum in one variable?

#include <iostream>
#include <cmath>
#include <iomanip>
int main() {
using namespace std;
float totalF = 0;//total amount earned after number of days specified by user have passed

[code]....

View 9 Replies View Related

C++ :: Can't Total Up The Results Calculated

Apr 8, 2013

i am doing a sales commission program to run a counter on the commission calculated, but the answers can't show on the counter

here's what i've done so far:
#include <iostream>
#include <iomanip>
#include <cmath>

[Code].....

View 2 Replies View Related

C# :: Unable To Get All YouTube Results (API 2.0)

Nov 5, 2014

I'm using below code snippet to fetch Youtube video titles, when you enter a query into a listbox, and press the search button:

int resultsn = 0;
void YTReq(string appname)
{
devkey = "my-dev-key-here";
YouTubeRequestSettings settings = new YouTubeRequestSettings(appname, devkey);
request = new YouTubeRequest(settings);

[code].....

But what i get is exactly 500 results, even if i remove the 500 search limit radio-button (i've put that later, after seeing that the search only fetches 500 results). But when i search the same query on YT, i get 1000s of results. What's the wrong with my code?

[URL] .....

View 9 Replies View Related

C# :: Perform Web Request And Get Results?

Sep 17, 2014

Here is the site that I want to interact Genderchecker

I want to set a value to a specific element in a web site. Perform a click on an element that is image. Get the result <span> text into string variable...

What should I use ?

View 2 Replies View Related

C# :: (NET) Interpreting Profiler Results?

Oct 1, 2014

I am nearing completion of my first real app.. but I noticed a nasty catch in that it consumes 10-20% CPU at idle. I went around commenting features that I suspected may be causing it but it had 0 impact and my CPU usage at idle is still 10-20%.

The program has two threads, one of which is used very little and the second one consume needless CPU.. The only clues a profiler gives me is

MS.Internal.Text.TextInterface.Generics.NativeIUnkownWrapper<MS::Internal::Text::TextInterface::Native::IDWriteFont>...

But the process which takes up all the CPU seems to change every time I start the profiler. Sometimes it is WindowProc or ThreadingProc..

Can how I interpret this and make meaningful changes to how my code runs?

View 3 Replies View Related

C :: Program That Returns Pascal Triangle Of N Rows

Nov 25, 2013

I need to make a program that returns pascal's triangle of N rows. I actually need to make a function of format "int **func(int n)". I don't know how to go about that, so I am trying this method first, but I seem to be getting an endless loop.

Code:
#include <stdlib.h>#include <stdio.h>
int *rowN(int rowNum, int* prevRow) {
int *rowN;
rowN=realloc(rowN,(rowNum+1)*sizeof(int));

[Code] ....

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved