 |  |  |  |  |  |  |  |
Visual & Excel without referencing Excel???
 |
Does anyone know?, how can i edit an excel file from visual basic, but without installing excel?
Actually, i know how to create or modify an excel document with code in visual basic, but is necessary add a reference to the excel's object library in the project. the trouble is: if the computer where would reside my application doesn't have excel installed, my application wouldn't work properly...
so that, could anyone help me out to find another way, to create or edit an excel document?... or does anyone know how to process a excel file without the excel's object library??
please help ·´_´
Actually, i know how to create or modify an excel document with code in visual basic, but is necessary add a reference to the excel's object library in the project. the trouble is: if the computer where would reside my application doesn't have excel installed, my application wouldn't work properly...
so that, could anyone help me out to find another way, to create or edit an excel document?... or does anyone know how to process a excel file without the excel's object library??
please help ·´_´
Last edited by z9maar; Jul 18th, 2007 at 11:32 am.
How can you edit an excel file without having excell installed. No way. But there is a way arround.
First your program should check whether excel is installed or not. If installed take the normal course for creation editing etc. If not installed, take another course in you program for creation of a text file (if already created in an earlier run, Append,update etc ),with delimiters corressponding to columns and lines as raws. Later when installed you can check the existence of this text file and convert it to excel file and the earlier one deleted.
It is really a very brilliant task.
If you have the patience and a Will, get back to me. I will explain to you the details. For the time being, warn the User that your program required excel to be installed and exit.
Happy Programming
regards
AV Manoharan
First your program should check whether excel is installed or not. If installed take the normal course for creation editing etc. If not installed, take another course in you program for creation of a text file (if already created in an earlier run, Append,update etc ),with delimiters corressponding to columns and lines as raws. Later when installed you can check the existence of this text file and convert it to excel file and the earlier one deleted.
It is really a very brilliant task.
If you have the patience and a Will, get back to me. I will explain to you the details. For the time being, warn the User that your program required excel to be installed and exit.
Happy Programming
regards
AV Manoharan
when u create the set up using package and deployment wizard , it will automaticall include all the .dll ,.ocx and other required files with the set up. All these files will be installed in the target system at the time of installation. So it is not necessary to install Excel in that system. your application will work fine.
But the only problem is u will not get an Excel file to work on.
But the only problem is u will not get an Excel file to work on.
Share your Knowledge.
•
•
•
•
Originally Posted by AV Manoharan 
How can you edit an excel file without having excell installed. No way. But there is a way arround.
First your program should check whether excel is installed or not. If installed take the normal course for creation editing etc. If not installed, take another course in you program for creation of a text file (if already created in an earlier run, Append,update etc ),with delimiters corressponding to columns and lines as raws. Later when installed you can check the existence of this text file and convert it to excel file and the earlier one deleted.
It is really a very brilliant task.
If you have the patience and a Will, get back to me. I will explain to you the details. For the time being, warn the User that your program required excel to be installed and exit.
Happy Programming
regards
AV Manoharan
There are some visors, wich are used to see and edit the excel content of a file, so... i want the program to create the excel reports, without the need of have excel installed in the computer.
If i use text or csv files (..or something like that), maybe i couldn't give to the user reports with the optimal format, and also the report may not be read for any visor for excel...
That's why i'm looking for one way to create a excel file without have excel installed.
•
•
•
•
Originally Posted by debasisdas
when u create the set up using package and deployment wizard , it will automaticall include all the .dll ,.ocx and other required files with the set up. All these files will be installed in the target system at the time of installation. So it is not necessary to install Excel in that system. your application will work fine.
But the only problem is u will not get an Excel file to work on.
When you have a reference to another application, you only take the name of the 'exe' file ("EXCEL.EXE" in this case) but excel needs lots of other files to work, not only that one file, and you must include all required files for excel into your setup too, and also register some codes that excel needs, and the license, etc... so that, anyway you need excel installed as in the development computer as in the final computer...
That's what i've learned while using excel in my applications...
he he •
•
•
•
Originally Posted by z9maar
ok, i want to use this to create a report, but i need to put colors in the cells, and to merge some cells too, ... so things i can only do with excel...
There are some visors, wich are used to see and edit the excel content of a file, so... i want the program to create the excel reports, without the need of have excel installed in the computer.
If i use text or csv files (..or something like that), maybe i couldn't give to the user reports with the optimal format, and also the report may not be read for any visor for excel...
That's why i'm looking for one way to create a excel file without have excel installed.
Last edited by AV Manoharan; Jul 21st, 2007 at 1:32 am.
If u want to use features of excel or handle wilr excel fiels any way u need to include the components in your development system.
Else there is only option left for you as AV said i need to write all that by your self if u can.
and I will also purchase that product from u with full license.
Else there is only option left for you as AV said i need to write all that by your self if u can.
and I will also purchase that product from u with full license.
Last edited by debasisdas; Jul 21st, 2007 at 2:01 am.
Share your Knowledge.
|
Similar Threads
- Need help with VB & Excel data transferring (Visual Basic 4 / 5 / 6)
- please help! vb6 & excel (Visual Basic 4 / 5 / 6)
- Visual C++ and Excel (C++)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: VB6 help
- Next Thread: development of traffic/bandwidth monitoring tool using VB
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
