467,116 Members | 1,190 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

Using Excel components

Can I make an Excel file without having Excel in my PC ?
I want to create Excel files from my C# application , then open those files
later in another PC who have Excel installed .
As we can open and read from Access files in C# application without having
Access in this PC in this case we install MDAC , Is there any thing similar
to MDAC for Excel ? if yes where can I download it ? what is the name of the
file ?
Nov 17 '05 #1
  • viewed: 6294
Share:
9 Replies
Yosi,

You might be able to use the Text provider (which should be included in
MDAC). However, I don't believe it will give you any fine-grained control
in formatting the sheets. Rather, it would most likely just allow you
insert data into the sheet in a tabular format. You will have to use the
classes in the System.Data.OleDb namespace to do this.

You might also want to consider creating a CSV file (comma-delimited),
which Excel can easily read.

Finally, if you know that the version of Excel that is being used is XP
or 2003, then you can create an XML file which adheres to a XML Schema for
office documents (you can find this on the MS site, I believe) which will
allow you to specify all of the formatting, data, formulas, etc, etc.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
Can I make an Excel file without having Excel in my PC ?
I want to create Excel files from my C# application , then open those
files
later in another PC who have Excel installed .
As we can open and read from Access files in C# application without having
Access in this PC in this case we install MDAC , Is there any thing
similar
to MDAC for Excel ? if yes where can I download it ? what is the name of
the
file ?

Nov 17 '05 #2
How about using the excel object library in your applications. I believe
they are just regular assemblies that provide excel functionality.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
Can I make an Excel file without having Excel in my PC ?
I want to create Excel files from my C# application , then open those
files
later in another PC who have Excel installed .
As we can open and read from Access files in C# application without having
Access in this PC in this case we install MDAC , Is there any thing
similar
to MDAC for Excel ? if yes where can I download it ? what is the name of
the
file ?

Nov 17 '05 #3
How , where to find such an object library or/and examples ?

"Alvin Bruney [MVP - ASP.NET]" wrote:
How about using the excel object library in your applications. I believe
they are just regular assemblies that provide excel functionality.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
Can I make an Excel file without having Excel in my PC ?
I want to create Excel files from my C# application , then open those
files
later in another PC who have Excel installed .
As we can open and read from Access files in C# application without having
Access in this PC in this case we install MDAC , Is there any thing
similar
to MDAC for Excel ? if yes where can I download it ? what is the name of
the
file ?


Nov 17 '05 #4
No the object model is part of the excel.exe, which is THE COM automation
server.

Willy.

"Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
How about using the excel object library in your applications. I believe
they are just regular assemblies that provide excel functionality.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
Can I make an Excel file without having Excel in my PC ?
I want to create Excel files from my C# application , then open those
files
later in another PC who have Excel installed .
As we can open and read from Access files in C# application without
having
Access in this PC in this case we install MDAC , Is there any thing
similar
to MDAC for Excel ? if yes where can I download it ? what is the name of
the
file ?


Nov 17 '05 #5
You can't, the object model is part of excel.exe (and it's dependencies).
The only thing you can do is as Nicholas told you, get some limitted support
for this through MDAC and the oledb text provider, you can find a sample
here: http://www.codeproject.com/csharp/Excel_using_OLEDB.asp

Willy.
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:46**********************************@microsof t.com...
How , where to find such an object library or/and examples ?

"Alvin Bruney [MVP - ASP.NET]" wrote:
How about using the excel object library in your applications. I believe
they are just regular assemblies that provide excel functionality.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
> Can I make an Excel file without having Excel in my PC ?
> I want to create Excel files from my C# application , then open those
> files
> later in another PC who have Excel installed .
> As we can open and read from Access files in C# application without
> having
> Access in this PC in this case we install MDAC , Is there any thing
> similar
> to MDAC for Excel ? if yes where can I download it ? what is the name
> of
> the
> file ?


Nov 17 '05 #6
>The only thing you can do is...
nope,
the Office Web Components contains COM servers that are NOT part of the
excel.exe. However, it requires a separate download and installation to make
it work which is more of a burden than a cure IMO.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:ew**************@TK2MSFTNGP14.phx.gbl...
You can't, the object model is part of excel.exe (and it's dependencies).
The only thing you can do is as Nicholas told you, get some limitted
support for this through MDAC and the oledb text provider, you can find a
sample here: http://www.codeproject.com/csharp/Excel_using_OLEDB.asp

Willy.
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:46**********************************@microsof t.com...
How , where to find such an object library or/and examples ?

"Alvin Bruney [MVP - ASP.NET]" wrote:
How about using the excel object library in your applications. I believe
they are just regular assemblies that provide excel functionality.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
> Can I make an Excel file without having Excel in my PC ?
> I want to create Excel files from my C# application , then open those
> files
> later in another PC who have Excel installed .
> As we can open and read from Access files in C# application without
> having
> Access in this PC in this case we install MDAC , Is there any thing
> similar
> to MDAC for Excel ? if yes where can I download it ? what is the name
> of
> the
> file ?


