I have an asp.net WCF Service, my client application is going to send me excel file as byte array. I have to read those bytes and upload data in the database.
Microsoft Jet, or Ace drivers take the excel file name, is there any way that I can read those excel file bytes directly without storing the file in my file system.
Here I am at the destination side, so I receive excel in byte array format. Then I want to read that array similar to the way we read from excel file using jet or ace drivers.
Is there any way that I can read from a byte array (the byte array created by excel file and I should be able to read the data as if I am reading from an excel file (like row wise and column wise)), actually I am reading from byte array or memorystream created by byte array.
I am able to create memory stream from byte array, but I am unable to read as if I am reading from excel. One more important thing, I dont want to save my file on to the file system, if I save on to file system, I am able to read using oledb jet or ace drivers, but I dont want to save on to the file system.
Is there any way to do that?
I have to update in the database that part I will take care.
I thought you just wanted to store the file. Yes You can do that, but i don't how.
Guess you cross that road when you get to it. if your able to store the byte array.
With all do respect, meaning something else
I find it hard to believe that your selling services that you have no clue how to do.
I don't mind helping you, but eventually you need to give something back to CJ, like answer some questions for other OPs, and not be a pure consumer
This reads the dimensions of a flash file from a pure byte stream, just an in insight into what you wish to achieve. I have no interest in reading a excel file, so I'm stopping here at this point. When you ready to ready bytes and translate them into bits, let me know.