So in the post Will Python replace VBA as the inbuilt scripting language of Excel? a few days ago I listed suggestions of Python libraries for working with Excel amongst which there are libraries to create an Excel workbook on a server.
Server Side Excel has long been a controversial matter. I have worked on many systems that build workbooks from templates and source repositories. Linux does not run Excel.exe so it is a good trick if one can generate an Excel workbook server-side without actually running Excel.exe. It is worth compiling a list of alternative Server Side technologies and so as I find them I will keep a list here. Feel free to use the comments to suggest others.
- Open XML SDK 2.5 for Office - MS .NET libraries in theory (I have not verified) can run on Mono and so Linux
- EPPPlus - is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx).
- openpyxl - A Python library to read_write Excel 2010 xlsx_xlsm files — openpyxl 2.4.9 documentation
- Excel Writer (XML) for PHP
- Mikes Knowledge Base - Export to Excel
- ASPOSE: C# ASP.NET Excel Spreadsheet Programming API for XLS XLSX CSV ODS
- NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
- Apache POI - the Java API for Microsoft Documents
Sources:
- .net - Create Excel (.XLS and .XLSX) file from C# - Stack Overflow
- Create Excel files from C# without office - Stack Overflow
Archaeology
The Internet never forgets and so here are some older relics placed here for completion
No comments:
Post a Comment