December 01, 2024, 11:18:51 AM

News:

Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........


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