472,794 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,794 software developers and data experts.

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
9 6538
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Whoever | last post by:
To create Excel file, you can Add Reference Visual Studio.NET, browse to ... and then select Microsoft.Office.Interop.Excel, etc. It endsup some reference to GUID in project file. You can then...
1
by: Marty | last post by:
Is there a way to manually copy an excel cell range to a datagrid column? I am unable to select the whole column and selecting multiple whole records does not work. Thx.
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
3
by: DC Gringo | last post by:
Allison (or others), thank you for the advice...a few more questions: - I have tested on my workstation on Excel XP and my application references the Excel 10.0 Object Library. I was told the...
2
by: C | last post by:
Hi, I have a dataset which I bind to a datagrid on my ASPX. I then export the datagrid to Excel and stream the file to the user by setting the MIME Type etc etc. Response.ContentType =...
3
by: ABC | last post by:
What methods can export excel file from stored procedure with parameters which input from web form?
0
by: eolmos | last post by:
Hello everyone, I am currently working on a project that requires a webform in asp.net using C# as the code behind. The page must allow the user to create a report in excel. This report must also...
2
by: Manikandan | last post by:
Hi, I have a program written in .Net Framework 1.1 using Visual studio enterprise edition 2003. I tried compiling the same program in visual c# express edition 2005. I'm getting following...
1
by: Manikandan | last post by:
Hi, I have a question reg excel interop. I have no excel installation(office installation) in my system I'm using office web components in my application. is there any help available to use...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.