Author Topic: Is there a way to import excel from a stream/byte array?  (Read 1800 times)

rbegley

  • Newbie
  • *
  • Posts: 1
    • View Profile
Is there a way to import excel from a stream/byte array?
« on: July 20, 2018, 02:08:15 am »
I have excel workbooks stored in a Sql Server database as varbinary(max) fields. Is there an easy way to import/stream that into the Param Query grid on a page load?  (ASP.NET MVC Environment)

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6263
    • View Profile
Re: Is there a way to import excel from a stream/byte array?
« Reply #1 on: July 20, 2018, 11:31:26 pm »
yes but only if the Excel files are originally in xlsx format.