How do i export a collection list to an already existing worksheet in an excel workbook

Question

1.00/5 (1 vote)

See more:

Hi guys i have a collection list that contains data, i want to export the data in the collection list to a sheet in an already existing excel file. How do i do that?

Posted 20-Sep-12 9:17am

IamBlessed

Add a Solution

4 solutions

Solution 2

EPPlus[^] is a nice library, and the accompanying examples shows you how to do this.

Best regards
Espen Harlinn

Posted 20-Sep-12 9:38am

Espen Harlinn

Comments

Sergey Alexandrovich Kryukov 20-Sep-12 18:35pm

My 5.
--SA

Espen Harlinn 21-Sep-12 3:31am

Thank you, Sergey :-D

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kenneth Haugland · Accepted Answer · 2012-09-20T09:19:00

Solution 1

I would use Sheet.UsedRange and then hard code to find out were you want to add the cells. You dont give us much code to go on so,:

See sample here:
http://support.microsoft.com/kb/302084[^]

Good luck

Posted 20-Sep-12 9:19am

Kenneth Haugland

Updated 20-Sep-12 10:17am

v2

Comments

IamBlessed 20-Sep-12 15:28pm

Have not writing any single code on exporting to excel, and the excel sheet is empty. I hav virtually no clue on what to do

Kenneth Haugland 20-Sep-12 15:31pm

You should take a look here then: http://support.microsoft.com/kb/302084

Maciej Los 20-Sep-12 17:01pm

UsedRange (object type of Range) is the collection of used cells in a worksheet. It can be one or more ranges (collections of data), for example: A1:C300 and E1:AH5000. In this case UsedRange object will contains cells: A1:AH5000.
Do you know what i mean?

Kenneth Haugland 20-Sep-12 17:07pm

I guess so, If cell(1,1) is in use, and cell(69000,69000) is in use the UsedRange will returne a 69000 * 69000 values.

But as he was going to make and rewrite the excel sheet from application, i dont think thats a problem.

Maciej Los · Accepted Answer · 2012-09-20T11:38:00

If you would like to replace existing data, you need to go through these steps:
1) Create the instance of MS Excel application. How? You can use Interop[^] or OLE Automation[^].
2) Open existing workbook,
3) Clear existing data,
4) Export data from your application, using for .. next loop or CopyFromRecordset[^] method for Range object. Personally, i prefer CopyFromRecordset because it's quick ;)
5) Save and close the workbook. Use Close[^] method with parameter SaveChanges:=True

That's all! Good luck ;)

Examples:
Opening and Navigating Excel with C#[^]
http://csharp.net-informations.com/excel/csharp-open-excel.htm[^]

If you would like to add some data in to existing collection, please let me know.

Lacy00 · Accepted Answer · 2012-09-20T16:39:00

Solution 4

Hello I think this article can help you much, it uses a free data export component, see details:
Exporting Data to Excel[^]

Posted 20-Sep-12 16:39pm

Lacy00

How do i export a collection list to an already existing worksheet in an excel workbook

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

How do i export a collection list to an already existing worksheet in an excel workbook

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us