General downloads

Open Xml Excel Library - NAV2013

Author
4BzSoftware  
Category
General downloads
Date
30/09/2014
First release
29/04/2014
Size
3,56 MB
Tags
excel
Downloads
1862
MD5 digest
4A7F03ACAA6604D498871D230F985FC6
Rating
32121
Popularity
Downloaded 11 times in the last two weeks

Navision 2013 replaces Excel Automation by Open Xml Spreadsheet technique to increase performance and align with web environment. However, it is a challenge to master and enhance Open Xml Spreadsheet in C/SIDE. To make it easy, we would like to introduce our solution which is pure Open Xml:
- Support input Value, Formula, Format Value, Format Cell more than 250 characters.
- Support Format Value for Text, Number, Date, Time .
- Support Format Cell:
+ Font Bold, Italic, Underline, Double Underline.
+ Font Name, Size, Color by Theme and Rgb.
+ Back Color by Theme and Rgb.
+ Border Around, Horizontal, Vertical, Top, Bottom, Left, Right, Diagonal Up, Diagonal Down with Style, Color by Theme and Rgb.
+ Border Styles are None, Thin, Medium, Dashed, Dotted, Thick, Double, Hair, MediumDashed, DashDot, MediumDashDot, DashDotDot, MediumDashDotDot, SlantDashDot.
- Refresh Formula Cells automatically.
- Support Web Client.

You can list all objects by filtering *S-000* in Version List of Object Designer. Page 4 Payment Terms is starting point where you can find how to operate it:
- Create new Workbook.
- Update existed Workbook with user interaction or silence.
- Read book with user interaction or silence.

Update 28/09/2014:
- Quick installation guide and include OpenXml Platform Hotfix files.
- Show or Hide % completed status to increase speed.
- Better input cells according to cell types.
- Support version 7.0 (2013), all builds.
- Support version 7.1 (2013 R2), all builds.

Update 28/06/2014:
- Relieve headache error when reading and writing Excel file.
- Up-to-date document (section 6).

Update 14/06/2014:
- Release Open Xml Excel Library document (section 6).
- Optimize code to increase performance 80%.
- Manage memory better.
- Stop using Excel Interop DotNet variables.
- Add SetColumnWidth function.
- New Font Color, Back Color and Border Color by Index.

Download this file