Nov 17 '05 #7
But they don't offer Excel functionality, they are simple COM components
that are used to present Charts, Pivot tables, and stuf to the web, with
data possibly taken from existing Workbooks and Sheets, but they don't offer
any possibility to create/update sheets.

Willy.

"Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
The only thing you can do is...

nope,
the Office Web Components contains COM servers that are NOT part of the
excel.exe. However, it requires a separate download and installation to
make it work which is more of a burden than a cure IMO.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:ew**************@TK2MSFTNGP14.phx.gbl...
You can't, the object model is part of excel.exe (and it's dependencies).
The only thing you can do is as Nicholas told you, get some limitted
support for this through MDAC and the oledb text provider, you can find a
sample here: http://www.codeproject.com/csharp/Excel_using_OLEDB.asp

Willy.
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:46**********************************@microsof t.com...
How , where to find such an object library or/and examples ?

"Alvin Bruney [MVP - ASP.NET]" wrote:

How about using the excel object library in your applications. I
believe
they are just regular assemblies that provide excel functionality.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
> Can I make an Excel file without having Excel in my PC ?
> I want to create Excel files from my C# application , then open those
> files
> later in another PC who have Excel installed .
> As we can open and read from Access files in C# application without
> having
> Access in this PC in this case we install MDAC , Is there any thing
> similar
> to MDAC for Excel ? if yes where can I download it ? what is the name
> of
> the
> file ?



Nov 17 '05 #8
> But they don't offer Excel functionality, they are simple COM components
that are used to present Charts, Pivot tables, and stuf to the web Actually, they do.

They are full blown excel objects derived from the actual source code of MS
Excel. In fact, the OWC has several advantages over native excel including
support for more rows and columns, formula intigration etc etc. They can run
on windows forms as well as web forms.
but they don't offer any possibility to create/update sheets. OWC supports full interactivity and worksheet, workbook manipulation
including client and in-memory sheets.

If the OWC can do all that, then you are wondering what the catch is right?
licensing regulations keeps most people away from the OWC components.

buy the black book Willy, I hear it's good...

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl... But they don't offer Excel functionality, they are simple COM components
that are used to present Charts, Pivot tables, and stuf to the web, with
data possibly taken from existing Workbooks and Sheets, but they don't
offer any possibility to create/update sheets.

Willy.

"Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
>The only thing you can do is...

nope,
the Office Web Components contains COM servers that are NOT part of the
excel.exe. However, it requires a separate download and installation to
make it work which is more of a burden than a cure IMO.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:ew**************@TK2MSFTNGP14.phx.gbl...
You can't, the object model is part of excel.exe (and it's
dependencies).
The only thing you can do is as Nicholas told you, get some limitted
support for this through MDAC and the oledb text provider, you can find
a sample here: http://www.codeproject.com/csharp/Excel_using_OLEDB.asp

Willy.
"[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
news:46**********************************@microsof t.com...
How , where to find such an object library or/and examples ?

"Alvin Bruney [MVP - ASP.NET]" wrote:

> How about using the excel object library in your applications. I
> believe
> they are just regular assemblies that provide excel functionality.
>
> --
> Regards,
> Alvin Bruney - ASP.NET MVP
>
> [Shameless Author Plug]
> The Microsoft Office Web Components Black Book with .NET
> Now available @ www.lulu.com/owc, Amazon.com etc
> "[Yosi]" <Yo**@discussions.microsoft.com> wrote in message
> news:10**********************************@microsof t.com...
> > Can I make an Excel file without having Excel in my PC ?
> > I want to create Excel files from my C# application , then open
> > those
> > files
> > later in another PC who have Excel installed .
> > As we can open and read from Access files in C# application without
> > having
> > Access in this PC in this case we install MDAC , Is there any thing
> > similar
> > to MDAC for Excel ? if yes where can I download it ? what is the
> > name of
> > the
> > file ?
>
>
>



Nov 17 '05 #9

"Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
news:eS******************@tk2msftngp13.phx.gbl...
But they don't offer Excel functionality, they are simple COM components
that are used to present Charts, Pivot tables, and stuf to the web

Actually, they do.

They are full blown excel objects derived from the actual source code of
MS Excel. In fact, the OWC has several advantages over native excel
including support for more rows and columns, formula intigration etc etc.
They can run on windows forms as well as web forms.
but they don't offer any possibility to create/update sheets.

OWC supports full interactivity and worksheet, workbook manipulation
including client and in-memory sheets.

If the OWC can do all that, then you are wondering what the catch is
right?
licensing regulations keeps most people away from the OWC components.

buy the black book Willy, I hear it's good...

--

Alvin,
Looks like I'm badly mistaken here, thanks for correcting me, I placed an
order for the book. I've spent some time with the first version of OWC and I
remember this one required Office to be installed on the client, didn't know
this was simply a "licensing" issue. I had the impression this was needed
for some automation functionality with Office servers like Excel.

Willy.
Nov 17 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Marty | last post: by
14 posts views Thread by pmud | last post: by
3 posts views Thread by DC Gringo | last post: by
2 posts views Thread by C | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.