Could you please point me in the right direction?

[chloejacobs]

Hi every1!

My first post on Bytes :)

I want to create a simple web page that will read of CSV file, sort the file by certain fields, take out duplicate entries if 3 fields have the same value and then write the amended csv file to a XLS file?

Is this possible and could you please point me in the right direction?

Kind Regards,
Chloe ~X~

[gits]

in case there is no user-interaction between all the steps you mentioned, then it is quite easier to upload the file to the server, process it there and send back the xls-file ... i assume that a user has the csv file and should get an xls file from it?

kind regards

[chloejacobs]

Hi,

Yeah the user will have the csv file and will upload to the page and then once the duplicates have been removed from the csv they will receive a xls file by downloading it?

Where would i start to achieve this? What should i be reading up on? Is there a csv reader or should i use Stream reader?

Kind Regards,
Chloe ~X~

[gits]

i'm not very familiar with those .NET things but i guess that there are some components that you might use to read a file and produce an xls from it. i just wanted to say that in your current case it is the better way to do all this serverside than trying to do it clientside. may be some of the .NET experts could give you more specific hints for the concrete components that you might use ... a google search for .NET csv reader and writing xls-files gave me a lot of hits ...

kind regards

[Frinavale]

It sounds like you already have a good idea of how to do this.

Upload the file to the server.
Once you have it there, load the file into memory.
Then manipulate the file according to your requirements.
Then save the file.


Just remember that CSV files are comma delimited....

There is tons of stuff on google for this type of thing too...

Once you've attempted the problem and get stuck post back here on Bytes and we'll help you through your problem.

-Frinny

[dorandoran]

on user interface:
Browse for file > Select a File > Read the file > out put to box on the screen

private void openFile_Click(object sender, System.EventArgs e)
{
openFileDialog.ShowDialog();
}

private void openFileDialog_FileOk(object sender, System.ComponentModel.CancelEventArgs e)
{
string fullPathname = openFileDialog.FileName;
FileInfo src = new FileInfo(fullPathname);
filename.Text = src.Name;
source.Text = "";
TextReader reader = src.OpenText();
string line;
while ((line = reader.ReadLine()) != null)
{
source.Text += line + "\n";
}
reader.Close(); // !!! dont forget !!!
}

from MS Press Visual C# Step by step

[Frinavale]

Pssst Dorandoran, this is an ASP.NET application and so there is no OpenFileDialog available ;)