Reading Excel Files MSOffice vs Open Office
I have an application the reads excels files and move them to my MS SQL database, via C#. This is a done on a machine that host the MSSQL Server as well as an IIS Arcgis Server. The machine is not very strong only 3gb of RAM and the prospects开发者_运维技巧 of them giving me a true server seem close to to nil. So I wanted to know which one option is less demanding , memory wise. OpenOffice or MS Excel.
Neither - use the OleDb provider. It's much simpler and faster. But between the two options you proposed, MS Excel is almost certainly going to be less memory intensive.
精彩评论