Ad:

C# Discussion Thread
Unsolved
Views: 3672

Sep 29th, 2008

Import data from .csv and save in separate sheet in .xls

Expand Post »

Hi,

I'm new to C#. Can any one help with extracting info from a few .csv files and insert them into DIFFERENT sheet in excel(not necessary .xls format. .csv is fine). I'm not asking for the whole piece of coding. Just need some idea on where to start.

Thanks!

raul15791

Reputation Points: 37

Solved Threads: 7

Junior Poster

Offline

102 posts
since Jun 2008

Permalink

Sep 29th, 2008

Re: Import data from .csv and save in separate sheet in .xls

What code do you have?

LizR

Reputation Points: 196

Solved Threads: 190

Posting Virtuoso

Offline

1,735 posts
since Aug 2008

Permalink

Sep 30th, 2008

Re: Import data from .csv and save in separate sheet in .xls

Hi,

I have my own dataset of data. Just wonder what function can I use to write into a excel file. For my current coding, I'm writing the data into several .csv files. Now I'm trying to write all these data into separate sheets in excel (.xls). Here my old piece of coding (store data in csv format):

C# Syntax (Toggle Plain Text)
StreamWriter writer = File.CreateText(strDirectory + FileName); 
            writer.WriteLine();
            writer.WriteLine("Sheet Name");
            writer.WriteLine();
            writer.WriteLine("Column 1,Column 2, Column 3, Column 4");
 
            foreach (DataRow dr in dtable.Rows)
            {   writer.Write(dr[0]);
                writer.Write(",");
                writer.Write(dr[1]);
                writer.Write(",");
                writer.Write(dr[2]);
                writer.Write(",");
                writer.Write(dr[3]);
                writer.WriteLine();
            }
StreamWriter writer = File.CreateText(strDirectory + FileName); 
            writer.WriteLine();
            writer.WriteLine("Sheet Name");
            writer.WriteLine();
            writer.WriteLine("Column 1,Column 2, Column 3, Column 4");
       
            foreach (DataRow dr in dtable.Rows)
            {   writer.Write(dr[0]);
                writer.Write(",");
                writer.Write(dr[1]);
                writer.Write(",");
                writer.Write(dr[2]);
                writer.Write(",");
                writer.Write(dr[3]);
                writer.WriteLine();
            }

raul15791

Reputation Points: 37

Solved Threads: 7

Junior Poster

Offline

102 posts
since Jun 2008

Permalink

Sep 30th, 2008

Re: Import data from .csv and save in separate sheet in .xls

Well csv format (which you're writing out, and theres a quicker way to do that, look at the join function) cannot do multiple excel sheets, the only thing that does multiple sheets is excel. For which you would need to use the excel object.

Take a look, theres been some posts in here about working with excel direct.

LizR

Reputation Points: 196

Solved Threads: 190

Posting Virtuoso

Offline

1,735 posts
since Aug 2008

Permalink

Oct 6th, 2008

Re: Import data from .csv and save in separate sheet in .xls

Yeah... I decide to save everything into a single excel file directly.

Thanks anyway...

raul15791

Reputation Points: 37

Solved Threads: 7

Junior Poster

Offline

102 posts
since Jun 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: C# Help! Arrays, ListBox's and Buttons

Next Thread in C# Forum Timeline: Overload Constructer Using Arrays

DaniWeb Message

Cancel Changes

User Name
Password