search

codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

ExcelQueryFactory instanciation with stream would be great! #38

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
LinqToExcel version 1.5.

I have no files but streams on the server. I would deprecate saving it as a 
file in order to load it...

So a constructor for ExcelQueryFactory with a stream parameter, or a method to 
load datas from a stream would be appreciated.

Without this, I won't be able to use your project...

Cheers

Original issue reported on code.google.com by dargo...@gmail.com on 21 Apr 2011 at 8:43

GoogleCodeExporter commented 8 years ago 
Unfortunately this is not possible. LinqToExcel uses the Jet OLEDB driver to 
retrieve data from a spreadsheet and that driver does not work with streams. It 
only works with files.

Have you thought about saving the stream to a temporary file and deleting it 
after you're done?

Original comment by paulyo...@gmail.com on 21 Apr 2011 at 1:19