Open Xml Excel Library - NAV2013
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 silencehttp://www.mibuso.com/dlinfo.asp?FileID=1581
Discuss this download here.