I have an Excel template 97-2003 (xls) which contains some VBA macros, format/formula and style and I put it on my web application (ASP.Net MVC, c#) and I'm stuck in writing function 'export data filled in this Excel template without using COM, result format must be *.xls'. And I need to update the VBA macros programmatically tool. I've tried Excellibrary https://code.google.com/p/excellibrary/ but it only save as the cells content. And EPPlus library don't work for xls.
Asked
Active
Viewed 551 times
0
-
1What's wrong with using COM (Office Interop)? This is what it's _for_. – John Saunders May 14 '15 at 02:53
-
Because of my poor hosting and reducing cost from cloud service. Performance of COM is bad for large volume users too – khangcv May 14 '15 at 03:48
-
Hi, I need export to xls not xlsx – khangcv May 14 '15 at 08:51
1 Answers
0
Going with COM interface for MS Excel is the easiest option to write XLS (but please notice that Microsoft is not recommending to use Office components in server-side apps due to some technical and licensing considerations.)
There are couple of 3rd party commercial .NET (with .NET interface) components which are capable of reading and writing XLS:
Disclosure: I am affiliated with ByteScout
