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 ?
9  6580 
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 ?
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 ?
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 ?
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 ?
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 ?
>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 ?
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 ?
> 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 ?
>
>
>
"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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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.
|
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...
|
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...
|
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 =...
|
by: ABC |
last post by:
What methods can export excel file from stored procedure with parameters
which input from web form?
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
