|
Hi,
I am using eclipse IDE with MinGw installed. I copied all the libxl C libraries into the C:\MinGw\include but when I try to compile the program, I get the below errors :
D:\Faez\Software & Download\ExcelFilePgm\Debug/../MyFirstExcelFile.c:14: undefined reference to `xlCreateBookCA'
D:\Faez\Software & Download\ExcelFilePgm\Debug/../MyFirstExcelFile.c:17: undefined reference to `xlBookAddSheetA'
D:\Faez\Software & Download\ExcelFilePgm\Debug/../MyFirstExcelFile.c:20: undefined reference to `xlSheetWriteStrA'
D:\Faez\Software & Download\ExcelFilePgm\Debug/../MyFirstExcelFile.c:21: undefined reference to `xlSheetWriteNumA'
D:\Faez\Software & Download\ExcelFilePgm\Debug/../MyFirstExcelFile.c:23: undefined reference to `xlBookSaveA'
D:\Faez\Software & Download\ExcelFilePgm\Debug/../MyFirstExcelFile.c:24: undefined reference to `xlBookReleaseA'
collect2: ld returned 1 exit status
Build error occurred, build is stopped
Time consumed: 515 ms.
Here is the program I am trying to compile:
#include <stdio.h>
#include <libxl.h>int main()
{
BookHandle book = xlCreateBook(); // xlCreateXMLBook()
if(book)
{
SheetHandle sheet = xlBookAddSheet(book, L"Sheet1", 0);
if(sheet)
{
xlSheetWriteStr(sheet, 2, 1, L"Hello, World !", NULL);
xlSheetWriteNum(sheet, 3, 1, 1000, NULL);
}
xlBookSave(book, L"example.xls");
xlBookRelease(book);
}
return 0;
}
Thanks,
Faez
|
|
|
|
|
Where did you copy the .lib files, and have you added that location to your LIB environment variable or project settings?
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
I have copied the libxl.lib file to the the path C:\MinGW\lib
Also, I set the LIB environment varible to the same path as above
Alternately I tried adding the Library path in the project under Library tab
But all in vain. 
|
|
|
|
|
You must add the LibXL libraries to your project so that they can be linked. How to do this depends on your project management. If it uses a make file, they must be added there.
|
|
|
|
|
Can you tell me the procedure of eiditing the make file respectivelive please..
I have copied the libxl.lib file to the the path C:\MinGW\lib
Also, I set the LIB environment varible to the same path as above
Alternately I tried adding the Library path in the project under Library tab
But all in vain.
|
|
|
|
|
I don't use the Eclipse / MinGW combination. If you have a make file, you may post it here provided it contains only a few lines (otherwise post just the relevant lines containing 'LIB' and the final build/link command).
Copying the library to a specfic path and adding that path to the LIB environment variable is the correct way. But you must also add the library file name to your project. With Linux make files, this can be done using LDLIBS = -llibxl -l<other-lib>.
|
|
|
|
|
Any idea why error says "undefined reference to `xlCreateBookCA' " when I am calling the xlCreateBook() function..?
|
|
|
|
|
Faez Shingeri wrote: Any idea why error says "undefined reference to `xlCreateBookCA' " when I am calling the xlCreateBook() function..?
Yes. It is because the linker ld (see at end of output from your initial question) did not find the function xlCreateBookCA in any of your source files or the specified libraries.
Where and how did you add the library name to your project make file? Note that the library names must be specified without the .lib extension.
|
|
|
|
|
THANKS A ZILLION Jochen....! 
It worked like a charm.... I was giving the .lib extension...
ur AMAZING...! u made my day..
Thanks again
|
|
|
|
|
Hi,
Could you tell me how to use a variable declared in a function, which is in another file..
Example:
There is a function named as below whose declaration is present in a header file named "SheetW.h"
const wchar_t* xlSheetReadStr(SheetHandle handle, int row, int col, FormatHandle* format);
Now, how do I use the "row" variable in my main file..?
I tried
1)extern int row; //did not work....
2)extern "C" func-name(); //this too did not work..
Thanks,
Faez
|
|
|
|
|
row is not a variable, it is a parameter of the function, that must be passed. In the above function, it specifies the row number of the cell which content should be read. You will typically pass a local variable (e.g. when retrieving data from within a loop), or pass a fixed number like '1'.
|
|
|
|
|
Hi,
Is there a way by which I can add a ".txt" extension to a filename that I have recieved from a a variable as below..?
const wchar_t* s = xlSheetReadStr(sheet, firstRow+1, 5, NULL);
's' contains a value say "ABC"... I gotta rename it to ABC.txt.... to perform file operations on that file (ABC.txt)..
Thanks,
Faez
|
|
|
|
|
You must create a copy of the string and append the extension. There are several ways to do this:
wchar_t lpszFileName[_MAX_PATH];
wcscpy(lpszFileName, s);
wcscat(lpszFileName, L".txt");
swprintf(lpszFileName, _MAX_PATH, L"%s.txt", s);
std::wstring wstr(s);
wstr += L".txt";
CStringW strFileName;
strFileName.Format(L"%s.txt", s);
This question shows me that you are an absolute beginner to C/C++. This is not a problem. We all were beginners once. But I recommend not to start with a rather complex program using an external library to read Excel files. You should get a good book or tutorial for C++ beginners and work trough it before writing such programs.
|
|
|
|
|
I am really a beginner to C programming Jochen...
I really gotta sitback and build my basics first... Any suggestions for this C beginner..?
BTW... when I tried using the above suggested wchar functions, the code crashes and I get an error saying "An unhandled Win32 exception occured "......
|
|
|
|
|
There a many books and online tutorials, but I don't know which are best for beginners. See here [^] for some books and here [^] for an online tutorial (also available as PDF). If English is not your first language, you may look for tutorials in your native language. Just search for "C++ beginners tutorial".
You should pick only one of the functions (the swprintf example requires the wchar_t lpszFileName variable). A possible error may be a buffer overflow when your file name is longer than _MAX_PATH. To avoid buffer size problems, use std::string or CString.
|
|
|
|
|
I was unable to use any of the above functionality because I didn't have the <wcstr.h> header file in my MinGW.
What i did was, I copied the the acquired const string value into a file and then read it again by storing it in a new variable as below
char* dclColEle[10];
After getting such four column values, I am not able to individually access the dclColEle[0], dclColEle[1], dclColEle[3] values... i get junk or no values when i try to access them..
|
|
|
|
|
Faez Shingeri wrote: I was unable to use any of the above functionality because I didn't have the <wcstr.h> header file in my MinGW.
When using MinGW, use strcpy() and strcat(), or snprintf(). Use PATH_MAX instead of _MAX_PATH. Required include files are stdio.h, stdlib.h, and string.h.
Faez Shingeri wrote: char* dclColEle[10];
This creates an array with 10 elements where each element is a pointer to char. I assume, that this is definitely not what you want.
|
|
|
|
|
|
Your questions are no longer related to the initial topic. I suggest you should create a new topic here in the C/C++ forum or in the Q&A section.
When doing so, much more people will read it and may answer.
|
|
|
|
|
Hello Friends
I am creating an application in which I have to read XML File. That XML file is having different types of nodes and Data stored in it.
I an creating a separate class for each node to read its data and subnodes.
I want a component based structure for class tht I dont need to initialize each node class object everytime.It must be Inherited from one main XML class and all other component class should implement their virtual fn.
Any Structure Idea for this Design.
Thanks In Advance.
Regards
Yogesh
|
|
|
|
|
try factory pattern and it's variant
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and You
|
|
|
|
|
Hi,
I have a twofolded question
If I want text on a new line when using Streamin Callback Function for a Rich Edit control I insert a carriage return line feed at the end of the buffer correct ?
and if yes I have the following code which doesn't seem to work
LPBYTE holdptr1, pbBuff;
CString buffer;
strcpy((char *)pbBuff," ");
holdptr1 = pbBuff + 2;
memcpy(holdptr1,buffer.GetBuffer(121),121);
holdptr1 = holdptr1 + 121;
memcpy(holdptr1,"\r\n",2);
*pcb = 125;
|
|
|
|
|
You've declared these pointers, but you haven't allocated any memory for them to point to:
LPBYTE holdptr1, pbBuff;
Another probable error is that you are changing what holdptr1 is pointing to by adding to it:
holdptr1 = holdptr1 + 121;
After seeing this post and some of your previous posts, I can say that you need to study how pointers work. You'll never be able to write code in C/C++ until you fully understand them.
You should find a tutorial or a book that you like, and study it.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
In addition to the other Richard's comments, you should not use fixed value offsets in this way; it will lead to pain and tears very quickly.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Hi,
We issue Software licences on the basis of the Hardware Serial Number and Manufacturers Data stored in the Hard Disk Firmware of the primary disk that our Sotfware is stored on. My Step grandson was interested in learning the operational aspects of the App, so I tried to install it on his notepad. The Licence Aspect Failed, because our Standard Detection Software could not find a Physical Device for Drive 'C:\'
I am not aware of any licensing issues Microsoft had when releasing this version of Windows7 Does anyone know how to obtain similar Machine Identification Data on this type of hardware, that can be used for licencing purposes.
Regards,
Bram van Kampen
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
