excel

[Kemal Taskin]

Hi all, this question should go to excel newsgroup
however it is related to .NET also. anyway..

In a web page written with C# I read excel files
and store them into a table in an MSSQL Server 2000
db.

I read this excel file from db into a byte []. Now, how can I
convert this byte [] to a two dimensional array, such as a DataTable?

I think I need a code that parses Excel documents from a byte[]

My e-mail is (e-mail address removed)
you can also send e-mail to me. thank you very much

-kemal

 

[Mircea Pleteriu]

I do not know if I understand correctly your problem.

Get the array of bytes from db, store them to a file and open the file with
the Excel object.

 

[Kemal Taskin]

no, get byte array from db (that is easy), print it on the web page.
and this byte array represents an excel file, which has (in its simplest
terms)
contains two dimensional data in its (say first) sheet.

hence everything happens in a single web page.

I do not know if I understand correctly your problem.

Get the array of bytes from db, store them to a file and open the file with
the Excel object.

Hi all, this question should go to excel newsgroup
however it is related to .NET also. anyway..

In a web page written with C# I read excel files
and store them into a table in an MSSQL Server 2000
db.

I read this excel file from db into a byte []. Now, how can I
convert this byte [] to a two dimensional array, such as a DataTable?

I think I need a code that parses Excel documents from a byte[]

My e-mail is (e-mail address removed)
you can also send e-mail to me. thank you very much

-kemal

 

[Mircea Pleteriu]

Get some info about ActiveXObject javascript object. Maybe it helps.

no, get byte array from db (that is easy), print it on the web page.
and this byte array represents an excel file, which has (in its simplest
terms)
contains two dimensional data in its (say first) sheet.

hence everything happens in a single web page.

I do not know if I understand correctly your problem.

Get the array of bytes from db, store them to a file and open the file with
the Excel object.

Hi all, this question should go to excel newsgroup
however it is related to .NET also. anyway..

In a web page written with C# I read excel files
and store them into a table in an MSSQL Server 2000
db.

I read this excel file from db into a byte []. Now, how can I
convert this byte [] to a two dimensional array, such as a DataTable?

I think I need a code that parses Excel documents from a byte[]

My e-mail is (e-mail address removed)
you can also send e-mail to me. thank you very much

-kemal

 

[Mark Rae]

I think I need a code that parses Excel documents from a byte[]

Can't you just use theOleDb provider...?

 

[Guest]

Hi Kemal,

I think the better way is to read data in excel (use ADO.NET) rather than
whole file into a datatable, then save the data into SQL Server DB.

HTH

Elton Wang
(e-mail address removed)

 

[Kemal Taskin]

is there an easy way to do this? i actually do not know.
how can you do it with OleDb?

I think I need a code that parses Excel documents from a byte[]

Can't you just use theOleDb provider...?

 

[Kemal Taskin]

that is what i am considering to do next.
however i had to prefer the first one because
of performance considerations. thank you anyway.

Hi Kemal,

I think the better way is to read data in excel (use ADO.NET) rather than
whole file into a datatable, then save the data into SQL Server DB.

HTH

Elton Wang
(e-mail address removed)

Hi all, this question should go to excel newsgroup
however it is related to .NET also. anyway..

In a web page written with C# I read excel files
and store them into a table in an MSSQL Server 2000
db.

I read this excel file from db into a byte []. Now, how can I
convert this byte [] to a two dimensional array, such as a DataTable?

I think I need a code that parses Excel documents from a byte[]

My e-mail is (e-mail address removed)
you can also send e-mail to me. thank you very much

-kemal

 

[Mark Rae]

is there an easy way to do this? i actually do not know.
how can you do it with OleDb?

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2004-51,GGLD:en&q=Excel+OleDb