October 09, 2024, 04:34:54 PM

News:

IWBasic runs in Windows 11!


Reading an excel file

Started by Haim, November 17, 2007, 08:53:11 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Haim

Hello,
I read an excel file with the CDatabase class.
everything works fine, but I have these issue:

1. One of the columns may contain either a string or a number formatted as a number. Is ther a way to define the type in the bindvariable or getdata member functions to    something similar to VARIANT so that I always get a correct value?

2. I read the excel file in a loop, testing for get() returning null.
some excel files esult in many more lines read than actually are  there. (the last line being repeated...)
How can I overcome this?

Any helpp would be appreciated.

Haim