is there other ways to get data out from excel using ASP.NET

[bang2711]

hi guy,. i have some problem here. i want to get my data out as a string or using sql but i cannot find any source of it. i dont wan to use datagrid. is there other way.? i need to use a Response.Write(content) to write the data out.. please help me asap.. _________________ regards bang

[god_bless_the_world]

Save the Excel sheet as a CSV(Comma seperated value). You can then parse the csv file and manipulate the contents and display it. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

[bang2711]

u mean i can change using asp.net coding to CSV? cos after i can get the data out from the excel i later still need to change the data from excel. and how to manipulate the contents and display it. sorry i new to asp.net.. thanks and regards bang

[god_bless_the_world]

You should save the .xls file as a .csv file. Then give the .csv file as the input to your program. You can parse the .csv file like the way you parse a text file. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

[bang2711]

MM.. but if later part i hav to update my excel.. will it affect the coding or CSV file? do u hav any small sample to see.?