Link to home
Start Free TrialLog in
Avatar of wcoka
wcoka

asked on

how to read cell values from an excel file?

how to read cell values from an excel file if I dont have excel installed in the machine?
Avatar of Ark
Ark
Flag of Russian Federation image

You mean that you also haven't Microsoft Excel X.0 Object Library?

Cheers
Avatar of wcoka
wcoka

ASKER

The only condition is that I wont have Microsof Excel in the machine that uses the program...
hi
There are some ways to do this:
1. Using DAO or ADO with ODBC or Jet engines - they can easy translate Excell into any db fromat
https://www.experts-exchange.com/jsp/qShow.jsp?qid=11444179
2. Using native excell BIFF format
http://www.vb-helper.com/HowTo/excel.zip

Cheers
ASKER CERTIFIED SOLUTION
Avatar of Ark
Ark
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wcoka

ASKER

Ark, I have Excel Xp installed in my machine but the machines that will use the software, wont have it. If I use that Microsoft Excel X.0 Object Library, and make the setup with Installshield, would it work anyway?
I agree with Ark about using DAO or ADO. It is the good way reading a it. You can read named arguments in it by creating a WHERE sql string. And it is also possible to use data control to read an Excel file.

suat
To use Excel library, be sure that you added Excel olb file to package to distribute.

suat
Hi
Donno about InstallShield if it collect all nesessary files. Make first setup with PDW (or Setup Wizard for VB5), check files you need and then make setup with InstallShield.
DAO or ADO is universal solution, though it increase setup package with 3-5M sometimes unnesesary files.

Cheesr
listening...
Any resolution wcoka?
wcoka,

Could you please come back to close this question or ask for more if you need more information (actually there is no more necessary info but may be...) to just keep clean this topic?

regards
suat