By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,979 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,979 IT Pros & Developers. It's quick & easy.

Export to Microsoft Excel

P: n/a
Hi everyone!

I have a question about exporting data to Microsoft Excel.

I am writing program in C# and have to export some data to excel workbook. It works very good using OLE technology, but it requires Microsoft Excel installed on every machine with my program. It is not quite convenient to do so.

Is there another way to export data to Excel, or how simply create file of Microsoft Excel format from my program (of cause, the format of Excel (.xls) file I do not know).

Thanks.
Igor.
Nov 16 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
I'm not sure whether the Excel drivers will be there on the target machine
if Excel is not installed. You have two options

1. If the Excel OLEDB drivers come with Windows, then you can distribute a
blank Excel worksheet and then use it as the target of your data (as the
drivers can't create Excel files)

2. You could try using CSV as a format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:39**********************************@microsof t.com...
Hi everyone!

I have a question about exporting data to Microsoft Excel.

I am writing program in C# and have to export some data to excel workbook. It works very good using OLE technology, but it requires Microsoft
Excel installed on every machine with my program. It is not quite convenient
to do so.
Is there another way to export data to Excel, or how simply create file of Microsoft Excel format from my program (of cause, the format of Excel
(.xls) file I do not know).
Thanks.
Igor.

Nov 16 '05 #2

P: n/a
I'm not sure whether the Excel drivers will be there on the target machine
if Excel is not installed. You have two options

1. If the Excel OLEDB drivers come with Windows, then you can distribute a
blank Excel worksheet and then use it as the target of your data (as the
drivers can't create Excel files)

2. You could try using CSV as a format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:39**********************************@microsof t.com...
Hi everyone!

I have a question about exporting data to Microsoft Excel.

I am writing program in C# and have to export some data to excel workbook. It works very good using OLE technology, but it requires Microsoft
Excel installed on every machine with my program. It is not quite convenient
to do so.
Is there another way to export data to Excel, or how simply create file of Microsoft Excel format from my program (of cause, the format of Excel
(.xls) file I do not know).
Thanks.
Igor.


Nov 16 '05 #3

P: n/a
Thank you for your responce.

But, i think, that Excel OLEDB driver would not help me. What i want, is to create Microsoft Excel (.xls) file without any help from Excel program. Of cause, i do not know the internal structure of this file type.

What is the CSV format, i never worked with it.

Thanks.
Igor.

"Sriram Krishnan" wrote:
I'm not sure whether the Excel drivers will be there on the target machine
if Excel is not installed. You have two options

1. If the Excel OLEDB drivers come with Windows, then you can distribute a
blank Excel worksheet and then use it as the target of your data (as the
drivers can't create Excel files)

2. You could try using CSV as a format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:39**********************************@microsof t.com...
Hi everyone!

I have a question about exporting data to Microsoft Excel.

I am writing program in C# and have to export some data to excel

workbook. It works very good using OLE technology, but it requires Microsoft
Excel installed on every machine with my program. It is not quite convenient
to do so.

Is there another way to export data to Excel, or how simply create file

of Microsoft Excel format from my program (of cause, the format of Excel
(.xls) file I do not know).

Thanks.
Igor.


Nov 16 '05 #4

P: n/a
I don't think that using the OLEDB driver counts as 'using Excel' so you
might want to take a look at that as an option.

CSV stands for Comma-Separated-Values and as its name implies contains
fields separated by commas. Its a pretty universal file format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:07**********************************@microsof t.com...
Thank you for your responce.

But, i think, that Excel OLEDB driver would not help me. What i want, is to create Microsoft Excel (.xls) file without any help from Excel program.
Of cause, i do not know the internal structure of this file type.
What is the CSV format, i never worked with it.

Thanks.
Igor.

"Sriram Krishnan" wrote:
I'm not sure whether the Excel drivers will be there on the target machine if Excel is not installed. You have two options

1. If the Excel OLEDB drivers come with Windows, then you can distribute a blank Excel worksheet and then use it as the target of your data (as the
drivers can't create Excel files)

2. You could try using CSV as a format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:39**********************************@microsof t.com...
Hi everyone!

I have a question about exporting data to Microsoft Excel.

I am writing program in C# and have to export some data to excel

workbook. It works very good using OLE technology, but it requires Microsoft Excel installed on every machine with my program. It is not quite convenient to do so.

Is there another way to export data to Excel, or how simply create
file of Microsoft Excel format from my program (of cause, the format of Excel
(.xls) file I do not know).

Thanks.
Igor.


Nov 16 '05 #5

P: n/a
I'll try to work with OLEDB driver.

Of cause, CSV format is simple, but it is not useful for my program.

Thanks.
Igor


"Sriram Krishnan" wrote:
I don't think that using the OLEDB driver counts as 'using Excel' so you
might want to take a look at that as an option.

CSV stands for Comma-Separated-Values and as its name implies contains
fields separated by commas. Its a pretty universal file format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:07**********************************@microsof t.com...
Thank you for your responce.

But, i think, that Excel OLEDB driver would not help me. What i want, is

to create Microsoft Excel (.xls) file without any help from Excel program.
Of cause, i do not know the internal structure of this file type.

What is the CSV format, i never worked with it.

Thanks.
Igor.

"Sriram Krishnan" wrote:
I'm not sure whether the Excel drivers will be there on the target machine if Excel is not installed. You have two options

1. If the Excel OLEDB drivers come with Windows, then you can distribute a blank Excel worksheet and then use it as the target of your data (as the
drivers can't create Excel files)

2. You could try using CSV as a format

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Igor" <Ig**@discussions.microsoft.com> wrote in message
news:39**********************************@microsof t.com...
> Hi everyone!
>
> I have a question about exporting data to Microsoft Excel.
>
> I am writing program in C# and have to export some data to excel
workbook. It works very good using OLE technology, but it requires Microsoft Excel installed on every machine with my program. It is not quite convenient to do so.
>
> Is there another way to export data to Excel, or how simply create file of Microsoft Excel format from my program (of cause, the format of Excel
(.xls) file I do not know).
>
> Thanks.
> Igor.


Nov 16 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.