vb.net Create excel sheet without Excel
Posted on 2011-04-29
I am looking for a way to reading and writing to excel sheets without the requirement of a specific Excel version being installed on the client PC. Even though the PC will most likely have some version Excel installed, my company isn't locked down to one particular version. That has caused me problems in the past.
To read excel sheets i have been using ODBC and that works fine, but i would like to come up with some standard way of being able to create excel sheets and not have to depend on the PC's installed version.
I have seen a few 3rd part components that would seem to be what i am looking for. Does anyone have any experience with these components or another method? To give a little scope, i don't need to be doing anything too complex with the sheets. Just reading, writting, and some basic formatting..
Any suggestions on components (you have actual experience with) or alternative methods of accomplishing my goal are appreciated.