Re: excel

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" <kemal.taskin@xxxxxxxxxx> wrote in message
news:u0GRjCKUFHA.3952@xxxxxxxxxxxxxxxxxxxxxxx
> 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 kemaltaskin@xxxxxxxxx
> you can also send e-mail to me. thank you very much
>
> -kemal
>
>


.

Relevant Pages

  • Re: I believe Ive found an Access bug...can anyone confirm?
    ... Set objXL = CreateObject ... and use the Excel function from Access. ... Dim IRRValues() As Variant ' Set up array. ...
    (microsoft.public.access.modulesdaovba)
  • Fastert way to work with data from Excel
    ... which reads data from MS Excel and store it in text ... I use a two dimensional array in which I store the contents of Excell cell, ... StreamWriter i do another For loop to add a vbCrLf at the end of each row. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to calculate frequency of lottery numbers?
    ... Microsoft MVP Excel ... I downloaded the previous 100 PowerBall games ... array K1:K59. ... histogram to visually display the frequencies ...
    (microsoft.public.excel.newusers)
  • Re: creating Excel Application Object in C#?
    ... This article demonstrates how to automate Microsoft Excel by using ... you can retrieve a two-dimensional array of values for ... errorMessage = String.Concat(errorMessage, ...
    (microsoft.public.excel.programming)
  • Re: I believe Ive found an Access bug...can anyone confirm?
    ... The from-to array declaration syntax is such an improvement ... IRRCashFlowA = 957.55 ... calculated directly from Excel 2007. ... Dim IngSizeA As Long ...
    (microsoft.public.access.modulesdaovba)