<div>
Figured it out (assumes fileBinary from database):<br />
<br />
MemoryStream excelMemStream = new MemoryStream();<br />
<br />
excelMemStream.Write(fileB<wbr />inary, 0, fileBinary.Length);<br />
<br />
&nbsp;SpreadsheetDocument mySpreadsheet = SpreadsheetDocument.Open(e<wbr />xcelMemStr<wbr />eam, false);<br />
<br />
Although, this seems slow. &nbsp;Anyone know faster solution?
</div>


Figured it out (assumes fileBinary from database):

MemoryStream excelMemStream = new MemoryStream();

excelMemStream.Write(fileBinary, 0, fileBinary.Length);

 SpreadsheetDocument mySpreadsheet = SpreadsheetDocument.Open(excelMemStream, false);

Although, this seems slow.  Anyone know faster solution?

<div>
<div class="content wysiwyg-content">
I am working with a c# in visual studio 2010 and MS SQL Server 2008 R2.<br />
<br />
Another application is inserting .xlsx files into an SQL table as varbinary(max). &nbsp;I need to pull these from the table and read the contents as if they are .xlsx files.<br />
<br />
First, do I read these as byte[] to get the varybinary out of the database?<br />
<br />
Then, once I have my file binary/byte string how to I convert this to a file that can be read as an excel workbook in C# with the SpreadsheetDocument class (using DocumentFormat.openxml, openxml.packaging, and openxml.spreadsheet).<br />
<br />
Thanks!
</div>
</div>


I am working with a c# in visual studio 2010 and MS SQL Server 2008 R2.

Another application is inserting .xlsx files into an SQL table as varbinary(max).  I need to pull these from the table and read the contents as if they are .xlsx files.

First, do I read these as byte[] to get the varybinary out of the database?

Then, once I have my file binary/byte string how to I convert this to a file that can be read as an excel workbook in C# with the SpreadsheetDocument class (using DocumentFormat.openxml, openxml.packaging, and openxml.spreadsheet).

Thanks!

c# reading varbinary or byte[] to .xlsx

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.