Reading an Excel file using OWC

[Raghunandan HJ]

Many thanks to Microsoft for OWC. It has made programmers life that easy with
office components over web.

We have recently started working with OWC. Producing Charts, Excel files are
beautiful. But, how to read an excel file using OWC.
There are many ways of reading it like Jet engine or Excel 11 [needs excel
to be installed]. Jet engine cannot understand merged and formatted cells. It
just reads and throws the infomation in to a data container.

Now if I want to read a formatted Excel file/sheet using OWC what should I
do?

Thanks

 

[Alvin Bruney - ASP.NET MVP]

unfortunately, this is not possible. You will need to convert the file to a
format such as CSV

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET