Board index » delphi » Exel&Word help

Exel&Word help

Hi all. i want to ask is there any components why can read Word or Exel
files and
... how i can work with Exel filesin Delphi program.
 

Re:Exel&Word help


I read somewhere that the easiest way to work with excel files was to export
them to access & connect to an access database

hope this helps

Quote
Emil Terziev wrote in message <388B59C1.5158...@hotmail.com>...
>Hi all. i want to ask is there any components why can read Word or Exel
>files and
>... how i can work with Exel filesin Delphi program.

Re:Exel&Word help


Hi Emil,

We can use CreateOleObject to access excel or work file from delphi (Ole
Automation).
With this you can create an instance of word or excel and you can access
them.

The below given piece of code will create a MSword instance from delphi and
will open a particular ms word file.

var
word:Variant;
begin
  Word := CreateOleObject('Word.Basic');
  Word.AppShow;
  Word.FileOpen('c:\temp\ole.dot');
  Word.FileSaveAs('c:\temp\word2.doc');
end;
I have an example .. Incase you want me to send the code, I can do it.

Apart from this, I think you can achieve this using DDE too. (these are set
of standard components)

Quote
Emil Terziev <emo...@hotmail.com> wrote in message

news:388B59C1.5158348@hotmail.com...
Quote
> Hi all. i want to ask is there any components why can read Word or Exel
> files and
> ... how i can work with Exel filesin Delphi program.

Re:Exel&Word help


I happened to stumble on the following:
Creating a Microsoft Excel Spreadsheet Viewer Using Delphi 5's ADOExpress
Scott Strool, of Inprise Corporation, shows how you can use Delphi 5's new
ADO (ActiveX Data Objects) Express to access a Microsoft Excel spreadsheet.
http://community.borland.com/article/0,1410,20066,00.html
Quote
"Vanitha" <v...@yahoo.com> wrote in message

news:86glvu$m3i9@bornews.borland.com...
Quote

> Hi Emil,

> We can use CreateOleObject to access excel or work file from delphi (Ole
> Automation).
> With this you can create an instance of word or excel and you can access
> them.

> The below given piece of code will create a MSword instance from delphi
and
> will open a particular ms word file.

> var
> word:Variant;
> begin
>   Word := CreateOleObject('Word.Basic');
>   Word.AppShow;
>   Word.FileOpen('c:\temp\ole.dot');
>   Word.FileSaveAs('c:\temp\word2.doc');
> end;
> I have an example .. Incase you want me to send the code, I can do it.

> Apart from this, I think you can achieve this using DDE too. (these are
set
> of standard components)

> Emil Terziev <emo...@hotmail.com> wrote in message
> news:388B59C1.5158348@hotmail.com...
> > Hi all. i want to ask is there any components why can read Word or Exel
> > files and
> > ... how i can work with Exel filesin Delphi program.

Re:Exel&Word help


EXCEL read also easy the DBF files and D4 also
JAck

Delphi Learner a crit :

Quote
> I read somewhere that the easiest way to work with excel files was to export
> them to access & connect to an access database

> hope this helps

> Emil Terziev wrote in message <388B59C1.5158...@hotmail.com>...
> >Hi all. i want to ask is there any components why can read Word or Exel
> >files and
> >... how i can work with Exel filesin Delphi program.

  tenessee.vcf
< 1K Download

Other Threads