int main()
{
BookHandle book = xlCreateBook();
if(book)
{
if(xlBookLoad(book, L"example.xls"))
{
SheetHandle sheet = xlBookGetSheet(book, 0);
if(sheet)
{
double d;
const wchar_t* s = xlSheetReadStr(sheet, 2, 1, 0);
if(s) wprintf(L"%s\n", s);
d = xlSheetReadNum(sheet, 3, 1, 0);
printf("%g\n", d);
}
}
xlBookRelease(book);
}
printf("\nPress any key to exit...");
_getch();
return 0;
}
int main()
{
BookHandle book = xlCreateBook();
if(book)
{
if(xlBookLoad(book, "example.xls"))
{
SheetHandle sheet = xlBookGetSheet(book, 0);
if(sheet)
{
double d;
const char* s = xlSheetReadStr(sheet, 2, 1, 0);
if(s) printf("%s\n", s);
d = xlSheetReadNum(sheet, 3, 1, 0);
printf("%g\n", d);
}
}
xlBookRelease(book);
}
return 0;
}
static PyObject *
read_str(XLPySheet *self, PyObject *args)
{
const int row, col;
if(!PyArg_ParseTuple(args, "ii", &row, &col)) return NULL;
FormatHandle fmt = NULL;
const char *str = xlSheetReadStr(self->handler, row, col, &fmt);
if(!str) Py_RETURN_NONE;
if(!fmt) return Py_BuildValue("(sO)", str, Py_None);
XLPyFormat *obj = PyObject_New(XLPyFormat, &XLPyFormatType);
obj->handler = fmt;
return Py_BuildValue("(sO)", str, obj);
}
int main(int argc, char **argv)
{
SheetHandle sheet;
BookHandle book = xlCreateBook();
if (!book) return -1;
xlBookLoad(book, "example.xls");
sheet = xlBookGetSheet(book, 3);
int row = xlSheetLastRow(sheet);
int col = xlSheetLastCol(sheet);
int i = 0, j = 0;
char *str = NULL;
int num;
for (i = 0; i < row; i++) {
for (j = 0; j < col; j++) {
if (i != 0 && ( j == 0 || j == 4 || j == 5)) {
num = xlSheetReadNum(sheet, i, j, 0);
if (num > 0)
printf("%d ", num);
else printf(" ");
} else {
str = (char *)xlSheetReadStr(sheet, i, j, 0);
if (!str) {
} else {
printf("%s ", str);
}
}
}
printf("\n");
}
//xlSheetWriteNum(sheet, 1, 1, 1111, 0);
//xlBookSave(book, "example.xls");
xlBookRelease(book);
return 0;
}
